Spreadsheets News

Explore Powerful AI-driven Features in your JavaScript Spreadsheets

May 22, 2025
SpreadJS 18.1 includes a developer preview of AI Features for Natural Language and Smart Analysis.

SpreadJS by MESCIUS is a high-performance JavaScript spreadsheet component designed to integrate Excel-like functionality into web applications. It allows developers to deliver robust spreadsheet experiences within their applications, complete with features like data import/export, complex formulas, conditional formatting, and extensive customization options. SpreadJS caters to a wide range of use cases, from financial modeling and data analysis to project management and interactive dashboards, ultimately allowing developers to build feature-rich and user-friendly web applications. SpreadJS 18.1 includes a Developer Preview of powerful AI-driven features designed to transform how users interact with JavaScript spreadsheets.

In this blog post, SpreadJS Product Manager Chris Bannon takes you through each of these AI features, shows you how to use them, and highlights the value they can bring to your JavaScript applications. The SpreadJS AI Add-on preview includes the following capabilities:

  • Formula generation and explanation using natural language
  • PivotTable generation based on descriptive input
  • AI worksheet functions for text processing and translation

Read the full blog to get started exploring the benefits available in adding AI into 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.

Visualize Spreadsheet Data Using 50 Chart Types

May 13, 2025
Xceed Workbooks for .NET V3.0 introduces support for 50 chart types via its API, making it easier to build complex visuals directly in .NET applications.

Xceed Workbooks for .NET is a software component designed for .NET developers that enables the creation and manipulation of Microsoft Excel .xlsx files directly within their applications, without requiring Microsoft Excel or Office to be installed; it provides an API that allows for programmatic control over spreadsheet content, formatting, and structure, facilitating tasks such as report generation, data analysis, and document automation.

The Xceed Workbooks for .NET V3.0 release significantly enhances charting capabilities by allowing developers to programmatically create and manage a wide range of chart types without relying on external tools. From standard line, column, bar, pie, and doughnut charts to more advanced options like scatter, bubble, radar, and stock charts, the update ensures broad coverage of data visualization needs. Notably, the version also brings in new 3D chart types such as Surface3D and Contour3D, offering more depth and interactivity for technical and scientific data presentation. This expanded support empowers users to deliver polished, professional-grade reports and dashboards within their .NET environments.

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

Xceed Workbooks for .NET is licensed per developer and is available as a perpetual license with 1 year of updates and support. See our Xceed Workbooks for .NET licensing page for full details.

Xceed Workbooks for .NET is available individually or as part of Xceed Ultimate Suite.

Instantly Visualize Data Within Spreadsheets

May 12, 2025
Transform raw figures into interactive charts directly inside your .NET spreadsheet application for faster insights and cleaner reporting.

Chart support in a spreadsheet component refers to the ability to create, render, and manipulate various types of charts - such as line, bar, pie, and area charts - all within the spreadsheet environment. This functionality allows spreadsheet developers to present data visually and dynamically, without needing to rely on external charting libraries. The integration of charting capabilities enhances the end-user experience by making complex data more understandable. For developers, this reduces the need for separate visualization components, improves performance through tighter integration, and simplifies the deployment of data-centric applications.

Several .NET Winforms spreadsheet controls offer chart support, including:

  • MindFusion.Spreadsheet for WinForms empowers users with interactive charts directly within cells, enhancing data visualization and making analysis readily understandable.
  • Infragistics WinForms Spreadsheet (part of Infragistics Ultimate UI for Windows Forms) can embed rich charts, facilitating interpretation of trends and performance metrics.
  • Spread.NET WinForms by MESCIUS facilitates dynamic data visualization through customizable charts and conditional formatting, enabling users to highlight key insights.
  • DevExpress WinForms Spreadsheet (part of DevExpress WinForms) lets developers integrate interactive charts, offering visually compelling representations for analysis.

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

Compare .NET Winforms spreadsheet Controls

Speed Up Spreadsheet Tasks with Instant Commands

May 9, 2025
SpreadJS 18.1.0 adds a new Command Palette for fast, context-aware access to actions and advanced features using keystrokes and search.

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.

Import Text Files for Faster Data Processing

May 7, 2025
Quickly load plain text (txt) files into spreadsheets in .NET WinForms apps to reduce manual entry, and accelerate data handling and analysis.

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