Spreadsheets 新闻

使用 WPF 导入和导出 Excel XLSX 文件

11月 27, 2025
使用 Spread.NET 在您的 WPF 应用中轻松导入和导出 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. You can develop in Visual Studio using VB or C# for WinForms, ASP.NET, and WPF.

In this blog post, MESCIUS Product Marketing Specialist Mackenzie Albitz guides you through four essential steps for importing and exporting Excel spreadsheets in your WPF applications:

  • Create a C#/VB WPF Spreadsheet Application
  • Define the User Interface for a WPF Spreadsheet App
  • Add Excel XLSX Import Code - OpenExcel Method
  • Add Excel XLSX Export Code - SaveAs Method

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

Read the complete blog post to learn the steps for integrating this powerful Excel functionality into 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.

用内置数据验证确保准确性

11月 11, 2025
用内置验证工具维护可靠的电子表格数据输入，该工具可防止错误并保持共享工作簿之间的数据完整性。

Data validation in spreadsheets allows users to control what information can be entered into each cell, ensuring that data remains accurate and consistent across a workbook. By defining specific rules and restrictions, it helps prevent incorrect inputs and maintains the integrity of shared data. Users can provide guidance through prompts or drop-down lists, reducing the likelihood of errors and saving time on data correction. This feature is especially valuable in collaborative settings, such as managing budgets, tracking inventory, or collecting survey responses, where reliable data entry is essential for accurate analysis and reporting.

Several ASP .NET Core spreadsheet products offer data validation, including:

  • DevExpress ASP.NET Core Spreadsheet (part of DevExpress ASP.NET and Blazor) lets you control data accuracy by defining validation rules and guiding users with clear feedback.
  • Aspose.Cells for .NET allows you to enforce consistent data entry by applying validation rules, dropdown lists, and custom error alerts.
  • Telerik ASP.NET Core Spreadsheet (part of DevExpress ASP.NET and Blazor) validates inputs, preventing errors, and maintaining consistent information across workbooks.
  • Syncfusion ASP.NET Core Spreadsheet (part of Syncfusion Essential Studio Spreadsheet Editor SDK) enables data entry through automatic prevention of invalid values.

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

Compare ASP .NET Core Spreadsheet Controls

从 Vue.js 应用程序打印电子表格

11月 7, 2025
允许最终用户通过将打印功能集成到您的应用程序中来查看、分发和存档电子表格数据。

The ability to print spreadsheets is a core feature that produces a physical copy or a formatted digital version, such as a PDF, of the data and layout contained within a spreadsheet file. This function allows users to review, distribute, archive, or present the original information that preserves the structure in a readable and consistent format. By configuring print settings, such as page orientation, scaling, and headers, users can control how the content appears on paper, ensuring clarity and professionalism in the output. It is especially useful for reports, financial statements, and records that need to be reviewed offline or submitted in a formal context.

Several Vue.js spreadsheet components enable printing, including:

  • SpreadJS by MESCIUS allows you to print spreadsheets with full control over pagination, scaling, headers, and print areas for polished output from Vue.js applications.
  • Jspreadsheet Pro enables in-browser table printing and exporting with consistent formatting, making it ideal for lightweight, client-side spreadsheet applications.
  • Syncfusion Vue Spreadsheet (part of Syncfusion Essential Studio Spreadsheet Editor SDK) provides end-users with advanced printing options for all spreadsheet content.

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

Compare Vue.js Spreadsheet Components

用分组和筛选功能组织电子表格

10月 23, 2025
用直观的分组和筛选工具轻松组织、浏览和分析数据，这些工具可在电子表格中创建可折叠的大纲。

Grouping and filtering are key spreadsheet tools that make data easier to manage and analyze. Grouping combines related rows or columns into collapsible sections for clearer summaries. Filtering displays only the information that meets specific conditions, helping focus on what matters most. Together, these features improve data management, reduce visual clutter, and enhance analytical clarity.

Several .NET WinForms spreadsheet controls contain data filtering and grouping controls including:

  • DevExpress WinForms Spreadsheet (part of DevExpress WinForms) lets you efficiently organize and analyze large datasets by grouping and filtering data.
  • Spread.NET WinForms (part of Spread.NET by MESCIUS) allows you to manage complex spreadsheets with intuitive grouping and advanced filtering for focused data analysis.
  • Infragistics WinForms Spreadsheet (part of Infragistics Ultimate UI for Windows Forms) facilitates data exploration through grouping and precise filtering.
  • MindFusion.Spreadsheet for WinForms enables streamlined data management with collapsible grouping and targeted filtering to simplify data review.

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

Compare .NET WinForms Spreadsheet Controls

在电子表格应用程序中支持 PDF 导出

10月 14, 2025
为 Angular 应用程序配备将电子表格导出为 PDF 的功能，从而生成保留原始内容的易分发的文档。

Exporting a spreadsheet to PDF is a widely used feature that allows users to generate fixed-layout, print-ready versions of their spreadsheet data, converting the contents of the spreadsheet file, into a Portable Document Format (PDF) file. This capability ensures that formatting, styling, and content of the original spreadsheet, including tables, charts, and cell styles, are preserved exactly as intended, regardless of the device or application used to open the file. It is especially useful for sharing finalized documents, such as reports or financial summaries, with stakeholders who do not need to interact with the data directly.

Several Angular spreadsheet components allow you to export to PDF, including:

  • SpreadJS by MESCIUS allows you to directly export complex spreadsheets to PDF from Angular applications with full support for cell styles, formulas, charts, and custom layouts.
  • Jspreadsheet Pro grants straightforward PDF conversion via the export to PDF extension, supporting layout and styling preservation and versatile document sharing.
  • Syncfusion Spreadsheet JavaScript (part of Syncfusion Essential Studio Enterprise) enables users to save high-quality PDF versions of their spreadsheets in Angular applications.

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

Compare Angular Spreadsheet Components