Spreadsheetsのニュース

JavaScriptスプレッドシートでデータを検索して置換

4月 29, 2025
スプレッドシートWebアプリケーションに柔軟で高度な検索および置換機能を装備し、コンテンツの更新プロセスを簡素化

Find and replace functionality in a spreadsheet application enables users to quickly search for specific text, numbers, or characters within a worksheet and substitute them with alternative content. Often including advanced options such as case sensitivity, regular expressions, and the ability to target specific sheets or cell ranges, this feature lets users make consistent updates across large datasets without manually editing each cell. By automating these repetitive tasks, it reduces the risk of human error and significantly enhances productivity and accuracy in data processing. It is particularly useful for correcting errors, updating outdated information, or standardizing entries, such as changing all instances of an old product name to a new one.

Several JavaScript spreadsheet controls offer find and replace functionality, including:

  • SpreadJS by MESCIUS equips JavaScript developers with the ability to perform search and replace operations via a dialog, supporting advanced options like case matching.
  • Jspreadsheet Pro is a data grid with spreadsheet controls, providing JavaScript applications with find and replace functionality via an advanced search and replace extension.
  • Syncfusion Spreadsheet JavaScript (part of Syncfusion Essential Studio Enterprise) facilitates flexible find and replace capabilities to simplify targeted editing.

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

Compare JavaScript Spreadsheet Controls

セル内ピクチャーでデータ可視化を改善

4月 16, 2025
EPPlus v8.0.1では、画像をセルに直接挿入する機能が追加され、ローカル画像とWeb画像の使用が容易になり、スプレッドシートがより魅力的に

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.

​The EPPlus v8.0.1 update enhances the visualization of spreadsheet data by introducing the ability to insert images directly into individual worksheet cells. This feature is particularly beneficial for creating more informative and engaging spreadsheets, such as including product images in inventory lists or embedding charts alongside relevant data. The new functionality supports various image formats, such as PNG, JPG and GIF, and integrates with the IMAGE function, so you can add local images as well as download images from the web via URLs.

To see a full list of what's new in v8.0.1, 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.

ウォーターフォール図で累積影響を視覚化

4月 14, 2025
Pine BI Excel Add-In v2.0は、動的な積み上げウォーターフォール図を追加し、直感的で比較可能なビジュアルでExcelベースの分析を強化

The Pine BI Excel Add-In facilitates the rapid generation of sophisticated and interactive Excel charts, enabling the transformation of standard workbooks into engaging dashboards that improve data visualization. These easily shareable visuals can also be seamlessly integrated into Microsoft Word and PowerPoint, streamlining data analysis workflows and enhancing the creation of impactful reports and presentations across various business applications.

The Pine BI Excel Add-In v2.0 update adds functionality to generate stacked waterfall charts directly within the Excel environment, providing developers with a programmatic and user-friendly method to visualize sequential data contributions to a final value. This embedded feature eliminates the need for external charting libraries or manual data manipulation, streamlining the process of creating insightful visualizations for financial analysis, performance monitoring, and comparative reporting within their Excel-based applications and solutions. Developers can leverage this capability to enhance data presentation and user understanding without requiring specialized charting expertise or reliance on separate tools.

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

Pine BI Excel Add-In is licensed annually on a subscription basis with 1, 5, and 10 seat options, requiring renewal for continued use and covering each concurrent computer, with the ability to transfer individual seat activation's as needed. See our Pine BI Excel Add-In licensing page for full details.

For more information, explore the Pine BI Excel Add-In product range.

スプレッドシートの並べ替えでデータの明瞭さが向上

4月 11, 2025
ユーザーがカスタム条件で大規模なデータセットを整理し、読みやすさ、使いやすさ、意思決定の効率を向上させるのに役立つVue.jsアプリを作成

Data sorting in a spreadsheet control is a fundamental feature that enables users to rearrange data within a grid or table based on specific criteria, typically ascending or descending alphabetically or by numerical value. Sorting will usually be performed on single or multiple columns and is often integrated with other data manipulation tools like filtering, grouping, and searching. By sorting data, users can quickly locate and analyze information, identify patterns, and ensure consistency across records. Especially useful in large datasets, it improves the readability of the information and makes it more organized in preparation for decision-making, reporting, and data validation. This capability facilitates efficient data analysis, and supports better user interaction by allowing datasets to be viewed in meaningful sequences.

Several Vue.js spreadsheet controls allow you to sort data, including:

  • SpreadJS by MESCIUS can equip Vue.js spreadsheet applications with data sorting capabilities, including grouped and custom sorting for improved analysis and presentation.
  • Jspreadsheet Pro integrates with Vue.js and provides developers with flexible sorting features, allowing users to organize tables quickly in web-based spreadsheet interfaces.
  • Syncfusion Spreadsheet JavaScript (part of Syncfusion Essential Studio Enterprise) lets you sort data, e.g. via custom sort order and multi-column sorting.

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

Compare Vue.js Spreadsheet Controls

WPF Excel XLSXビューアをデスクトップアプリに追加

4月 8, 2025
MESCIUSのSpread.NETを使用して、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. 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 demonstrates how to use Spread.NET to enable your WPF application to display or interact with Excel files using a dedicated viewer. She'll walk through how to add an Excel XLSX viewer to a WPF app using the WPF spreadsheet control, Spread.NET for WPF. You'll learn how to load a .xlsx file, lock down the worksheet, and allow users to edit only specific cells — perfect for budget forms, reports, or review-only sheets. Once you have created a WPF project, the steps are as follows:

  • Define the User Interface for the WPF Spreadsheet app
  • Import Excel (.xlsx) Files into the WPF App Excel Viewer
  • Protect the .NET Worksheet in the WPF Excel Viewer

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

Read the full blog post to learn how to add this versatile capability to 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.