Spreadsheets 新闻

在 .NET 电子表格应用中计算数据透视表

7月 2, 2024
EPPlus v7.2.0 添加对从数据透视表计算和提取数据的支持，使 .NET 开发人员能够直接在其程序中创建数据透视表。

EPPlus is a powerful and versatile .NET library for managing and manipulating Microsoft Excel files using the Office Open XML (OOXML) format. It is a lightweight and efficient library that is easy to use and can be integrated into a wide range of applications. It allows developers to create, read and modify spreadsheets without dependencies on any other library. Features include pivot tables, styling, VBA/Form controls, conditional formatting, charts, tables, formula calculation, data validation, pictures/shapes, and more.

The EPPlus v7.2.0 update adds support for calculating and fetching data from pivot tables, allowing .NET developers to enhance the data analysis capabilities of their applications. This feature allows developers to dynamically summarize, analyze, and present large datasets by creating and manipulating pivot tables programmatically. It includes the ability to define calculations (sum, average, etc.) for rows and columns, format values as percentages or differences, and apply various filters (captions, numbers, dates, etc.) and sorting options. This streamlines data analysis workflows and fosters greater control over the final spreadsheet output, empowering developers to deliver more powerful data-driven solutions.

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

EPPlus is licensed per developer and is available as both perpetual licenses and subscription based licenses with periods of 1 year and 2 years, which include support and upgrades. See our EPPlus licensing page for full details.

For more information, see our EPPlus product page.

用条件格式突出显示见解

6月 19, 2024
支持条件格式的 ASP.NET Core 电子表格控件可以更轻松地分析数据、关键问题、模式和趋势。

Conditional formatting in a spreadsheet component allows you to dynamically alter the visual appearance of cells based on predefined rules. This functionality enhances data readability by highlighting specific values or trends within your spreadsheet. By visually differentiating critical information, conditional formatting empowers developers to create more user-friendly and informative data presentations within their ASP.NET applications.

Several ASP.NET Core Assembly Spreadsheet Controls offer Conditional Formatting including:

  • DevExpress ASP.NET Core Spreadsheet (part of DevExpress for ASP.NET) integrates conditional formatting for visually distinct data.
  • Telerik Spread Processing (part of Telerik UI for ASP.NET Core) provides developers with programmatic control of conditional formatting for tailored user experiences.
  • IronXL by Iron Software simplifies data interpretation with conditional formatting features that elevate spreadsheet clarity.
  • Infragistics ASP.NET Core Spreadsheet (part of Infragistics Ignite UI) integrates user-defined conditional formatting rules to enhance data readability in web applications.

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

Compare ASP.NET Core Assembly Spreadsheet Controls

将 Excel 功能合并到 Python 项目中

6月 18, 2024
IronXL for Python via .NET 是一个使 Python 开发人员能够将电子表格功能集成到其应用程序中的 Excel 库。

IronXL for Python via .NET by Iron Software is a Python Excel library designed to enable Python developers to manipulate, read and generate Microsoft Excel files easily by leveraging the .NET framework. It allows them to integrate Excel functionality into Python applications without requiring Microsoft Office or Excel Interop to be installed on the server or client machines. This standalone solution provides a comprehensive API for reading, creating, and editing Excel files (XLS, XLSX, XLSM, CSV, TSV, etc.) directly from Python code.

IronXL offers a compelling alternative for developers seeking an efficient and versatile solution for spreadsheet manipulation in Python environments. It facilitates the automation of report generation, data analysis, and financial modeling, all within a familiar Excel format but executed through Python scripts. It simplifies complex tasks like data import/export, formatting control, and chart generation, making it ideal for automating spreadsheet-related workflows across various industries, from data analysis and reporting to financial modeling and content generation. The use cases for IronXL span various industries including finance, research, education, and healthcare, where users need to merge, split, and export data while maintaining the integrity and formatting of their spreadsheets.

IronXL for Python via .NET is licensed based on the number of developers, organization locations and projects, and is available as a perpetual license with one free year of product updates and support services. See our IronXL for Python via .NET licensing page for full details.

For more information, see our IronXL for Python via .NET product page.

保持关键信息在电子表格中能看到

6月 7, 2024
冻结窗格支持通过在滚动浏览大型数据集时保持基本行或列用作参考来增强数据分析。

Spreadsheet controls with freeze pane support enable developers to lock specific rows or columns in place while allowing the rest of the data to scroll freely. This feature enhances the user experience by keeping headers or key reference data visible at all times, thus improving navigation and readability in large datasets. It is particularly beneficial for applications where users need to compare data across extensive spreadsheets, ensuring that critical information remains accessible without disrupting the workflow. This functionality contributes to a more efficient and user-friendly interface, reducing the cognitive load on users and facilitating better data analysis.

Several JavaScript spreadsheet controls offer freeze pane support including:

  • Telerik Spreadsheet jQuery (part of Kendo UI and Telerik DevCraft) allows you to keep headers visible while scrolling, enhancing data navigation and user experience.
  • SpreadJS by MESCIUS, facilitates fixed rows or columns for seamless data comparison and improved spreadsheet navigation in large datasets.
  • Jspreadsheet Pro lets you freeze panes to maintain visibility of crucial headers or columns, streamlining data management and analysis.
  • Infragistics Spreadsheet jQuery (part of Infragistics Professional) enables users to lock key rows or columns, ensuring important data stays visible during extensive scrolling.

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

Compare JavaScript Spreadsheet Controls

用公式和函数简化计算

5月 31, 2024
支持公式和函数的 React 电子表格控件可直接在浏览器中实现实时、动态的数据分析和操作。

React spreadsheet controls with formula and function capabilities bring the power of spreadsheets to modern web applications. These components allow users to enter data, manipulate it using built-in formulas (like SUM or AVERAGE) or custom functions, and see the results dynamically update within the web interface. This empowers developers to create interactive data analysis tools, financial calculators, or even planning dashboards directly within their React applications.

Several React spreadsheet controls offer formula and function support including:

  • Telerik Spreadsheet React (part of KendoReact) enables complex formula calculations and function execution directly within cells for dynamic, interactive data analysis.
  • Wijmo FlexSheet (part of Wijmo from MESCIUS) offers extensive formula support, allowing users to perform comprehensive calculations and data manipulation within spreadsheets.
  • Jspreadsheet Pro provides robust formula capabilities, facilitating advanced mathematical, logical, and text functions for enhanced data processing in the browser.
  • Infragistics Spreadsheet React (part of Infragistics Ignite UI) supports a wide range of functions and formulas, enabling real-time calculations and sophisticated data analysis.
  • Syncfusion Spreadsheet JavaScript (part of Syncfusion Essential Studio Enterprise) offers extensive formula and function support, allowing easy data manipulation.

For an in-depth analysis of features and price, visit our React spreadsheet controls comparison.

Compare React Spreadsheet Controls