Noticias sobre Spreadsheets

Agregue una tabla dinámica de Vue a su aplicación web

Octubre 14, 2025
Las tablas dinámicas de SpreadJS proporcionan una forma eficaz de explorar y resumir fácilmente grandes conjuntos de datos.

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.

Convierta los datos sin procesar en información clara

Octubre 7, 2025
Con funciones de clasificación, agrupación y cálculo, las hojas de cálculo transforman grandes conjuntos de datos en información estructurada, significativa y útil.

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

Agregue lógica personalizada a fórmulas de Excel

Septiembre 26, 2025
EPPlus Software v8.2.0 agrega soporte para 8 nuevas funciones basadas en LAMBDA, lo que permite fórmulas personalizadas, matrices dinámicas y transformaciones de datos.

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.

Convierta archivos planos en hojas de cálculo interactivas

Septiembre 16, 2025
La importación de archivos CSV en componentes de hoja de cálculo permite a los usuarios manipular, formatear y analizar datos de texto sin formato utilizando interfaces conocidas.

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

Edite más rápido con introducción de datos en las celdas

Septiembre 5, 2025
Realice correcciones rápidas o ajustes detallados directamente en la hoja de cálculo, manteniendo el control sobre la precisión de los datos y la eficiencia del flujo de trabajo.

In-cell data editing allows information to be modified directly within a spreadsheet cell rather than through separate forms or dialog boxes. This approach speeds up data entry, provides immediate visual feedback, and makes it easier to spot and correct mistakes in context. It enhances efficiency by reducing interruptions, lowering cognitive effort, and offering a familiar Excel-style experience. Common use cases include updating financial figures, adjusting inventory records, or revising project timelines where quick, accurate edits are essential.

Several JavaScript spreadsheet controls support in-cell data editing including:

  • Telerik Spreadsheet React lets users edit data directly within spreadsheet cells, enabling quick adjustments, streamlined workflows, and accurate real-time updates.
  • Wijmo FlexSheet by MESCIUS allows direct in-cell editing, giving developers Excel-like functionality with efficient data entry, contextual corrections, and improved productivity.
  • Jspreadsheet Pro enables in-cell editing within modern web applications, offering instant changes, enhanced usability, and efficient management of large datasets.
  • Infragistics Spreadsheet Angular facilitates editing directly in grid cells, supporting faster updates, reduced errors, and seamless interaction with surrounding dataset context.

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

Compare JavaScript Spreadsheet Controls