Spreadsheetsのニュース

構造化スプレッドシートのテーブルでデータを整理

4月 10, 2026
構造化された整理、ソート、フィルタリング、一貫した計算、より明確な数式のために、スプレッドシート表でデータ管理を向上

Spreadsheet tables provide a structured way to organize and manage data by grouping related information into defined rows and columns with built in functionality. They enhance usability by enabling automatic sorting and filtering, consistent formula application through calculated columns, and clearer data interpretation with structured references and styling. Tables can also expand dynamically as new data is added, reducing manual updates and errors. Common use cases include managing financial records, analyzing sales performance, tracking inventory, and working with data bound to external sources, making them a powerful tool for both everyday tasks and advanced data analysis.

Several .NET spreadsheet controls offer table support including:

  • DevExpress Excel Spreadsheet API for .NET (part of DevExpress Office File API) allows you to manage spreadsheet tables with data binding and calculated columns.
  • EPPlus by EPPlus Software facilitates creation of spreadsheet tables with built in filtering, totals, and structured references to simplify data organization.
  • Infragistics Excel Framework lets you work with spreadsheet tables supporting dynamic ranges, consistent formulas, and enhanced formatting for efficient data handling.
  • Xceed Workbooks for .NET lets you create spreadsheet tables with structured data, enabling sorting, filtering, and consistent calculations across dynamic datasets.

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

Compare .NET Spreadsheet Controls

柔軟なデータ選択でチャートを作成

4月 1, 2026
Syncfusion Essential Studio Spreadsheet Editor SDKは、連続しないチャートレンジのサポートを追加し、隣接しないデータから動的なチャートを作成可能

Syncfusion Essential Studio Spreadsheet Editor SDK is a library that lets developers embed spreadsheet functionality into web and desktop applications without requiring Microsoft Excel. It supports editing, formatting, and data analysis features such as cross sheet formula calculation, data binding to local and remote sources including JSON and REST, conditional cell styling, charts, data validation, worksheet protection, and workbook permissions. Available across frameworks including Blazor, React, Angular, Vue, JavaScript, ASP.NET Core and MVC, WPF and WinForms, it helps teams deliver a familiar spreadsheet experience for use cases like reporting, budgeting, and forecasting directly within their applications.

The Syncfusion Essential Studio Spreadsheet Editor SDK 2026 Volume 1 update introduces discontinuous chart range support, enabling developers to create charts from multiple non-adjacent rows, columns, or cell ranges without modifying the original data structure. This capability provides greater flexibility when working with complex, fragmented, or selectively relevant datasets, eliminating the need for manual data consolidation or duplication. It also ensures that charts remain automatically synchronized with updates across all referenced ranges, supporting more accurate, efficient, and maintainable data visualization within modern web and enterprise applications.

To see a full list of what's new in Syncfusion Essential Studio Spreadsheet Editor SDK 2026 Volume 1 (33.1.45), see our release notes.

Syncfusion Essential Studio Spreadsheet Editor SDK is licensed per developer on a one year timed subscription basis, with runtime royalty free redistribution included when the subscription is current, and includes one year of unlimited technical support and updates. See our Syncfusion Essential Studio Spreadsheet Editor SDK licensing page for full details.

Learn more on our Syncfusion Essential Studio Spreadsheet Editor SDK product page.

条件付き書式でキーデータを強調表示

3月 31, 2026
セルにルールベースのスタイリングを適用し、ユーザーがトレンド、外れ値、重要な値を一目で素早く特定可能

Conditional formatting in spreadsheet components allows developers to dynamically change the appearance of cells based on their values or defined rules. This feature helps highlight important data points, trends, and exceptions without requiring manual updates, making it easier for users to interpret large datasets at a glance. By applying visual cues such as colors, icons, and data bars, conditional formatting enhances readability and supports faster, more informed decision-making within spreadsheet-driven applications.

Several Angular spreadsheet controls offer support for conditional formatting including:

  • SpreadJS provides a conditional formatting engine with support for rules such as data bars, color scales, and icon sets, enabling dynamic visualization of data.
  • Infragistics Ignite UI for Angular Spreadsheet (part of Infragistics Ignite UI) includes conditional formatting capabilities that allow developers to apply rule-based styling.
  • Syncfusion Angular Spreadsheet (part of Syncfusion Essential Studio Enterprise) offers conditional formatting features that support a variety of rule types and visual styles.

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

Compare Angular Spreadsheet Controls

各種AIプラットフォームのAPIを利用したAI連携機能

3月 26, 2026
SpreadJS V19JではAI連携機能が追加され、自然言語によるデータ分析や数式生成が可能となり、業務効率の向上が期待されます。

SpreadJSはWebアプリケーションでMicrosoft ExcelライクなUIと機能性を実現するために開発されたJavaScriptライブラリです。多数のExcel互換機能を備えるほか、TypeScriptでの開発や、Angular、React、Vue.jsをはじめとする主要JavaScriptフレームワークにも対応しています。付属するGUIデザイナもExcelに類似しているため、各種外観スタイルを直感的に操作できます。多くのコード量が必要な設定もノンコーディングで実現し、開発工数を大幅に削減します。

SpreadJS V19Jでは、各種AIプラットフォームのAPIと連携する機能が追加され、表計算環境におけるデータ活用が大きく進化しております。これにより、従来のように複雑な関数を扱うことなく、自然言語による指示でデータ分析や加工を実行できるようになっております。新たに追加されたAI関数として、AIへクエリを送信して分析を行う機能や、多言語翻訳、テキストの感情分析を行う機能が提供されております。これにより、従来は手作業で行っていた分析業務の効率化が可能となっております。また、数式エディタにもAI機能が組み込まれており、自然言語から数式を自動生成できるほか、作成した数式の内容を解析して説明を取得することが可能です。複雑なロジックの理解や保守性向上にも寄与いたします。

これらの機能により、SpreadJSは従来の表計算ツールから、AIと連携した高度なデータ分析基盤へと進化しており、さまざまな業務シーンでの活用が期待されます。

V19Jでの新機能一覧は、リリースノートを参考ください。

SpreadJSのライセンスは、開発ライセンスや配布ライセンス、テスト配布ライセンスなどの種類があります。なお、各ライセンスに付属されているサブスクリプション（1年間）にはテクニカルサポートや無償アップグレード等のサービスが提供されます。詳細は、SpreadJS（日本語版）のライセンス をご参考ください。

製品詳細及び販売情報は、SpreadJS（日本語版）のページをご参考ください。

 

.NETアプリケーションにWinFormsピボットテーブルを追加

3月 24, 2026
Spread.NETを使ってWindowsアプリケーション内で直接データを探索・分析可能

Spread.NET helps you create spreadsheets, grids, dashboards, and forms. It includes a powerful calculation engine with 450+ functions and the ability to import and export Excel spreadsheets. Leverage the extensive .NET spreadsheet API and powerful calculation engine to create analysis, budgeting, dashboard, data collection and management, scientific, and financial applications.

In this blog post, MESCIUS Product Marketing Specialist Mackenzie Albitz demonstrates how to build a Pivot Table using the Spread.NET WinForms component, enabling your users to quickly analyze large datasets with the ability to summarize, group, and reorganize data. Creating the Pivot Table includes the following steps:

  • Create a PivotCache
  • Create the Pivot Table
  • Access the PivotFields Collection
  • Add the Values Field
  • Configure the Row Fields
  • Configure the Column Fields
  • Add a Filter Field

Detailed source code and sample data are included to assist you along the way.

Read the complete blog post to learn how to integrate a spreadsheet component into your .NET applications and provide your users with familiar spreadsheet functionality without referring them to an external program.

Spread.NET is licensed per developer and is available as either a Perpetual or Annual license, depending upon geographic location. We can supply any Spread.NET license including new licenses, maintenance renewals, and upgrade licenses. See our Spread.NET licensing page for full details.

For more information, visit our Spread.NET product page.