Spreadsheets 新聞

在 .NET 應用程式中提升試算表資料分析

9月 5, 2024
EPPlus v7.3.0 添加支援更複雜的統計和數學運算的新功能，從而提升了其公式計算能力。

繼續用英語閱讀:

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.3.0 update introduces four new functions that are supported in formula calculations, enhancing the library's capability for data analysis within Microsoft Excel spreadsheets. The GROWTH function enables exponential growth calculations, while DPRODUCT allows the multiplication of values in a field of a list or database based on specified criteria. The DSTDEV and DSTDEVP functions calculate the standard deviation of values in a field within a list or database, but they differ in their scope. DSTDEV is for samples, while DSTDEVP is used for entire populations. These functions allow developers to perform more complex statistical and mathematical operations directly within spreadsheet documents, significantly improving the efficiency of data-driven applications.

To see a full list of what's new in v7.3.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.

透過對 Cell Image 的支援視覺化您的資料

9月 2, 2024
透過集成圖像的功能增強您的 React 試算表，從而提高了資料清晰度並創建具有視覺吸引力的演示文稿。

繼續用英語閱讀:

Cell image support refers to the capability of a spreadsheet component to incorporate and manipulate images directly within individual cells. This feature allows developers to visually represent data, such as charts, diagrams, or photographs, within the spreadsheet interface. By integrating images into cells, developers can enhance the overall effectiveness of their spreadsheet-based applications  as well as making them more engaging for users, facilitating data visualization and analysis.

Several React spreadsheet controls offer support for cell images, including:

  • SpreadJS by MESCIUS lets you seamlessly embed images into cells, enabling React developers to enhance visual data representation in their applications.
  • Jspreadsheet Pro provides seamless image insertion and manipulation functionality within cells for creating dynamic spreadsheets in React.
  • Syncfusion Spreadsheet JavaScript (part of Syncfusion Essential Studio Enterprise) facilitates the integration of images into cells, providing a rich and interactive experience.

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

Compare React Spreadsheet Controls

用 Node.js API 簡化了試算表處理

9月 2, 2024
Aspose.Cells for Node.js via C++ 允許開發人員將試算表操作和轉換集成到其 Node.js 應用程式中。

繼續用英語閱讀:

Aspose.Cells for Node.js via C++ is a powerful and comprehensive API that enables developers to work with Microsoft Excel files within Node.js applications, leveraging the robust capabilities of C++. This product allows for the creation, manipulation, conversion, and rendering of Excel spreadsheets, all without requiring Microsoft Excel to be installed. With support for a wide range of Excel file formats, including XLS, XLSX, CSV, and more, Aspose.Cells for Node.js via C++ provides developers with the flexibility to handle complex spreadsheet tasks in their applications efficiently.

The key benefits of Aspose.Cells for Node.js via C++ include its high performance, ease of integration, and extensive feature set. Developers can automate complex spreadsheet processing tasks, such as data analysis, formula calculations, and chart creation, directly within their Node.js applications. This makes it particularly useful for scenarios where server-side spreadsheet processing is needed, such as in web-based data analysis tools, reporting systems, and enterprise-level applications. By offloading heavy Excel processing tasks to Aspose.Cells, developers can significantly enhance the performance and scalability of their applications while maintaining full control over spreadsheet operations.

Aspose.Cells for Node.js via C++ is offered as Developer Small Business, Developer OEM, Developer SDK, Site Small Business, Site OEM, and Site SDK licenses catering to a range of business needs. Licenses are perpetual, and include 1 year of support and maintenance. Subscription renewals are also available. See our Aspose.Cells for Node.js via C++ licensing page for full details.

Aspose.Cells for Node.js via C++ is available in the following products:

用增強的樞紐分析表篩選器增強分析

9月 2, 2024
Document Solutions for Excel Java 7.2 可以透過標籤和值篩選功能精確優化和管理大型資料集。

繼續用英語閱讀:

Document Solutions for Excel, Java Edition by MESCIUS is designed to enable developers to create and manipulate Excel documents programmatically within Java applications. It provides a robust API for interacting with Excel spreadsheets, allowing developers to automate tasks such as data extraction, formatting, and generation of reports. The framework offers comprehensive support for various Excel features, including formulas, charts, conditional formatting, and data validation. Additionally, it provides tools for handling large datasets and optimizing performance, making it suitable for both small-scale and enterprise-level applications.

The Document Solutions for Excel v7.2 release introduces a powerful new feature for pivot tables: Label and Value Filters. This enhancement empowers developers to programmatically refine and manage extensive datasets within pivot tables, enabling more precise and relevant analysis. By applying label and value filters to their pivot tables, developers can narrow down data to focus on specific criteria, streamlining the process of extracting meaningful insights from complex information.

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

Document Solutions for Excel, Java 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, Java Edition licensing page for full details.

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

增強了 .NET 8 試算表中的資料管理

8月 30, 2024
將查找和替換功能添加到 .NET 8 試算表應用程式可提高工作效率和一致性，同時最大程度減少錯誤。

繼續用英語閱讀:

Find and replace is a useful feature found in spreadsheet applications that allows users to quickly locate specific values, i.e. text, numbers, or formulas, identifying all instances of that search term within a spreadsheet and then being able to replace them with a new value. By automating the process of manually searching for and modifying each occurrence individually, find and replace enhances productivity, reduces the likelihood of human error, and ensures consistency throughout the spreadsheet. This functionality is especially beneficial for tasks that involve managing large volumes of data, updating outdated information, correcting mistakes, or standardizing data formats.

Several .NET 8 spreadsheet components allow you to find and replace, including:

  • DevExpress WinForms Spreadsheet enhances data management in .NET 8, facilitating find and replace operations via the user interface or directly in code.
  • Telerik WPF Spreadsheet (part of Telerik UI for WPF) allows you to efficiently locate and replace content using find and replace in .NET 8 spreadsheet applications.
  • IronXL by Iron Software is a library that supports .NET 8 and offers several cell range functions including find and replace for Microsoft Excel spreadsheets.
  • MindFusion.Spreadsheet for WPF can provide spreadsheet applications in .NET 8 with intuitive find-and-replace capabilities for consistent and accurate data manipulation.

For an in-depth analysis of features and price, visit our comparison of .NET 8 spreadsheet components.

Compare .NET 8 Spreadsheet Components