Spreadsheetsのニュース

グループ化とフィルタリングでスプレッドシートを整理

10月 23, 2025
スプレッドシートに折りたたみ可能なアウトラインを作成する直感的なグループ化およびフィルタリングツールを使用して、データを簡単に整理、検索、分析可能

Grouping and filtering are key spreadsheet tools that make data easier to manage and analyze. Grouping combines related rows or columns into collapsible sections for clearer summaries. Filtering displays only the information that meets specific conditions, helping focus on what matters most. Together, these features improve data management, reduce visual clutter, and enhance analytical clarity.

Several .NET WinForms spreadsheet controls contain data filtering and grouping controls including:

  • DevExpress WinForms Spreadsheet (part of DevExpress WinForms) lets you efficiently organize and analyze large datasets by grouping and filtering data.
  • Spread.NET WinForms (part of Spread.NET by MESCIUS) allows you to manage complex spreadsheets with intuitive grouping and advanced filtering for focused data analysis.
  • Infragistics WinForms Spreadsheet (part of Infragistics Ultimate UI for Windows Forms) facilitates data exploration through grouping and precise filtering.
  • MindFusion.Spreadsheet for WinForms enables streamlined data management with collapsible grouping and targeted filtering to simplify data review.

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

Compare .NET WinForms Spreadsheet Controls

スプレッドシートアプリケーションでPDFエクスポートを有効化

10月 14, 2025
AngularアプリにスプレッドシートをPDFにエクスポートする機能を装備し、元のコンテンツが保存された簡単に配布可能なドキュメントを作成

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

VueピボットテーブルをWebアプリケーションに追加

10月 14, 2025
SpreadJSピボットテーブルは、大規模なデータセットを簡単に探索し、要約するための強力な方法を提供

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.