Spreadsheets 新闻

将电子表格模板应用到新工作簿

5月 12, 2026
SpreadJS 19.1 增强型设计器现在可以从一开始就通过一致的样式和格式应用预配置电子表格模板。

SpreadJS is a JavaScript spreadsheet and data visualization component built to deliver Excel-compatible functionality within web applications. It provides a flexible, high-performance interface for displaying and manipulating tabular data, supporting advanced features such as formulas, pivot tables, charts, conditional formatting, and data binding. SpreadJS integrates smoothly with popular frameworks like React, Angular, and Vue, and includes robust import and export capabilities for Microsoft Excel files. It is commonly used in enterprise applications where users need a responsive, interactive spreadsheet experience directly in the browser.

The SpreadJS 19.1.0 update enhances the designer with a new templatesConfig option, allowing developers to define template configurations for new workbooks. By loading templates from remote sources or preloaded data, applications can apply consistent styles and formats during initialization or reset operations, helping teams standardize workbook creation and simplify spreadsheet setup.

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

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.

将条件格式添加到电子表格

5月 8, 2026
将智能视觉提示添加到 React 电子表格应用程序,使用户更高效地识别趋势、阈值和关键变化。

Conditional formatting support in a React spreadsheet component allows developers to apply dynamic visual styling to cells based on defined rules, values, formulas where supported, or predefined conditions, such as highlighting trends, thresholds, errors, or status changes as data changes. This capability improves data readability and usability by helping users identify important information quickly without manual analysis, while also enabling more interactive and responsive data-driven applications. For software developers, it provides a familiar spreadsheet experience within React applications, reduces the need for custom rendering logic, and supports the creation of dashboards, financial tools, reporting systems, and enterprise data management interfaces with clearer visual context.

Several React spreadsheet controls support conditional formatting including:

  • SpreadJS by MESCIUS lets you apply rule-based conditional formatting in React spreadsheets, highlighting trends and thresholds with dynamic visual cell styling.
  • Infragistics Ignite UI for React Spreadsheet (part of Infragistics Ignite UI) allows you to create React spreadsheets using conditional formatting rules that emphasize critical data.
  • Syncfusion React Spreadsheet (part of Syncfusion Essential Studio Enterprise) facilitates conditional formatting enabling developers to visualize patterns and exceptions.

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

Compare React Spreadsheet Controls

庆祝与 Pinexl 合作 2 周年

5月 1, 2026
ComponentSource 和 Pinexl 已经合作了 2 年,帮助开发人员通过 Excel 生产效率并获得更清晰的数据洞察。

ComponentSource and Pinexl have built a strong partnership over the past two years, focused on delivering Microsoft Excel productivity tools to developers and business users worldwide. Pinexl’s solutions are designed to simplify complex data tasks, combining intuitive interfaces with advanced functionality to help users analyze, visualize, and manage data more efficiently.

Their Excel add-ins, including AI-powered and business intelligence focused tools, enable users to automate formula creation, generate and refine code, and transform raw spreadsheet data into clear insights and professional dashboards directly within Excel.

Through this collaboration, ComponentSource expands its offering with modern, high quality Excel based tools that stand out for their usability and professional design. The partnership also ensures that Pinexl’s products reach a global audience through ComponentSource’s established distribution network, helping customers access reliable tools wherever they are.

Learn more about Pinexl.

插入行而无需破坏数据

4月 24, 2026
在保留公式、格式和参考动态的同时添加新行以保持电子表格准确一致。

Inserting rows in spreadsheet components enables users to expand and reorganize data dynamically within a worksheet. It supports common data management tasks such as adding new records, adjusting layouts, and maintaining structured datasets without disrupting existing content. By integrating row insertion directly through APIs, applications can offer a familiar and efficient spreadsheet experience for users working with tabular data.

Several ASP.NET Core spreadsheet controls offer support for inserting rows including:

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

Compare ASP.NET Core Spreadsheet Controls

使用 JavaScript 导入和导出 Excel XLSX

4月 17, 2026
浏览此在线教程,学习如何使用 SpreadJS 在不安装 Excel 的情况下打开和保存电子表格。

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 online tutorial from MESCIUS, you will learn the critical steps allowing you to import/export XLSX files using JavaScript. Steps include:

  • Set up the JavaScript Spreadsheet Project
  • Add Excel import code
  • Add Excel export code
  • Include extra features, such as Charts, Shapes, and PivotTables

Detailed sample code is included to help you along the way.

View the tutorial now and get started working with spreadsheet files in your JavaScript applications.

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.