Spreadsheets 新聞

用 AI 增強 JavaScript 試算表

9月 3, 2025
觀看 MESCIUS CodeClinic 網絡研討會並探索 SpreadJS 中的新 AI 助手插件。

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.

On August 21st, MESCIUS hosted a CodeClinic for the Developer Preview of the SpreadJS AI Add-on. Product Manager Chris Bannon demonstrated how to enhance your JavaScript spreadsheet applications with natural language formula generation, intelligent PivotTable creation, and AI-powered worksheet functions - all integrated directly into the spreadsheet UI.

The webinar includes the following key takeaways:

  • Use AI to generate and explain existing spreadsheet formulas.
  • Have AI generate PivotTables to give meaningful analysis to large datasets.
  • User AI within cells to do things like transition, gauge sentiment, and ask prompts based on spreadsheet data.

Watch the Webinar On-Demand and get ready to bring the power of AI to your JavaScript Spreadsheets.

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.

精確列印和匯出試算表

8月 26, 2025
新式試算表元件提供對列印和匯出的精確控制,從而保留跨格式的佈局、格式和資料完整性。

Spreadsheet components in modern UI frameworks offer robust capabilities for exporting and printing data, enabling users to take structured, interactive grid content and transform it into static or sharable formats. These features are crucial in enterprise applications, where end users often need to generate reports, export analysis results, or share datasets in widely recognized formats. Whether integrated into financial dashboards, inventory systems, or business intelligence tools, export and print functionalities ensure that grid data remains portable, consistent, and accessible across various workflows and platforms.

Common features include:

  • Exporting to CSV format allows for quick export of raw tabular data, preserving the structure of the spreadsheet while maintaining compatibility with most spreadsheet tools and data processing platforms.
  • Exporting to HTML provides a way to preserve the visual layout and styling of the spreadsheet for embedding in web-based documents or reports.
  • Exporting to JSON supports integration with APIs and back-end systems, making it easier to serialize grid data for programmatic use.
  • Exporting to Microsoft Excel (XSLX) retains advanced formatting, formulas, and multi-sheet structures, providing easy interoperability with the Excel desktop and web apps.
  • Image export captures a visual snapshot of the spreadsheet, useful for presentation slides or visual documentation where editable data is not required.
  • PDF export delivers a print-ready, paginated view of spreadsheet content with options for customizing headers, footers, fonts, and layout.
  • Printing support lets users generate hard copies or digital prints with configurable page settings, headers, and footers, often matching what is seen on screen.

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

Explore ASP.NET Core File Export and Printing Features

將 LAMBDA 函數直接套用至儲存格選取範圍

8月 15, 2025
SpreadJS 18.2 添加新的 Transform 命令,以在選定的儲存格上執行 LAMBDA 公式並一步將其替換。

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.2 adds a new Transform command which enables you to apply LAMBDA functions directly to a selected range of cells and replace the original content with calculated results. This simplifies data transformations - whether mapping, filtering, or reshaping - into a clean, single-step process. With this feature, you can select any range and apply a custom LAMBDA formula - for example, converting units, adjusting values, or formatting entries - and have SpreadJS overwrite the selection with the computed results immediately. This removes manual steps like inserting formulas in separate cells, copying values, or pasting back as values. This feature integrates with SpreadJS’s existing LAMBDA capabilities to offer more interactive and efficient spreadsheet manipulation.

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

精確編輯和優化試算表資料

8月 12, 2025
高級儲存格級工具讓使用者輕鬆輸入、格式化和調整試算表內容,從而將準確性與直觀的交互相結合。

Cell-level editing and interaction features are essential components of any modern spreadsheet application, as they directly influence how users enter, modify, and manage data at the most granular level. These capabilities go beyond basic typing to provide enhanced flexibility, control, and context, enabling users to maintain accuracy while streamlining workflows. A well-designed set of cell-level tools supports both data integrity and user productivity, ensuring that spreadsheets can handle everything from quick updates to complex, structured datasets with efficiency and precision.

Common features include:

  • Cell Comments/Tooltips enable contextual notes or guidance to be attached to specific cells, aiding collaboration and documentation.
  • Cell Formatting provides options for adjusting fonts, colors, borders, and number formats, improving both readability and visual appeal.
  • Clipboard Operations such as cut, copy, and paste simplify moving or duplicating content while preserving formatting and formulas.
  • Find / Replace simplifies locating and updating values across large datasets.
  • In-cell Data Editing allows users to enter or update values directly within a cell for faster, more intuitive workflows.
  • Inserting Columns enables users to add new vertical sections to the spreadsheet, creating space for additional data fields or reorganizing existing content without overwriting adjacent information.
  • Inserting Images enables embedding of visual elements directly into the spreadsheet for richer presentations.
  • Inserting Rows allows the addition of new horizontal entries, supporting expansion of datasets, schedules, or tables while maintaining the integrity of surrounding data.
  • Merging Cells lets users combine multiple cells into one for clear headings or layout adjustments.

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

Explore Angular Spreadsheet Features

用更智慧的 RibbonBar 工具優化 UI 設計

8月 1, 2025
Spread.NET 18.2 增強了 RibbonBar 佈局和圖示清晰度,以提高 WinForms 應用程式的設計精度和適應性。

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 18.2 update refines the RibbonBar in WinForms to improve the efficiency and clarity of UI design during development. With expanded icon visibility, developers can more easily access and identify commands, reducing visual ambiguity and speeding up layout tasks. The addition of new layout options for the collapsed state offers greater control over how the RibbonBar adapts to different form sizes, enabling more responsive and space-efficient interface designs. These improvements help streamline the design-time experience, allowing developers to build cleaner, more functional applications with less manual configuration.

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