Spreadsheets 新聞

將 WPF Excel XLSX 檢視器添加到您的桌面應用程式

4月 8, 2025
使用 MESCIUS 推出的 Spread.NET 以程式設計方式導入 Excel 檔、自訂工作表並防止最終使用者進行更改。

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 use Spread.NET to enable your WPF application to display or interact with Excel files using a dedicated viewer. She'll walk through how to add an Excel XLSX viewer to a WPF app using the WPF spreadsheet control, Spread.NET for WPF. You'll learn how to load a .xlsx file, lock down the worksheet, and allow users to edit only specific cells — perfect for budget forms, reports, or review-only sheets. Once you have created a WPF project, the steps are as follows:

  • Define the User Interface for the WPF Spreadsheet app
  • Import Excel (.xlsx) Files into the WPF App Excel Viewer
  • Protect the .NET Worksheet in the WPF Excel Viewer

Detailed sample code is included and you can even download a sample project to follow along.

Read the full blog post to learn how to add this versatile capability to your WPF applications.

Spread.NET is licensed per developer and is available as a Perpetual License with a 12 month support and maintenance subscription. 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.

在您的 .NET 9 應用程式中創建 Excel 文件

4月 2, 2025
Xceed Workbooks for .NET 2.0 允許開發人員在向前相容開發環境中使用 Excel 操作。

Xceed Workbooks for .NET is a software component designed for .NET developers that enables the creation and manipulation of Microsoft Excel .xlsx files directly within their applications, without requiring Microsoft Excel or Office to be installed; it provides an API that allows for programmatic control over spreadsheet content, formatting, and structure, facilitating tasks such as report generation, data analysis, and document automation.

The Xceed Workbooks for .NET 2.0 release adds support for .NET 9. This primarily ensures compatibility with the latest .NET ecosystem, allowing developers to leverage new features, performance improvements, and security enhancements within their applications. This compatibility future-proofs projects, minimizes integration issues, and maintains alignment with the evolving .NET platform, enabling developers to build more efficient and maintainable software using Xceed Workbooks.

To see a full list of what's new in version 2.0, see our release notes.

Xceed Workbooks for .NET is licensed per developer and is available as a perpetual license with 1 year of updates and support. See our Xceed Workbooks for .NET licensing page for full details.

Xceed Workbooks for .NET is available individually or as part of Xceed Ultimate Suite.

允許使用者剪切、複製和粘貼 試算表資料

3月 28, 2025
在保留結構、格式設置和多儲存格操作的同時，創建支援剪貼板操作的 .NET WPF 試算表應用程式。

Clipboard operation support lets users copy, cut, and paste data between spreadsheet instances or other applications while maintaining structure and formatting. This functionality ensures seamless data transfer, improving efficiency in data manipulation tasks. Modern implementations often include support for multi-cell operations, rich text handling, and programmatic access through APIs, allowing developers to integrate clipboard interactions into their applications. Clipboard support enhances usability and improves overall productivity in spreadsheet-based applications.

Several .NET WPF spreadsheet controls offer clipboard operations, including:

  • Spread WPF (part of Spread.NET by MESCIUS) lets you copy and paste spreadsheet data, preserving formatting, formulas, and multi-cell selections.
  • Telerik WPF Spreadsheet (part of Telerik UI for WPF) allows you to transfer data between applications while maintaining styles, formulas, and structured content.
  • Syncfusion WPF Spreadsheet (part of Syncfusion Essential Studio Enterprise) facilitates clipboard operations with rich text, formulas and multi-range selections.
  • MindFusion.Spreadsheet for WPF supports intuitive clipboard functionality, enabling structured data transfers while retaining formatting and multi-cell layouts.

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

Compare .NET WPF Spreadsheet Controls

將 Vue.js 試算表綁定到外部資料源

3月 19, 2025
資料綁定讓您將 Web 應用程式中的試算表連接到資料庫、API 和其它來源，從而使您的資料保持同步和最新狀態。

Data binding in a spreadsheet is the process of linking spreadsheet cells to external data sources, such as databases, APIs (Application Programming Interfaces), or other structured datasets, ensuring that the spreadsheet dynamically updates when the source data changes. This enables real-time synchronization, reducing manual data entry and minimizing errors. By automating data retrieval and updates, data binding enhances accuracy, supports complex calculations with live data, and improves efficiency, making it particularly useful for reporting, financial analysis, and business intelligence tasks. It also facilitates better collaboration by ensuring that all users work with the most current information, improving decision-making and overall productivity.

Several Vue.js spreadsheet components offer data binding functionality, including:

  • SpreadJS by MESCIUS is a complete spreadsheet solution which supports Vue.js and can equip web applications with dynamic data binding capabilities for real-time updates.
  • Jspreadsheet Pro offers developers a Vue compatible data grid with intuitive spreadsheet-like controls, including the ability to connect spreadsheets to external data sources.
  • Syncfusion Spreadsheet JavaScript (part of Syncfusion Essential Studio Enterprise) facilitates binding spreadsheet data for modern web frameworks such as Vue.

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

Compare Vue.js Spreadsheet Controls

透過對 Zoom 的支援改進試算表的可見性

3月 11, 2025
允許使用者專注於詳細的試算表資料或獲得更廣泛的概覽，從而滿足不同的視覺需求和分析要求。

Zooming in a spreadsheet component refers to the ability to scale the displayed content, effectively increasing or decreasing the visible size of cells, data, and gridlines. This feature allows users to adjust the level of detail shown, enabling them to gain a broader overview or focus on specific data segments. Developers implement this to enhance user experience by providing flexibility in data visualization, improving accessibility for users with varying visual needs, and facilitating efficient data analysis through customized display levels.

Several WinForms spreadsheet controls offer support for zooming including:

  • Spread.NET WinForms (part of Spread.NET by MESCIUS) provides deep zoom controls, enabling precise magnification for detailed analysis and effortless data inspection.
  • DevExpress WinForms Spreadsheet (part of DevExpress WinForms) allows zooming, scaling content smoothly for optimal readability, and adapting to various screen resolutions.
  • MindFusion.Spreadsheet for WinForms facilitates flexible zoom levels, empowering users to adjust views for focused data entry or comprehensive overview.
  • Syncfusion WinForms Spreadsheet (part of Syncfusion Essential Studio Enterprise) offers responsive zooming, ensuring clarity for intricate data sets.

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

Compare WinForms Spreadsheet Controls