Spreadsheets 新闻

在电子表格应用程序中支持 PDF 导出

10月 14, 2025
为 Angular 应用程序配备将电子表格导出为 PDF 的功能，从而生成保留原始内容的易分发的文档。

Exporting a spreadsheet to PDF is a widely used feature that allows users to generate fixed-layout, print-ready versions of their spreadsheet data, converting the contents of the spreadsheet file, into a Portable Document Format (PDF) file. This capability ensures that formatting, styling, and content of the original spreadsheet, including tables, charts, and cell styles, are preserved exactly as intended, regardless of the device or application used to open the file. It is especially useful for sharing finalized documents, such as reports or financial summaries, with stakeholders who do not need to interact with the data directly.

Several Angular spreadsheet components allow you to export to PDF, including:

  • SpreadJS by MESCIUS allows you to directly export complex spreadsheets to PDF from Angular applications with full support for cell styles, formulas, charts, and custom layouts.
  • Jspreadsheet Pro grants straightforward PDF conversion via the export to PDF extension, supporting layout and styling preservation and versatile document sharing.
  • Syncfusion Spreadsheet JavaScript (part of Syncfusion Essential Studio Enterprise) enables users to save high-quality PDF versions of their spreadsheets in Angular applications.

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

Compare Angular Spreadsheet Components

将 Vue 数据透视表添加到您的 Web 应用程序

10月 14, 2025
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.

In this blog post, MESCIUS Product Marketing Specialist Mackenzie Albitz shows you the steps for integrating a Pivot Table directly into your Vue application using the SpreadJS Vue Spreadsheet component with its optional Pivot Table add-on. Steps include:

  • Creating a Vue Pivot Table
  • Adding Pivot Table Panels to a Vue app
  • Setting the Vue Pivot Layout
  • Setting the Pivot Table Theme
  • Understanding Pivot Table Slicers
  • Understanding Pivot ContextMenu
  • Applying Pivot Conditional Formatting

Detailed code is included and you can even download the sample app to get started.

Read the complete blog to get started creating and customizing powerful Vue Spreadsheet Pivot Tables.

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.

将原始数据转化为清晰的见解

10月 7, 2025
借助排序、分组和计算功能，电子表格可以将大型数据集转换为结构化、有意义且有用的信息。

Data organization and analysis features form the backbone of a spreadsheet’s ability to transform raw inputs into meaningful insights. These capabilities go beyond simple data entry, providing the tools necessary to structure, manipulate, and interpret information effectively. By supporting both everyday tasks and complex analytical processes, they enable users to manage datasets of varying scale and complexity while ensuring that information remains accessible and actionable. Well-implemented organization and analysis features allow spreadsheets to serve not only as data storage tools but also as powerful environments for decision-making and reporting.

Common features include:

  • Sorting lets users arrange data in ascending or descending order to quickly identify patterns or prioritize information.
  • Data Filtering and Grouping allow specific subsets of data to be displayed or collapsed, improving clarity when working with large datasets.
  • Pivot Tables provide a dynamic way to summarize and analyze data, enabling multidimensional views without altering the original dataset.
  • Cross-Worksheet Calculations extend analytical capabilities by linking values across multiple sheets, supporting more integrated and comprehensive models.
  • Formula / Function Support offers the computational foundation of spreadsheets, with a wide range of built-in functions for mathematical, logical, and statistical operations.
  • Table Support gives structure to related rows and columns, adding features such as auto-expansion and easier formula referencing.
  • Sparklines deliver compact, cell-level charts that provide immediate visual context to numeric trends without the need for larger, standalone charts.

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

Explore React Spreadsheet Features

将自定义逻辑添加到 Excel 公式

9月 26, 2025
EPPlus Software v8.2.0 添加 对 8 个基于 LAMBDA 新函数的支持，从而启用自定义公式、动态数组和数据转换。

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 v8.2.0 update introduces support for eight new LAMBDA-based functions, giving developers greater flexibility and control when working with Excel workbook calculations. With these additions, you can now define custom functions directly in the workbook, streamline array transformations, apply operations by row or column, and handle iterative or conditional logic more efficiently. This enhancement reduces the need for repetitive formulas or external code, enabling cleaner, more maintainable spreadsheets that better align with modern programming practices.

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

将平面文件转换为交互式电子表格

9月 16, 2025
将 CSV 文件导入电子表格组件允许用户使用熟悉的界面操作、格式化和分析纯文本数据。

Importing CSV files in spreadsheet components allows developers and end-users to load tabular data from simple text-based formats into an interactive grid. The feature typically supports reading CSV with various delimiters, optional headers, and options about how to treat quoted text, line endings, and text formatting. It provides a bridge between raw data sources (spreadsheets exported from other tools, logs, exports from databases) and richer in-browser or in-application editing, formatting, analysis, or further exporting. For many applications, being able to accept CSV imports is essential for interoperability, ease of data ingestion, and enabling users without deep technical skills to bring their data into a system.

Several React spreadsheet controls offer the ability to import CSV files including:

  • SpreadJS by MESCIUS lets you import CSV files directly into the spreadsheet, preserving data formatting, formulas, and structure for immediate editing.
  • Syncfusion Spreadsheet JavaScript (part of Syncfusion Essential Studio Enterprise) allows you to load CSV files into interactive sheets.
  • Jspreadsheet Pro facilitates easy CSV file import, instantly converting raw data into an editable spreadsheet with sorting, filtering, and customization options.

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

Compare React Spreadsheet Controls