Spreadsheets 新聞

用 XML 轉換試算表資料

7月 29, 2025
.NET WinForms 試算表控制項可以將資料匯出為 XML，從而確保用一致的可移植格式實現可靠的資料交換。

Export to XML in a .NET WinForms Spreadsheet control allows developers to convert and save spreadsheet data into an XML (Extensible Markup Language) format, preserving the structure, content, and metadata of the spreadsheet in a standardized and portable form. This capability is particularly useful for integrating spreadsheet data with other systems, enabling data exchange, storage, or transformation. By using XML, the exported data can be consumed by a wide range of applications and platforms, making it easier to support interoperability and maintain consistency across different environments.

Several .NET 9 WinForms Spreadsheet controls offer Export to XML including:

  • Spread.NET WinForms by MESCIUS facilitates XML export of worksheet data, enabling integration with XML-based systems and workflows in a structured format.
  • DevExpress WinForms Spreadsheet (part of DevExpress WinForms) allows you to export spreadsheet content to XML, preserving data structure, formatting, and cell-level metadata for reuse.
  • Aspose.Cells for .NET lets you save spreadsheets as XML with full fidelity, supporting formulas, styles, and complex layout configurations.

For an in-depth analysis of features and price, visit our comparison of .NET 9 WinForms Spreadsheet Controls.

Compare .NET 9 WinForms Spreadsheet Controls

使視覺物件在 Excel 頁面之間保持一致

7月 22, 2025
Document Solutions for Excel, .NET Edition 支持圖像和形狀分頁，使視覺物件保持錨定到單元格以提高可讀性。

Document Solutions for Excel, .NET Edition by MESCIUS is designed to enable developers to create and manipulate Microsoft Excel documents programmatically within .NET applications. It provides a robust API for interacting with Excel spreadsheets, allowing developers to automate tasks such as data extraction, formatting, and generation of reports. The framework offers comprehensive support for various Excel features, including formulas, charts, conditional formatting, and data validation. It also provides tools for handling large datasets and optimizing performance, making it suitable for both small-scale and enterprise-level applications.

Document Solutions for Excel, .NET Edition improves pagination by enabling images and shapes to stay anchored to their top-left cell, maintaining consistent positioning as content flows across pages. This enhancement ensures that visual elements such as charts, icons, and shapes are treated as part of the cell's content, allowing them to paginate along with the data they relate to. As a result, developers can generate dynamic, multi-page Excel documents with accurate and predictable layouts, without having to manually reposition or reformat visuals. This not only saves time during document generation but also improves the overall quality and reliability of exported reports, forms, and other structured content.

Document Solutions for Excel is licensed per developer and is available in several license options for differing distribution needs. Team licenses are also available for multiple developers within the same organization. See our Document Solutions for Excel, .NET Edition licensing page for full details.

Document Solutions for Excel, .NET Edition is available to buy in the following products:

用錨定的行和列輕鬆導航

7月 17, 2025
透过保持關鍵行和列可見，凍結窗格增強了試算表的清晰度，從而實現更輕鬆的導航和準確的資料分析。

Freeze Panes in spreadsheets is a feature that keeps selected rows or columns visible while you scroll through your data. This helps maintain context in large spreadsheets by keeping headers or labels in view, making it easier to read, analyze, and enter information accurately. Common use cases include freezing the top row in a budget sheet to keep month names visible, or locking the first column to see item names while reviewing data across many columns. It is especially valuable in financial reports, sales tracking, and project management tools where clarity and precision are essential.

Several ASP.NET Core spreadsheet controls offer freeze pane support including:

  • Syncfusion ASP.NET Core Spreadsheet (part of Syncfusion Essential Studio Enterprise) allows you to lock headers in place with Freeze Panes, improving data readability.
  • Telerik ASP.NET Core Spreadsheet (part of Telerik UI for ASP.NET Core) facilitates Freeze Pane functionality, ensuring critical rows or columns remain visible.
  • Aspose.Cells for .NET lets you freeze rows and columns programmatically to keep headers visible while navigating large Excel files effortlessly.
  • DevExpress ASP.NET Core Spreadsheet (part of DevExpress ASP.NET and Blazor) enables developers to freeze rows or columns, maintaining context and improving usability.

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

Compare ASP.NET Core Spreadsheet Controls

用智慧自動填充加快資料登錄

7月 16, 2025
Syncfusion Essential Studio Windows Forms 2025 Volume 2 將自動填充和填充系列添加到 Excel 庫，以實現更快的基於模式的儲存格填充。

Syncfusion Essential Studio Windows Forms (available as part of Syncfusion Essential Studio Enterprise) is a powerful UI component suite designed to enhance your WinForms development. It boasts over 100 high-performance controls, ranging from essential grids and charts to advanced schedulers and diagrams, enabling you to craft visually appealing and feature-rich applications with ease. Its extensive customization options and built-in themes allow for tailored user experiences, while touch-friendly design ensures seamless interaction across devices.

The Syncfusion Essential Studio Windows Forms 2025 Volume 2 update introduces Auto Fill and Fill Series support in the Excel Library, enabling developers to programmatically populate cell ranges based on detected patterns, sequences, or trends. This enhancement improves spreadsheet generation by reducing manual data entry and allows for efficient creation of structured data such as incremental numbers, dates, or custom-defined sequences. It improves automation in Excel-based workflows, supports consistent data output, and integrates smoothly into existing .NET applications for more dynamic and intelligent document processing.

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

Syncfusion Essential Studio Windows Forms 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 Windows Forms product page.

簡化了試算表資料區域的選擇

7月 15, 2025
Telerik UI for WPF 允許使用者立即選擇一系列相鄰的非空儲存格，從而簡化了試算表中的資料操作。

Telerik UI for WPF is a comprehensive suite of over 150 user interface components designed for Windows Presentation Foundation, enabling developers to build modern, high-performance desktop applications. It includes controls like data grids, charts, schedulers, and editors, optimized for seamless integration and support for MVVM (Model-View-View-Model) patterns. With features like built-in theming, responsive layouts, and customizable styling, it simplifies the creation of visually appealing, intuitive interfaces. Ideal for enterprise-grade or consumer-facing apps, Telerik UI for WPF accelerates development while ensuring professional-quality results.

Telerik UI for WPF now supports a 'CurrentRegion' selection property and corresponding UI command in its Spreadsheet control, enabling quick selection of adjacent, non-empty cells around the active cell. This feature replicates Microsoft Excel’s behavior, making it easier to apply formulas, format ranges, or export grouped data without manually selecting each cell. By automatically identifying relevant data regions, it enhances efficiency and creates a smoother, more intuitive user experience.

Telerik UI for WPF is licensed per developer and has two licensing models: an annual Subscription License and a Perpetual License. The Subscription license provides access to the latest product updates, technical support, and exclusive benefits for a flat annual fee, and must be renewed to continue using the software. The Perpetual license is a one-time purchase granting access to the current released version and includes a one-year subscription for product updates and technical support. After this initial period, users can choose to renew the subscription element to continue receiving updates and support; otherwise, they may continue using the installed version available during their active subscription term but will forgo future updates and support. See our Telerik UI for WPF licensing page for full details.

Telerik UI for WPF is available individually or as part of the following products: