Spreadsheetsのニュース

スプレッドシートのセルに画像を簡単に埋め込み

3月 4, 2025
DevExpress Office File API v24.2では、画像をワークシートセルに直接埋め込むことができるため、Excelとのシームレスな統合が可能

The DevExpress Office File API is a robust library designed to simplify the creation, editing, and processing of popular office document formats, including Word, Excel, PowerPoint, and PDF. It allows developers to integrate advanced document management features into their applications without relying on external software like Microsoft Office. Key features include document generation, data import/export, template customization, and seamless integration with modern platforms. The API supports advanced formatting, encryption, and digital signatures, ensuring secure and professional-grade output. Ideal for enterprise applications, it streamlines workflows for reporting, data analysis, and document automation, saving time and enhancing productivity for developers and end-users alike.

The DevExpress Office File API v24.2 update introduces the ability to embed images directly into worksheet cells, giving users enhanced control over spreadsheet design and functionality. This feature integrates with Microsoft Excel's "Place in Cell" option, allowing documents with embedded images to be imported, exported, printed, and saved without content loss. Supported programmatically through new APIs, it enables users to insert, retrieve, and manage images as cell values while accessing properties like format and bytes. This update simplifies the creation of Excel-compatible spreadsheets for modern applications.

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

DevExpress Office File API is licensed per developer and is available as a Perpetual License with a 12 month support and maintenance subscription. See our DevExpress Office File API licensing page for full details.

DevExpress Office File API is available individually or as part of DevExpress Universal.

SharePoint統合で一括更新を効率化

2月 27, 2025
KWIZ Datasheet Viewは、SharePointの直感的なExcelのような編集エクスペリエンスを提供し、シームレスな一括更新と生産性の向上を可能に

KWIZ has introduced KWIZ Datasheet View, a new product designed to streamline the way users interact with structured data in a collaborative environment. It brings an Excel-like editing experience to SharePoint, enabling fast bulk updates for modern and classic lists. It integrates seamlessly with SharePoint, adding a toolbar button for easy access and supporting Chrome, Edge, and Internet Explorer. With an option to auto-open lists in Datasheet mode, it streamlines data management for teams handling large datasets, inventory, or projects, enhancing efficiency and productivity.

KWIZ Datasheet View enhances SharePoint integration by providing a seamless, Excel-like bulk editing experience directly within SharePoint lists and libraries. This integration ensures compatibility with both modern and classic lists, allowing developers to maintain a consistent user experience across different SharePoint environments without additional configuration. By embedding directly into the SharePoint interface, it eliminates the need for external tools or complex workarounds, improving data management efficiency. The integration also supports multiple browsers, ensuring accessibility across different platforms. Developers can leverage this functionality to optimize workflows, streamline bulk data updates, and enhance usability for end users working with large datasets in SharePoint.

KWIZ Datasheet View is licensed on an annual basis, requiring each user in your organization to be covered by an Annual Subscription license. Different levels are available to cater for different numbers of users. See our KWIZ Datasheet View licensing page for full details.

For more information, visit our KWIZ Datasheet View product page.

EPPlus SoftwareがMicrosoft .NET 9のサポートを追加

2月 25, 2025
EPPlus v7.6.0アップデートでは、.NET 9との互換性が導入され、開発者は最新の拡張機能にすぐにアクセス可能

EPPlus is a powerful and versatile .NET library for managing and manipulating Microsoft Excel files using the Office Open XML (OOXML) format. It is a lightweight and efficient library that is easy to use and can be integrated into a wide range of applications. It allows developers to create, read and modify spreadsheets without dependencies on any other library. Features include pivot tables, styling, VBA/Form controls, conditional formatting, charts, tables, formula calculation, data validation, pictures/shapes, and more.

EPPlus v7.6.0 update introduces full support for .NET 9, ensuring compatibility with the latest framework advancements while enhancing performance, security, and long-term maintainability for spreadsheet processing in .NET applications. This update benefits developers by enabling seamless integration with modern .NET projects, improving efficiency in generating, reading, and manipulating Excel files. Ideal for enterprise applications, data analytics, and financial reporting, EPPlus with .NET 9 support ensures optimized performance and future-proofed development for handling large datasets and complex spreadsheet operations.

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

EPPlus is licensed per developer and is available as both perpetual licenses and subscription based licenses with periods of 1 year and 2 years, which include support and upgrades. See our EPPlus licensing page for full details.

For more information, see our EPPlus product page.

行の挿入によるデータの容易な拡張

2月 24, 2025
スプレッドシートコンポーネントに行を挿入すると、ユーザーはデータをシームレスに変更および拡張でき、動的なコンテンツ更新の柔軟性を確保可能

Inserting rows in spreadsheet components is a fundamental feature that allows users to dynamically expand their data sets while maintaining structure and organization. This capability is essential for applications that handle tabular data, enabling seamless modifications without disrupting existing content. Whether used for financial calculations, data analysis, or collaborative editing, the ability to add rows programmatically or through user interaction enhances flexibility and efficiency in spreadsheet-based applications.

Several React spreadsheet controls offer support for inserting rows including:

  • Wijmo FlexSheet (part of Wijmo by MESCIUS) provides built-in methods for inserting rows both through the UI and programmatically using its API.
  • Telerik Spreadsheet React (part of KendoReact by Telerik) enables users to insert rows dynamically while preserving formulas and formatting, ensuring data integrity.
  • Syncfusion Spreadsheet JavaScript (part of Syncfusion Essential Studio Enterprise) offers row insertion with support for undo/redo functionality for improved users control.
  • Infragistics Spreadsheet React (part of Infragistics Ignite UI) allows users to add rows via user commands or API calls, integrating with other spreadsheet operations.

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

Compare React Spreadsheet Controls

Blazorを使用したExcel XLSXをインポート/エクスポート

2月 18, 2025
MESCIUSのSpreadJSを使用すると、BlazorアプリケーションでExcelファイルをインポートおよびエクスポートして、強力なスプレッドシート機能をWebに導入可能

SpreadJS by MESCIUS is a high-performance JavaScript spreadsheet component designed to seamlessly integrate Excel-like functionality into web applications. It empowers developers to deliver robust spreadsheet experiences within their applications, complete with features like data import/export, complex formulas, conditional formatting, and extensive customization options. SpreadJS caters to a wide range of use cases, from financial modeling and data analysis to project management and interactive dashboards, ultimately allowing developers to build feature-rich and user-friendly web applications.

In this blog post, MESCIUS Product Manager Kevin Ashley shows you how to use the powerful and extensible SpreadJS component to import and export Excel files. Steps include:

  • Creating the Blazor Application
  • Creating the SpreadJS Component
  • Adding SpreadJS Excel Import and Export
  • Adding the SpreadJS component to Home Page

Detailed source code is included and you can also download the sample app.

Read the full blog to get starting working directly with Excel files in your Blazor applications.

SpreadJS is licensed per developer and includes 1 Year Maintenance (major and minor version releases and unlimited support phone calls). SpreadJS requires an Annual or Perpetual Deployment License. The optional Add-ons are available at an additional cost, and require a SpreadJS license. See our SpreadJS licensing page for full details.

For more information, visit our SpreadJS product page.