Spreadsheets News

Maintain Image Integrity in Spreadsheet Exports

May 1, 2025
Syncfusion Essential Studio WinUI 2025 Volume 1 improves Excel-to-PDF conversion by preserving EMF+ and EMF Dual images exactly as designed.

Syncfusion Essential Studio WinUI (available as part of Syncfusion Essential Studio Enterprise) is a comprehensive toolkit for building high performance native Windows desktop applications. It offers tools for crafting modern UI elements like charts, data grids, and ribbon interfaces, alongside powerful editing tools for Word, Excel, and PDF documents.

The Syncfusion Essential Studio WinUI 2025 Volume 1 release improves the Excel Library by adding the ability to accurately preserve EMF+ (Enhanced Metafile Format Plus) and EMF Dual images during Excel-to-PDF and image conversion processes. This improvement ensures that vector-based images maintain their clarity and quality in the resulting PDFs, which is particularly beneficial for producing professional documentation such as manuals and reports. By retaining the integrity of these images, developers can deliver high-quality outputs that effectively communicate complex information through detailed visuals.

To see a full list of what's new in 2025 Volume 1, see our release notes.

Syncfusion Essential Studio WinUI is available as part of Syncfusion Essential Studio Enterprise which is licensed per developer starting with a Team License of up to five developers. It is available as a 12 Month Timed Subscription License which includes support and maintenance. See our Syncfusion Essential Studio Enterprise licensing page for full details.

Learn more on our Syncfusion Essential Studio WinUI product page.

Locate and Replace Data in JavaScript Spreadsheets

April 29, 2025
Equip spreadsheet web applications with flexible and advanced find and replace functionality, simplifying the process of updating content.

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

Improve Data Visualization with In-Cell Pictures

April 16, 2025
EPPlus v8.0.1 adds the ability to insert images directly into cells, facilitating the use of local and web images to make spreadsheets more engaging.

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.

Visualize Cumulative Impact with Waterfall Charts

April 14, 2025
Pine BI Excel Add-In v2.0 adds dynamic stacked waterfall charts, enhancing Excel-based analysis with intuitive, comparative visuals.

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.

Enhance Data Clarity with Spreadsheet Sorting

April 11, 2025
Create Vue.js apps that help users organize large datasets by custom criteria, boosting readability, usability and decision-making efficiency.

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