Spreadsheets 新聞

用表格增強資料組織

8月 20, 2024
試算表中的表格提供了一種結構化的方式來組織資料、增強資料完整性並實現高效的分析和報表。

繼續用英語閱讀:

Spreadsheet tables are organized groups of data in a spreadsheet, often with a header row and a range of cells containing related information. They make data management easier by grouping related information, improving how it looks and how easy it is to use. You can use functions and formulas on entire tables to automate calculations and reduce manual work. Tables often let you filter and sort data based on specific criteria, making analysis and reporting easier. Common uses include financial analysis, inventory management, project tracking, and customer databases.

Several WinForms spreadsheet controls offer table support including:

  • DevExpress WinForms Spreadsheet (part of DevExpress WinForms) enables developers to create and manage tables with sorting, filtering, and data binding capabilities.
  • Aspose.Cells for .NET provides programmatic control over tables in Excel files, enabling creation, formatting, and manipulation.
  • Spread.NET WinForms (part of Spread.NET by MESCIUS) simplifies creating data-bound tables with automatic formatting and built-in filtering options.
  • Infragistics WinForms Spreadsheet (part of Infragistics Ultimate UI for Windows Forms) allows users to define and format tables, offering filtering and calculated columns.

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

Compare WinForms Spreadsheet Controls

使用 WPF 導入和匯出 Excel XLSX

8月 9, 2024
瞭解 MESCIUS 推出的 Spread.NET 如何透過 C# 或 VB 中的 Excel 試算表無縫導入和匯出功能來增強您的 WPF 項目。

繼續用英語閱讀:

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 guides you through the four essential steps to import and export Excel spreadsheets on your way to creating robust spreadsheet applications with Spread.NET. These steps include:

  • Create a WPF Spreadsheet Application
  • Define the User Interface for a WPF Spreadsheet App
  • Add Excel XLSX Import Code - Invoke ExcelOpen Method
  • Add Excel XLSX Export Code - Invoke SaveExcel Method

Sample code is included in the blog and you can download the sample app in either C# or VB.

Read the full blog to get started using the full capabilities of the Spread.NET WPF component.

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.

允許試算表執行剪貼板操作

8月 2, 2024
用剪切、複製和粘貼資料的功能增強 Angular 試算表應用程式，從而簡化了資料操作和管理任務。

繼續用英語閱讀:

A spreadsheet control that supports clipboard operations gives users the ability to cut, copy and paste data within or between spreadsheets. These functions enable users to efficiently transfer, duplicate, or relocate information by temporarily storing selected cells or ranges in a system-wide clipboard. This functionality forms a key part of a spreadsheet application, saving time and increasing productivity by enabling quick duplication or relocation of data without the need to manually re-enter information. By reducing the risk of errors that might occur during manual data entry or reformatting, these operations help maintain data integrity and streamline data manipulation and management tasks.

Several Angular spreadsheet components support the use of clipboard operations, including:

  • SpreadJS by MESCIUS is a complete JavaScript spreadsheet solution with full support for Angular that allows users to easily perform clipboard operations.
  • Jspreadsheet Pro facilitates clipboard integration into Angular applications, providing seamless data transfer with intuitive cut, copy, and paste functionalities.
  • Infragistics Spreadsheet Angular (part of Infragistics Ignite UI) is a lightweight component that enables users to perform cut, copy, and paste clipboard operations.
  • Syncfusion Spreadsheet JavaScript (part of Syncfusion Essential Studio Enterprise) lets you execute clipboard commands for easy data manipulation in Angular.

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

Compare Angular Spreadsheet Controls

在 C# .NET 中將 XLSX 匯出為 PDF、圖像、JSON 或 HTML

8月 2, 2024
利用 Document Solutions for Excel, .NET Edition 的強大功能，以程式設計方式將 Excel 報表匯出為多種格式。

繼續用英語閱讀:

Document Solutions for Excel, .NET Edition is a high-speed, small-footprint, server-side spreadsheet API that requires no dependencies on Excel. The interface-based API is modeled on Excel's document object model which means you can import, calculate, query, generate, and export any spreadsheet scenario. Using DsExcel, you can programmatically create Excel reports, sorted and filtered tables, sorted and filtered pivot tables, dashboard, add charts, sparklines, conditional formats, import and export Excel templates and also convert spreadsheets to PDF, HTML, or an image format.

In this blog post, MESCIUS Software Engineer Prabhat Sharma demonstrates the exporting capabilities of the DsExcel API including exporting Excel XLSX to formats such as PDF, image, JSON, and HTML. Source code is included for each step, showing you how to use Document Solutions to export reports in each format.

Read the complete blog and learn how to make your data more accessible and versatile.

Document Solutions for Excel, .NET Edition 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.

Learn more on our Document Solutions for Excel, .NET Edition product page.

為儲存格內容提供其它資訊

7月 26, 2024
利用注釋來提供補充資訊、上下文或說明，否則會使試算表變得混亂。

繼續用英語閱讀:

Spreadsheet cell comments/tooltips, provide a way to display additional information on hover over a specific cell. This enhances the user experience by offering context beyond the cell's main value. Common use cases include displaying formulas used for calculations, extended data not suitable for the main view, or data validation rules. They improve spreadsheet clarity and reduce the need for separate documentation or cluttered cell content.

Several .NET WPF Spreadsheet controls offer cell comments/tooltips including:

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

Compare .NET WPF Spreadsheet Controls