Spreadsheets News

Insert Rows Without Breaking Data

April 24, 2026
Add new rows dynamically while preserving formulas, formatting, and references to keep spreadsheets accurate and consistent.

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

Import and Export Excel XLSX Using JavaScript

April 17, 2026
Explore this online tutorial to learn how to use SpreadJS to open and save spreadsheets without Excel being installed.

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.

Organize Data with Structured Spreadsheet Tables

April 10, 2026
Improve data management with spreadsheet tables for structured organization, sorting, filtering, consistent calculations and clearer formulas.

Spreadsheet tables provide a structured way to organize and manage data by grouping related information into defined rows and columns with built in functionality. They enhance usability by enabling automatic sorting and filtering, consistent formula application through calculated columns, and clearer data interpretation with structured references and styling. Tables can also expand dynamically as new data is added, reducing manual updates and errors. Common use cases include managing financial records, analyzing sales performance, tracking inventory, and working with data bound to external sources, making them a powerful tool for both everyday tasks and advanced data analysis.

Several .NET spreadsheet controls offer table support including:

  • DevExpress Excel Spreadsheet API for .NET (part of DevExpress Office File API) allows you to manage spreadsheet tables with data binding and calculated columns.
  • EPPlus by EPPlus Software facilitates creation of spreadsheet tables with built in filtering, totals, and structured references to simplify data organization.
  • Infragistics Excel Framework lets you work with spreadsheet tables supporting dynamic ranges, consistent formulas, and enhanced formatting for efficient data handling.
  • Xceed Workbooks for .NET lets you create spreadsheet tables with structured data, enabling sorting, filtering, and consistent calculations across dynamic datasets.

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

Compare .NET Spreadsheet Controls

Create Charts with Flexible Data Selection

April 1, 2026
Syncfusion Essential Studio Spreadsheet Editor SDK adds discontinuous chart range support, enabling dynamic charts from non-adjacent data.

Syncfusion Essential Studio Spreadsheet Editor SDK is a library that lets developers embed spreadsheet functionality into web and desktop applications without requiring Microsoft Excel. It supports editing, formatting, and data analysis features such as cross sheet formula calculation, data binding to local and remote sources including JSON and REST, conditional cell styling, charts, data validation, worksheet protection, and workbook permissions. Available across frameworks including Blazor, React, Angular, Vue, JavaScript, ASP.NET Core and MVC, WPF and WinForms, it helps teams deliver a familiar spreadsheet experience for use cases like reporting, budgeting, and forecasting directly within their applications.

The Syncfusion Essential Studio Spreadsheet Editor SDK 2026 Volume 1 update introduces discontinuous chart range support, enabling developers to create charts from multiple non-adjacent rows, columns, or cell ranges without modifying the original data structure. This capability provides greater flexibility when working with complex, fragmented, or selectively relevant datasets, eliminating the need for manual data consolidation or duplication. It also ensures that charts remain automatically synchronized with updates across all referenced ranges, supporting more accurate, efficient, and maintainable data visualization within modern web and enterprise applications.

To see a full list of what's new in Syncfusion Essential Studio Spreadsheet Editor SDK 2026 Volume 1 (33.1.45), see our release notes.

Syncfusion Essential Studio Spreadsheet Editor SDK is licensed per developer on a one year timed subscription basis, with runtime royalty free redistribution included when the subscription is current, and includes one year of unlimited technical support and updates. See our Syncfusion Essential Studio Spreadsheet Editor SDK licensing page for full details.

Learn more on our Syncfusion Essential Studio Spreadsheet Editor SDK product page.

Highlight Key Data with Conditional Formatting

March 31, 2026
Apply rule-based styling to cells so users can quickly identify trends, outliers, and important values at a glance.

Conditional formatting in spreadsheet components allows developers to dynamically change the appearance of cells based on their values or defined rules. This feature helps highlight important data points, trends, and exceptions without requiring manual updates, making it easier for users to interpret large datasets at a glance. By applying visual cues such as colors, icons, and data bars, conditional formatting enhances readability and supports faster, more informed decision-making within spreadsheet-driven applications.

Several Angular spreadsheet controls offer support for conditional formatting including:

  • SpreadJS provides a conditional formatting engine with support for rules such as data bars, color scales, and icon sets, enabling dynamic visualization of data.
  • Infragistics Ignite UI for Angular Spreadsheet (part of Infragistics Ignite UI) includes conditional formatting capabilities that allow developers to apply rule-based styling.
  • Syncfusion Angular Spreadsheet (part of Syncfusion Essential Studio Enterprise) offers conditional formatting features that support a variety of rule types and visual styles.

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

Compare Angular Spreadsheet Controls