Spreadsheets 뉴스

JavaScript 스프레드시트에서 데이터 찾기 및 바꾸기

4월 29, 2025
스프레드시트 웹 애플리케이션에 유연한 '찾기 및 바꾸기' 고급 기능을 제공하여 콘텐츠 업데이트 프로세스를 간소화합니다.

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에서는 이미지를 셀에 직접 삽입하는 기능이 추가되어, 로컬 이미지와 웹 이미지를 활용하여 스프레드시트를 더욱 매력적으로 만들 수 있습니다.

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에서는 동적인 누적 폭포 차트(stacked waterfall chart)가 추가되어, 직관적이고 비교하기 쉬운 비주얼을 통해 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.