Spreadsheets 新闻

用即时命令加速电子表格任务

5月 9, 2025
SpreadJS 18.1.0 添加一个新的命令选项板，用于使用击键和搜索快速、情境感知地访问作和高级功能。

SpreadJS is a high-performance JavaScript spreadsheet and data presentation component designed for enterprise web applications. It enables developers to deliver Excel-like functionality directly within their web solutions, providing advanced features such as data binding, complex calculations, pivot tables, charts, and extensive formatting options. Fully compatible with modern JavaScript frameworks like React, Angular, and Vue, SpreadJS allows seamless integration and customization, empowering development teams to create interactive, data-driven user experiences without relying on external spreadsheet applications.

The SpreadJS 18.1.0 update introduces the new Command Palette, providing developers with a centralized interface to quickly access and execute a wide range of spreadsheet commands without navigating through complex menus. This enhancement improves productivity by reducing the time required to locate functions, allowing developers to apply formatting, manage data, and configure worksheet settings directly through intuitive search and selection capabilities. The Command Palette can be instantly triggered using the familiar Ctrl/Cmd + P keyboard shortcuts, offering quick access to commands and further accelerating common development and data manipulation tasks within the application.

To see a full list of what's new in 18.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月 7, 2025
在 .NET WinForms 应用程序中将纯文本（txt）文件快速加载到电子表格中，以减少手动输入，并加快数据处理和分析。

Importing TXT files into spreadsheet applications allows developers and users to load in plain text data, typically delimited by characters such as commas or tabs, and transform it into structured, editable tables within a spreadsheet-like environment. This process enables users to work with externally sourced or manually created text data using the familiar tools and features of a spreadsheet, such as sorting, filtering, and formula calculations. Loading a text file into an Excel-like format removes the need for manual data entry and simplifies data processing. Support for TXT file imports makes spreadsheet applications more versatile by improving the integration of external data and helping users process information more efficiently. It reduces the workload associated with data processing and ensures that data is quickly available in a usable format for analysis or reporting.

Several WinForms spreadsheet controls allow you to import files in TXT format:

  • DevExpress WinForms Spreadsheet (part of DevExpress WinForms) provides Excel inspired functionality and supports the import of data from TXT files to populate a spreadsheet.
  • Spread.NET WinForms (part of Spread.NET by MESCIUS) enables spreadsheet apps to open delimited text files, instantly converting text content into interactive spreadsheet cells.
  • Aspose.Cells for .NET is a WinForms-compatible programming API for spreadsheet management and processing that includes support for loading TXT files.
  • Telerik WinForms Spreadsheet (part of Telerik UI for WinForms) enables you to import plain text files with tab separated values (.txt) to transform raw data for easy manipulation.

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

Compare WinForms Spreadsheet Controls

在三个维度上可视化电子表格数据

5月 2, 2025
Spread.NET v18.1 添加新的 WPF 曲面图，其可将复杂的电子表格数据转换为交互式 3D 曲面。

Spread.NET by MESCIUS is a powerful tool for building Excel-like applications in your .NET projects. It lets you create interactive spreadsheets, grids, dashboards, and even forms within WinForms, ASP.NET, and WPF applications. With its rich feature set, including a robust calculation engine, formula support, and Excel compatibility, Spread.NET empowers developers to build data analysis tools, budgeting apps, scientific dashboards, and more, all within the familiar .NET environment.

The Spread.NET v18.1 update introduces a new surface chart feature for WPF, providing developers with the capability to render spreadsheet data on a three-dimensional plane. By offering this advanced charting functionality, developers can create more sophisticated data visualization solutions within their WPF applications, allowing end-users to gain deeper insights into complex data and identify key correlations that may not be evident in two-dimensional representations. This feature expands the analytical tools available within Spread.NET, allowing for more nuanced and comprehensive data exploration.

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

Spread.NET is licensed per developer and is available as a Perpetual License with a 12 month support and maintenance subscription. We can supply any Spread.NET license including new licenses, maintenance renewals, and upgrade licenses. See our Spread.NET licensing page for full details.

For more information, visit our Spread.NET product page.

在电子表格导出中保持图像完整性

5月 1, 2025
Syncfusion Essential Studio WinUI 2025 Volume 1 通过完全按照设计保留 EMF+ 和 EMF Dual 图像来改进 Excel 到 PDF 的转换。

Syncfusion Essential Studio WinUI (available as part of Syncfusion Essential Studio Enterprise) is a comprehensive toolkit for building high performance native Windows desktop applications. It offers tools for crafting modern UI elements like charts, data grids, and ribbon interfaces, alongside powerful editing tools for Word, Excel, and PDF documents.

The Syncfusion Essential Studio WinUI 2025 Volume 1 release improves the Excel Library by adding the ability to accurately preserve EMF+ (Enhanced Metafile Format Plus) and EMF Dual images during Excel-to-PDF and image conversion processes. This improvement ensures that vector-based images maintain their clarity and quality in the resulting PDFs, which is particularly beneficial for producing professional documentation such as manuals and reports. By retaining the integrity of these images, developers can deliver high-quality outputs that effectively communicate complex information through detailed visuals.

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

Syncfusion Essential Studio WinUI is available as part of Syncfusion Essential Studio Enterprise which is licensed per developer starting with a Team License of up to five developers. It is available as a 12 Month Timed Subscription License which includes support and maintenance. See our Syncfusion Essential Studio Enterprise licensing page for full details.

Learn more on our Syncfusion Essential Studio WinUI product page.

查找和替换 JavaScript 电子表格中的数据

4月 29, 2025
为电子表格 Web 应用程序配备灵活且高级的查找和替换功能，从而简化更新内容的过程。

Find and replace functionality in a spreadsheet application enables users to quickly search for specific text, numbers, or characters within a worksheet and substitute them with alternative content. Often including advanced options such as case sensitivity, regular expressions, and the ability to target specific sheets or cell ranges, this feature lets users make consistent updates across large datasets without manually editing each cell. By automating these repetitive tasks, it reduces the risk of human error and significantly enhances productivity and accuracy in data processing. It is particularly useful for correcting errors, updating outdated information, or standardizing entries, such as changing all instances of an old product name to a new one.

Several JavaScript spreadsheet controls offer find and replace functionality, including:

  • SpreadJS by MESCIUS equips JavaScript developers with the ability to perform search and replace operations via a dialog, supporting advanced options like case matching.
  • Jspreadsheet Pro is a data grid with spreadsheet controls, providing JavaScript applications with find and replace functionality via an advanced search and replace extension.
  • Syncfusion Spreadsheet JavaScript (part of Syncfusion Essential Studio Enterprise) facilitates flexible find and replace capabilities to simplify targeted editing.

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

Compare JavaScript Spreadsheet Controls