Spreadsheets 新聞

將 WinForms 樞紐分析表添加到您的 .NET 應用程式

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.

用單元內超連結改進導航

3月 20, 2026
透過對實現連結資料與資源之間高效導航的內置超連結的支援增強 WPF 應用程式中試算表的可用性。

Hyperlink support in a spreadsheet allows a cell to reference an external resource, such as a web page, email address, file, or another location within the workbook. This capability enables users to connect data with relevant context, making it easier to navigate between related information and systems. By embedding links directly into cells, spreadsheets can serve not only as data stores but also as interactive interfaces, improving usability, reducing the need for manual lookup, and supporting more efficient processes across applications and datasets.

Several WPF spreadsheet components allow you to add hyperlinks within cells, including:

  • DevExpress WPF Spreadsheet (part of DevExpress WPF) enables hyperlinks in cells or ranges via its worksheet hyperlink collection, supporting both UI and API use.
  • Spread.NET by MESCIUS provides hyperlink support in WPF through a cell-level property and hyperlink object model defining link targets and types.
  • Telerik UI for WPF Spreadsheet (part of Telerik UI for WPF) supports hyperlinks by linking them to cell ranges, enabling web, email, or workbook links via its API.
  • Syncfusion WPF Spreadsheet (Syncfusion Essential Studio Enterprise) supports Excel-style hyperlinks, allowing assignment to cells through its API and UI.

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

Compare WPF Spreadsheet Components

用樞紐分析表更快地分析大型資料集

3月 17, 2026
JSpreadsheet Pro 添加強大的樞紐分析表，其可透過靈活的分組、篩選、排序和折疊視圖匯總試算表資料。

Jspreadsheet Pro is a flexible JavaScript-based spreadsheet solution that enables developers to create customizable, feature-rich data grids for web applications. It offers advanced formulas, data validation, and API integrations. Ideal for tasks like financial modeling, inventory management, and project tracking, it helps businesses efficiently manage and analyze data.

Jspreadsheet Pro introduces pivot table functionality that allows developers to summarize and analyze large datasets directly within browser based spreadsheet applications. It enables users to group data across multiple rows and columns, apply aggregation methods such as sum or average, and refine results through filtering and sorting. With built in spreadsheet formulas and cross worksheet references, developers can provide interactive data analysis capabilities without requiring external tools or additional backend processing.

Jspreadsheet Pro is licensed as an Annual or a Perpetual License with support and maintenance. We can supply any Jspreadsheet Pro license including new licenses, maintenance renewals, and upgrade licenses. See our Jspreadsheet Pro for full details.

For more information, visit our Jspreadsheet Pro product page.

應用可實現試算表一致設計的主題

3月 16, 2026
用可立即應用一致顏色和字體的可自訂主題加強試算表設計，呈現更清晰的資料。

Spreadsheet themes provide a consistent visual style by applying coordinated colors, fonts, and formatting across an entire workbook. Instead of manually styling individual elements, users can quickly apply a theme to ensure tables, charts, and data ranges follow the same design. This improves readability, enhances data presentation, and helps maintain a professional and cohesive look across reports. Themes are particularly useful when creating business dashboards, financial reports, or shared team documents, where consistent formatting and clear visual hierarchy make data easier to interpret and align with company branding.

Several JavaScript spreadsheet controls offer support for applying themes including:

  • Kendo UI jQuery Spreadsheet (part of Kendo UI) by Telerik lets you apply consistent styling with customizable themes that unify fonts, colors, and formatting.
  • SpreadJS by MESCIUS allows you to implement reusable spreadsheet themes that standardize visual styles across worksheets, improving clarity and branding consistency.
  • Infragistics Ultimate UI for jQuery Spreadsheet (part of Infragistics Professional) facilitates spreadsheet styling with theme based formatting that aligns colors, fonts, and layouts.
  • Jspreadsheet Pro enables developers to style spreadsheets with configurable themes that create consistent visual structure and enhance readability across web based tables.

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

Compare JavaScript Spreadsheet Controls

支援跨工作表試算表計算

3月 13, 2026
引用其它工作表的儲存格來建立連結計算，其可保持相關資料的組織性與動態連結。

Cross-worksheet calculations allow spreadsheet components to reference and compute values across multiple sheets within the same workbook. This capability enables developers to build more advanced data models, where formulas can pull information from different worksheets to support summaries, aggregations, and linked analysis. By allowing data to be organized across separate sheets while remaining connected through formulas, applications can present complex datasets in a structured and scalable way without sacrificing calculation accuracy or performance.

Several Angular spreadsheet controls offer support for cross-worksheet calculations including:

  • SpreadJS by MESCIUS enables formulas to reference cells and ranges across worksheets, allowing developers to create linked calculations across multiple sheets.
  • Infragistics Ignite UI for Angular Spreadsheet supports cross-sheet formulas that allow values from different worksheets to be combined in calculations.
  • Syncfusion Angular Spreadsheet includes built-in formula support that references cells in other worksheets, making it possible to perform calculations across different tabs.
  • Jspreadsheet Pro provides cross-sheet references within formulas, enabling calculations that draw values from other worksheets to support multi-sheet data organization.

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

Compare Angular Spreadsheet Controls