Nouvelles Spreadsheets

Activez l’exportation PDF dans les tableurs

Octobre 14, 2025
Permettez aux applications Angular d’exporter des feuilles de calcul au format PDF, produisant ainsi des documents facilement distribuables avec un contenu original préservé.

Exporting a spreadsheet to PDF is a widely used feature that allows users to generate fixed-layout, print-ready versions of their spreadsheet data, converting the contents of the spreadsheet file, into a Portable Document Format (PDF) file. This capability ensures that formatting, styling, and content of the original spreadsheet, including tables, charts, and cell styles, are preserved exactly as intended, regardless of the device or application used to open the file. It is especially useful for sharing finalized documents, such as reports or financial summaries, with stakeholders who do not need to interact with the data directly.

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

  • SpreadJS by MESCIUS allows you to directly export complex spreadsheets to PDF from Angular applications with full support for cell styles, formulas, charts, and custom layouts.
  • Jspreadsheet Pro grants straightforward PDF conversion via the export to PDF extension, supporting layout and styling preservation and versatile document sharing.
  • Syncfusion Spreadsheet JavaScript (part of Syncfusion Essential Studio Enterprise) enables users to save high-quality PDF versions of their spreadsheets in Angular applications.

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

Compare Angular Spreadsheet Components

Ajoutez un tableau croisé dynamique Vue à votre application Web

Octobre 14, 2025
Les tableaux croisés dynamiques SpreadJS offrent un moyen puissant d’explorer et de résumer facilement de grands ensembles de données.

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 blog post, MESCIUS Product Marketing Specialist Mackenzie Albitz shows you the steps for integrating a Pivot Table directly into your Vue application using the SpreadJS Vue Spreadsheet component with its optional Pivot Table add-on. Steps include:

  • Creating a Vue Pivot Table
  • Adding Pivot Table Panels to a Vue app
  • Setting the Vue Pivot Layout
  • Setting the Pivot Table Theme
  • Understanding Pivot Table Slicers
  • Understanding Pivot ContextMenu
  • Applying Pivot Conditional Formatting

Detailed code is included and you can even download the sample app to get started.

Read the complete blog to get started creating and customizing powerful Vue Spreadsheet Pivot Tables.

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.

Transformez les données brutes en informations claires

Octobre 7, 2025
Grâce aux fonctions de tri, de regroupement et de calcul, les feuilles de calcul transforment de grands ensembles de données en informations structurées, significatives et utiles.

Data organization and analysis features form the backbone of a spreadsheet’s ability to transform raw inputs into meaningful insights. These capabilities go beyond simple data entry, providing the tools necessary to structure, manipulate, and interpret information effectively. By supporting both everyday tasks and complex analytical processes, they enable users to manage datasets of varying scale and complexity while ensuring that information remains accessible and actionable. Well-implemented organization and analysis features allow spreadsheets to serve not only as data storage tools but also as powerful environments for decision-making and reporting.

Common features include:

  • Sorting lets users arrange data in ascending or descending order to quickly identify patterns or prioritize information.
  • Data Filtering and Grouping allow specific subsets of data to be displayed or collapsed, improving clarity when working with large datasets.
  • Pivot Tables provide a dynamic way to summarize and analyze data, enabling multidimensional views without altering the original dataset.
  • Cross-Worksheet Calculations extend analytical capabilities by linking values across multiple sheets, supporting more integrated and comprehensive models.
  • Formula / Function Support offers the computational foundation of spreadsheets, with a wide range of built-in functions for mathematical, logical, and statistical operations.
  • Table Support gives structure to related rows and columns, adding features such as auto-expansion and easier formula referencing.
  • Sparklines deliver compact, cell-level charts that provide immediate visual context to numeric trends without the need for larger, standalone charts.

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

Explore React Spreadsheet Features

Ajoutez une logique personnalisée aux formules Excel

Septembre 26, 2025
EPPlus Software v8.2.0 ajoute la prise en charge de 8 nouvelles fonctions basées sur LAMBDA, permettant des formules personnalisées, des tableaux dynamiques et des transformations de données.

EPPlus is a powerful and versatile .NET library for managing and manipulating Microsoft Excel files using the Office Open XML (OOXML) format. It is a lightweight and efficient library that is easy to use and can be integrated into a wide range of applications. It allows developers to create, read and modify spreadsheets without dependencies on any other library. Features include pivot tables, styling, VBA/Form controls, conditional formatting, charts, tables, formula calculation, data validation, pictures/shapes, and more.

The EPPlus v8.2.0 update introduces support for eight new LAMBDA-based functions, giving developers greater flexibility and control when working with Excel workbook calculations. With these additions, you can now define custom functions directly in the workbook, streamline array transformations, apply operations by row or column, and handle iterative or conditional logic more efficiently. This enhancement reduces the need for repetitive formulas or external code, enabling cleaner, more maintainable spreadsheets that better align with modern programming practices.

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

EPPlus is licensed per developer and is available as both perpetual licenses and subscription based licenses with periods of 1 year and 2 years, which include support and upgrades. See our EPPlus licensing page for full details.

For more information, see our EPPlus product page.

Transformez des fichiers plats en feuilles de calcul interactives

Septembre 16, 2025
L’importation de fichiers CSV dans des composants de tableur permet aux utilisateurs de manipuler, de formater et d’analyser des données en texte brut à l’aide d’interfaces familières.

Importing CSV files in spreadsheet components allows developers and end-users to load tabular data from simple text-based formats into an interactive grid. The feature typically supports reading CSV with various delimiters, optional headers, and options about how to treat quoted text, line endings, and text formatting. It provides a bridge between raw data sources (spreadsheets exported from other tools, logs, exports from databases) and richer in-browser or in-application editing, formatting, analysis, or further exporting. For many applications, being able to accept CSV imports is essential for interoperability, ease of data ingestion, and enabling users without deep technical skills to bring their data into a system.

Several React spreadsheet controls offer the ability to import CSV files including:

  • SpreadJS by MESCIUS lets you import CSV files directly into the spreadsheet, preserving data formatting, formulas, and structure for immediate editing.
  • Syncfusion Spreadsheet JavaScript (part of Syncfusion Essential Studio Enterprise) allows you to load CSV files into interactive sheets.
  • Jspreadsheet Pro facilitates easy CSV file import, instantly converting raw data into an editable spreadsheet with sorting, filtering, and customization options.

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

Compare React Spreadsheet Controls