Spreadsheetsのニュース

スプレッドシートによるクリップボード操作の実行を可能に

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

VBAコードを埋め込んだXLSMファイルの管理

7月 17, 2024
Excelを使わずに.NETスプレッドシートアプリケーションでMicrosoft ExcelマクロとVisual Basic for Applications (VBA) コードを管理

.NET spreadsheet components with VBA code and macro support empower developers to integrate existing Excel automation functionalities within their applications. This unlocks the benefits of the .NET framework, enhancing performance, security, and scalability of spreadsheet operations. Developers can access, modify, and save embedded VBA scripts, ensuring seamless operation in environments that support VBA execution. This fosters continued automation and functionality even when legacy systems or non-VBA-enabled environments are involved, while also enabling code updates, debugging, and preparation for code-execution-friendly settings.

Several .NET spreadsheet components offer VBA code/macro support, including:

  • Aspose.Cells for .NET is an Excel spreadsheet programming API that allows you to modify macros and VBA code in the template file to streamline spreadsheet tasks in .NET apps.
  • Document Solutions for Excel, .NET Edition by MESCIUS allows users to load and save macro-enabled XLSM files.
  • EPPlus is a .NET library for managing Office Open XML spreadsheets. It is capable of creating, reading, deleting, and modifying VBA code.
  • Infragistics Excel Framework (part of Infragistics Ultimate UI for Windows Forms) supports workbooks in XLSM format with VBA code, enhancing .NET application development.

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

Compare .NET Spreadsheet Components

ユーザーがワークシートを簡単に切り替え可能

7月 8, 2024
タブを使用すると、スプレッドシートのユーザーはデータセット間をすばやく移動でき、複数のデータセクションを明確に視覚的に区別可能

Worksheet tabs act as a visual and interactive index, enabling users to seamlessly navigate between distinct sections within a single workbook. This efficient organization facilitates data comparison and analysis. The clear visual distinction between tabs reduces cognitive load and enhances comprehension, making it easier for users to grasp the overall structure and navigate the information within the workbook.

Several React Spreadsheet controls offer support for tabs including:

  • Telerik Spreadsheet React (part of KendoReact) enables users to effortlessly navigate between spreadsheets through designated tabs.
  • SpreadJS by MESCIUS empowers developers with tabbed navigation for efficient data organization within their React applications.
  • Infragistics Spreadsheet React enables users to effortlessly navigate between spreadsheets through designated tabs.
  • Syncfusion Spreadsheet JavaScript provides tab-based navigation for a familiar and user-friendly experience when working with multiple sheets.

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

Compare React Spreadsheet Controls