Spreadsheets 新聞

保護 WPF 試算表應用程式中的資料

7月 8, 2025
利用試算表安全功能來防止未經授權的訪問並限制資料修改，從而在 WPF 桌面應用中授予更大的控制權。

Spreadsheet security features are essential tools designed to protect sensitive data, ensure data integrity, and control user access within spreadsheet applications. These capabilities typically include such measures as password protection or cell locking, and are used to prevent the unauthorized viewing or modification of content in the spreadsheet. Implementing security measures in their spreadsheets allows organizations to maintain compliance with data security standards or data governance policies, and avoid accidental or malicious data loss or alteration. This level of control is particularly important in environments where multiple users collaborate on financial models, project plans, or other critical datasets.

Several WPF spreadsheet components offer security features, including:

  • DevExpress WPF Spreadsheet (part of DevExpress WPF) offers various levels of password encryption for workbooks, worksheets and specific ranges to protect spreadsheet data.
  • Spread WPF (part of Spread.NET by MESCIUS) provides workbook and worksheet protection with support for cell locking and setting passwords in WPF spreadsheet apps.
  • Telerik WPF Spreadsheet (part of Telerik UI for WPF) includes full support for workbook and worksheet level protection mechanisms to control and enforce user rights.
  • Infragistics WPF Spreadsheet (part of Infragistics Ultimate UI for WPF) has a range of protection settings to safeguard content from unauthorized modifications.

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

Compare WPF Spreadsheet Components

在 Blazor 項目中提供類似 Excel 的試算表

7月 7, 2025
Syncfusion Essential Studio Blazor 2025 Volume 2 添加試算表功能，如儲存格編輯、圖像插入和超連結支援。

Syncfusion Essential Studio Blazor (available as part of Syncfusion Essential Studio Enterprise) is a comprehensive UI component library designed to accelerate the development of high-performance, modern web applications using the Blazor framework. It boasts over 85+ responsive, lightweight, and modular components spanning various categories such as data visualization, data editing, document processing, and interactive UI elements. This rich repertoire empowers developers to rapidly build user-friendly, feature-rich web interfaces, with seamless integration of both server-side and client-side Blazor applications.

The Syncfusion Essential Studio Blazor 2025 Volume 2 update introduces a new Spreadsheet control (in preview) that provides developers with an Excel-like environment for web applications, enabling efficient data manipulation, formula-based calculations, and file operations. This control supports core spreadsheet functionality such as cell editing, formatting, sorting, and selection, while also allowing for interactive features like dynamic resizing, autofill, image insertion, and hyperlink support. Designed with performance and scalability in mind, the Spreadsheet control helps developers manage complex data scenarios and deliver responsive, user-friendly interfaces within their Blazor applications.

To see a full list of what's new in 2025 Volume 2, see our release notes.

Syncfusion Essential Studio Blazor is available as part of Syncfusion Essential Studio Enterprise which is licensed per developer starting with a Team License of up to five developers. It is available as a 12 Month Timed Subscription License which includes support and maintenance. See our Syncfusion Essential Studio Enterprise licensing page for full details.

Learn more on our Syncfusion Essential Studio Blazor product page.

組織資料以更快獲得洞察力

6月 26, 2025
排序功能允許試算表使用者根據所選列值排列行，以便為大型資料集提供結構。

Data sorting in a spreadsheet control is a fundamental feature that enables users to rearrange data within a grid or table based on specific criteria, typically ascending or descending alphabetically or by numerical value. Sorting will usually be performed on single or multiple columns and is often integrated with other data manipulation tools like filtering, grouping, and searching. By sorting data, users can quickly locate and analyze information, identify patterns, and ensure consistency across records. Especially useful in large datasets, it improves the readability of the information and makes it more organized in preparation for decision-making, reporting, and data validation. This capability facilitates efficient data analysis, and supports better user interaction by allowing datasets to be viewed in meaningful sequences.

Several WPF spreadsheet controls offer support for data sorting including:

  • DevExpress WPF Spreadsheet (part of DevExpress WPF) offers built-in dialog boxes for single- and multi-column sorts, along with support for custom comparison.
  • Spread WPF by MESCIUS provides a flexible API for applying sorts programmatically or through the user interface, including options for nested multi-key sorts.
  • Telerik WPF Spreadsheet (part of Telerik UI for WPF) supports interactive column and row sorting, multi-field sorting, and programmatic control over sort direction and key range.
  • Syncfusion WPF Spreadsheet (part of Syncfusion Essential Studio Enterprise) includes context-menu and dialog-based sorting for one or more columns.

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

Compare WPF Spreadsheet Controls

用試算表同步即時協作

6月 24, 2025
SpreadJS 透過提供無衝突編輯的模組化協作框架在 JavaScript 應用程式中實現無縫即時協同編輯。

SpreadJS is a high-performance JavaScript spreadsheet and data presentation component designed for enterprise web applications. It enables developers to deliver Excel-like functionality directly within their web solutions, providing advanced features such as data binding, complex calculations, pivot tables, charts, and extensive formatting options. Fully compatible with modern JavaScript frameworks like React, Angular, and Vue, SpreadJS allows seamless integration and customization, empowering development teams to create interactive, data-driven user experiences without relying on external spreadsheet applications.

SpreadJS enables real-time collaboration within JavaScript spreadsheet applications through a modular, extensible framework currently available as a Developer Preview. This feature allows multiple users to work on the same spreadsheet simultaneously, maintaining data consistency and reducing the complexity of building collaborative functionality from scratch. It supports low-latency data synchronization, user presence indicators, and conflict-free concurrent editing, allowing multiple users to work simultaneously while maintaining consistent data states. Designed to integrate with various document types and backend systems, it simplifies the development of collaborative features without requiring developers to build the infrastructure from scratch. An online collaboration demo is available to explore these capabilities in action.

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.

透過自訂儲存格樣式增強資料清晰度

6月 11, 2025
用字體、顏色、邊框和數位樣式設置試算表儲存格的格式，使複雜資料呈現更清晰、更專業。

Cell formatting in spreadsheet components allows developers to manipulate the visual presentation of spreadsheet data, enhancing clarity and usability. This includes adjusting font styles, colors, borders, number formats, and alignment, which is especially valuable for building business or financial applications where precise data representation is critical. Such formatting capabilities ensure that end-users can interact with spreadsheets that are both functional and aesthetically tailored to the specific context of the application.

Several ASP.NET Core spreadsheet components support cell formatting, including:

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

Compare ASP.NET Core Spreadsheet Controls