Nouvelles Spreadsheets

Organisez les données pour obtenir des informations plus rapidement

Juin 26, 2025

La fonctionnalité de tri permet aux utilisateurs de tableurs de structurer de grands ensembles de données en organisant les lignes en fonction des valeurs des colonne sélectionnées.

Data sorting in a spreadsheet control is a fundamental feature that enables users to rearrange data within a grid or table based on specific criteria, typically ascending or descending alphabetically or by numerical value. Sorting will usually be performed on single or multiple columns and is often integrated with other data manipulation tools like filtering, grouping, and searching. By sorting data, users can quickly locate and analyze information, identify patterns, and ensure consistency across records. Especially useful in large datasets, it improves the readability of the information and makes it more organized in preparation for decision-making, reporting, and data validation. This capability facilitates efficient data analysis, and supports better user interaction by allowing datasets to be viewed in meaningful sequences.

Several WPF spreadsheet controls offer support for data sorting including:

DevExpress WPF Spreadsheet (part of DevExpress WPF) offers built-in dialog boxes for single- and multi-column sorts, along with support for custom comparison.
Spread WPF by MESCIUS provides a flexible API for applying sorts programmatically or through the user interface, including options for nested multi-key sorts.
Telerik WPF Spreadsheet (part of Telerik UI for WPF) supports interactive column and row sorting, multi-field sorting, and programmatic control over sort direction and key range.
Syncfusion WPF Spreadsheet (part of Syncfusion Essential Studio Enterprise) includes context-menu and dialog-based sorting for one or more columns.

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

Compare WPF Spreadsheet Controls

Collaborez en temps réel avec la synchronisation des feuilles de calcul

Juin 24, 2025

SpreadJS permet une coédition fluide en temps réel dans les applications JavaScript avec un cadre de collaboration modulaire qui offre une édition sans conflit.

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.

SpreadJS enables real-time collaboration within JavaScript spreadsheet applications through a modular, extensible framework currently available as a Developer Preview. This feature allows multiple users to work on the same spreadsheet simultaneously, maintaining data consistency and reducing the complexity of building collaborative functionality from scratch. It supports low-latency data synchronization, user presence indicators, and conflict-free concurrent editing, allowing multiple users to work simultaneously while maintaining consistent data states. Designed to integrate with various document types and backend systems, it simplifies the development of collaborative features without requiring developers to build the infrastructure from scratch. An online collaboration demo is available to explore these capabilities in action.

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.

Améliorez la clarté des données en personnalisant les styles de cellule

Juin 11, 2025

Mettez en forme les cellules d’une feuille de calcul avec des polices, des couleurs, des bordures et des styles numériques pour rendre les données complexes plus claires, avec une présentation plus professionnelle.

Cell formatting in spreadsheet components allows developers to manipulate the visual presentation of spreadsheet data, enhancing clarity and usability. This includes adjusting font styles, colors, borders, number formats, and alignment, which is especially valuable for building business or financial applications where precise data representation is critical. Such formatting capabilities ensure that end-users can interact with spreadsheets that are both functional and aesthetically tailored to the specific context of the application.

Several ASP.NET Core spreadsheet components support cell formatting, including:

DevExpress ASP.NET Core Spreadsheet (part of DevExpress ASP.NET and Blazor) provides comprehensive cell formatting options such as font styles and borders.
Telerik ASP.NET Core Spreadsheet (part of Telerik UI for ASP.NET Core) supports rich formatting tools with support for conditional formatting and themes.
Syncfusion ASP.NET Core Spreadsheet (part of Syncfusion Essential Studio Enterprise) delivers a robust formatting engine, allowing both programmatic and UI-based formatting.
Infragistics ASP.NET Core Spreadsheet (part of Infragistics Professional) offers an extensive formatting model, supporting font and background settings, borders, and format strings.

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

Compare ASP.NET Core Spreadsheet Controls

Générez des PDF à partir de données de feuille de calcul

Mai 30, 2025

Permettez aux utilisateurs d’exporter des feuilles de calcul en fichiers PDF directement dans une application Web JavaScript, tout en conservant le contenu et le style d’origine.

Exporting a spreadsheet to PDF from a JavaScript application is a widely used feature that allows users to generate portable, print-ready documents directly from the browser. It converts the contents of a spreadsheet, such as cell data, formulas, formatting, charts, and images into a Portable Document Format (PDF) file. This capability ensures that the data, formatting, and layout from the original spreadsheet are preserved without relying on external applications or manual intervention. It is particularly useful for generating reports, invoices, or records that need to be shared, printed, or archived in a fixed format. By enabling PDF generation directly within the web application, developers can offer users a straightforward method to archive, print, or share spreadsheet content in a consistent and professional format across devices and platforms.

Several JavaScript spreadsheet components allow you to export to PDF, including:

SpreadJS by MESCIUS enables users to convert complex spreadsheet content, including formulas and styling, directly to PDF within a JavaScript application.
Telerik Spreadsheet jQuery (part of Kendo UI) provides an integrated PDF export option that retains the structure and styling of the spreadsheet for uniform document output.
Jspreadsheet Pro, through the export to PDF extension, facilitates the export of spreadsheet content to PDF, ensuring the integrity of the original document.
Syncfusion Spreadsheet JavaScript (part of Syncfusion Essential Studio Enterprise) allows you to save spreadsheet documents as PDF files, preserving layout and style.

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

Compare JavaScript Spreadsheet Components

Explorez de puissantes fonctionnalités basées sur l’IA dans vos feuilles de calcul JavaScript

Mai 22, 2025

SpreadJS 18.1 inclut un aperçu développeur des fonctionnalités d’IA pour le langage naturel et l’analyse intelligente.

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: