Neuigkeiten zu Spreadsheets

Suchen und Ersetzen von Daten in JavaScript-Tabellen

April 29, 2025
Statten Sie Webanwendungen für Tabellenkalkulationen mit flexiblen und fortschrittlichen Funktionen zum Suchen und Ersetzen aus und vereinfachen Sie so das Aktualisieren von Inhalten.

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

Verbessern Sie die Datenvisualisierung mit In-Cell-Bildern

April 16, 2025
EPPlus v8.0.1 bietet die Möglichkeit, Bilder direkt in Zellen einzufügen, was die Verwendung von lokalen und Web-Bildern erleichtert, um Tabellenkalkulationen ansprechender zu gestalten.

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.

Visualisieren Sie die kumulative Wirkung mit Wasserfalldiagrammen

April 14, 2025
Pine BI Excel Add-In v2.0 integriert dynamisch gestapelte Wasserfalldiagramme hinzu verbessert die Excel-basierte Analyse mit intuitiven, vergleichenden Visualisierungen.

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.

Verbessern Sie die Datenklarheit mit der Sortierung von Tabellenkalkulationen

April 11, 2025
Erstellen Sie Vue.js Apps, mit denen Benutzer große Datensätze nach benutzerdefinierten Kriterien organisieren können, um die Lesbarkeit, Benutzerfreundlichkeit und Effizienz der Entscheidungsfindung zu verbessern.

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

Integrieren eines WPF Excel XLSX-Viewers in Ihre Desktop-App

April 8, 2025
Verwenden Sie Spread.NET von MESCIUS, um Excel-Dateien programmgesteuert zu importieren, Arbeitsblätter anzupassen und Änderungen durch Endbenutzer zu verhindern.

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.