Spreadsheets 뉴스

템플릿으로 Excel 스프레드시트를 빠르게 생성합니다

4월 19, 2024
Document Solutions for Excel v7.1은 성능 및 안정성을 개선하고 더 다양한 사용자 요구를 처리하기 위해 리팩터링된 DsExcel 템플릿을 제공합니다.

Document Solutions for Excel, .NET Edition (DsExcel) is a high-performance spreadsheet API library that enables .NET developers to create, manipulate, and generate Excel documents within their applications entirely independent of Microsoft Excel. DsExcel boasts a fast and lightweight design and features cross-platform and cross-framework compatibility. It includes a powerful calculation engine that handles over 450 Excel functions and allows for the creation of custom functions for complex calculations.

The Document Solutions for Excel v7.1 update includes enhancements to DsExcel templates which prioritize performance and stability to cater to a broader range of use cases. This includes improved handling of missing data sources, new OverwriteFillFormat functionality to operate in both Pagination and non-Pagination modes, expanded support for image and shape elements, optimized processing for merged cells, and backwards compatibility with older templates to ensure a smooth transition for existing users.

To see a full list of what's new in v7.1.0, see our release notes.

Document Solutions for Excel, .NET Edition is licensed per developer and is available in several license options for differing distribution needs. Team licenses are also available for multiple developers within the same organization. See our Document Solutions for Excel, .NET Edition licensing page for full details.

Learn more on our Document Solutions for Excel, .NET Edition product page.

셀에서 직접 WPF 스프레드시트 데이터를 편집할 수 있습니다

4월 16, 2024
셀에서 직접 편집하면 별도의 데이터 입력 필드가 필요하지 않으므로 더 빠르고 직관적으로 데이터를 입력하고 수정할 수 있습니다.

In-cell data editing refers to the functionality within spreadsheet software that allows users to directly click on and modify the contents of a cell without the need for separate data entry forms or pop-up dialogs. This feature allows for quicker and more direct changes to the data displayed on the screen, enhancing productivity by reducing the steps required for data manipulation.

Several .NET 8 WPF spreadsheet controls support in-cell data editing including:

  • DevExpress WPF Spreadsheet (part of DevExpress WPF), lets you directly edit cell data with robust validation and conditional formatting options in the WPF environment.
  • Spread WPF (part of Spread.NET by MESCIUS) facilitates seamless in-cell data manipulation and real-time calculation updates, enhancing productivity for WPF applications.
  • Telerik WPF Spreadsheet (part of Telerik UI for WPF), enables efficient data entry and editing within cells, complete with support for formulas and data formats in WPF.
  • MindFusion.Spreadsheet for WPF allows users to easily modify and manage cell content interactively, supporting complex data types and customization in WPF.

For an in-depth analysis of features and price, visit our comparison of .NET 8 WPF Spreadsheet Controls.

Compare .NET 8 WPF Spreadsheet Controls

추가 기능으로 JavaScript 스프레드시트를 강화하세요

4월 9, 2024
MESCIUS사의 SpreadJS는 데이터 분석, 프로젝트 관리, 보고서 디자인 기능을 통해 기능을 향상시키는 추가 기능 옵션을 제공합니다.

SpreadJS is a complete enterprise JavaScript spreadsheet solution used to create financial reports and dashboards, budgeting and forecasting models, scientific, engineering, healthcare, education, science lab notebooks, and other similar JavaScript business applications. Leverage the high-speed calculation engine with over 500 Excel built-in functions in 19 languages, to deliver true Excel-like spreadsheet experiences with zero dependencies on Excel. Fully customize your application’s needs with SpreadJS’s optional deployment add-on components for Pivot Tables UI, and an Excel-like Designer ribbon, allowing your users to perform complex interactive analysis and data visualization.

MESCIUS has created a brief but informative video blog that highlights the functionality of these powerful add-ons:

  • Designer Ribbon - for seamless toolbar integration
  • PivotTable - for robust data analysis
  • GanttSheet - for project management
  • ReportSheet - for easy report design

View the Video Blog and learn how to effortlessly upgrade your JavaScript spreadsheets.

SpreadJS is licensed per developer and includes 1 Year Maintenance (major and minor version releases and unlimited support phone calls). SpreadJS requires an Annual or Perpetual Deployment License. The optional Add-ons are available at an additional cost, and require a SpreadJS license. See our SpreadJS licensing page for full details.

For more information, visit our SpreadJS product page.

대규모 데이터 세트를 동적으로 요약하세요

4월 4, 2024
.NET 스프레드시트 컨트롤의 피벗 테이블 기능을 활용하면 애플리케이션 내 데이터 탐색 및 분석을 간소화할 수 있습니다.

.NET spreadsheet controls with built-in pivot table functionality empower developers to seamlessly integrate robust data analysis into their applications. This feature allows users to effortlessly rearrange and aggregate large datasets, gaining insights through customizable views without modifying the original data. Pivot tables streamline decision-making by simplifying complex tasks like sorting, filtering, and visualizing information, ultimately enhancing the usability and effectiveness of these spreadsheet applications.

Several .NET Spreadsheet controls support pivot tables including:

  • DevExpress WPF Spreadsheet (part of DevExpress WPF) offers advanced pivot table functionality for dynamic data analysis, enhancing usability and decision-making.
  • Document Solutions for Excel, .NET Edition by MESCIUS enables seamless integration of pivot tables into .NET applications for efficient data summarization and analysis tasks.
  • Aspose.Cells for .NET provides robust pivot table functionality, allowing developers to efficiently summarize and analyze large datasets within their .NET applications.
  • EPPlus empowers developers with pivot table capabilities in Excel files, facilitating dynamic data analysis within .NET applications effortlessly.

For an in-depth analysis of features and price, visit our comparison of .NET Spreadsheet Controls.

Compare .NET Spreadsheet Controls

앱에 고급 계산 기능을 추가하세요

3월 22, 2024
Document Solutions for Excel API는 내장된 Excel 함수를 이용하는 고급 데이터 분석을 통해 .NET 애플리케이션을 강화합니다.

Document Solutions for Excel, .NET Edition (DsExcel, previously GcExcel) is a high-speed, small-footprint, server-side spreadsheet API that requires no dependencies on Excel. With full .NET support, you can generate, load, modify, and convert spreadsheets in .NET, .NET Framework, .NET Core, Mono, and Xamarin. Apps using the spreadsheet API can be deployed to cloud, Windows, Mac, or Linux. Its powerful calculation engine and breadth of features means you'll never have to compromise design or requirements. The interface-based API is modeled on Microsoft Excel's document object model which means you can import, calculate, query, generate, and export any spreadsheet scenario.

Formulas and functions play an important role in data analysis. Microsoft Excel provides a range of functions that simplify the extraction of key metrics during data analysis. In this pair of blog posts from MESCIUS, Software Engineer Prabhat Sharma demonstrates how to use DsExcel to implement Excel functions and other Excel-like functionalities.

Part 1 of the blog shows you how to drill into sales data and integrate the following functions:

  • LOOKUP and Reference Functions
  • FILTER Function
  • TRANSPOSE Function

Part 2 of the blog digs into monthly budget data to show you how to use:

  • SUBTOTAL
  • CHOOSEROWS/CHOOSECOLS
  • SUMIF/AVERAGEIF
  • PMT/PPMT/IPMT
  • IF combined with AND/OR

Document Solutions for Excel is licensed per developer for either one distribution location or unlimited distribution locations. Licenses are perpetual, and include a one year subscription for all software releases (including hotfixes and major releases) plus Platinum Support. See our Document Solutions for Excel, .NET Edition licensing page for full details.

Learn more about Document Solutions for Excel, .NET Edition.