Spreadsheets 新聞

用 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.

按需無縫插入試算表列

2月 11, 2025
讓使用者能夠即時添加列，從而將靜態試算表轉換為適應不斷變化的資料需求的動態工具。

The option to insert columns in a spreadsheet gives users the flexibility to expand or reorganize their data as needed. This functionality allows for seamless adjustments, making it easier to add new data fields or restructure existing information. By enabling column insertion, users can customize their data views for more effective analysis and manipulation. This not only enhances productivity but also delivers a more responsive and adaptable interface that evolves with their data requirements, improving the overall user experience.

Several Angular spreadsheet controls offer the ability to insert columns including:

  • SpreadJS by MESCIUS empowers users to dynamically insert columns, enhancing data visualization and manipulation within their Angular applications.
  • Jspreadsheet Pro facilitates seamless column insertion, enabling flexible data organization and adaptation to evolving needs in Angular spreadsheets.
  • Syncfusion Spreadsheet JavaScript (part of Syncfusion Essential Studio Enterprise) allows dynamic column insertion, providing a robust solution for building interactive apps.

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

Compare Angular Spreadsheet Controls