Spreadsheets 뉴스

웹 애플리케이션에 Vue 피벗 테이블을 추가하세요

10월 14, 2025
SpreadJS 피벗 테이블(Pivot Tables)은 대규모 데이터 세트를 쉽게 탐색하고 요약할 수 있는 강력한 방법을 제공합니다.

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.

원시 데이터를 명확한 인사이트로 변환하세요

10월 7, 2025
스프레드시트는 정렬, 그룹화, 계산 기능을 통해 방대한 데이터를 유의미하고 유용한 구조화된 정보로 변환합니다.

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

Excel 수식에 사용자 정의 로직을 추가하세요

9월 26, 2025
EPPlus Software v8.2.0은 8개의 새로운 LAMBDA 기반 함수를 지원하여, 사용자 정의 수식과 동적 배열을 구현하고 데이터 변환 작업을 수행할 수 있습니다.

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.

플랫 파일을 대화형 스프레드시트로 변환하세요

9월 16, 2025
CSV 파일을 스프레드시트 구성요소로 가져오면, 사용자는 친숙한 인터페이스를 통해 단순 텍스트 데이터를 조작, 서식 지정, 분석할 수 있습니다.

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

셀에 직접 데이터를 입력하여 더 빠르게 편집하세요

9월 5, 2025
스프레드시트에서 직접 빠르게 수정하거나 세부적으로 조정하여 데이터 정확성 및 워크플로우 효율성을 관리할 수 있습니다.

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