Neuigkeiten zu Spreadsheets

Ermöglichen Sie Benutzern das einfache Wechseln zwischen Arbeitsblättern

Juli 8, 2024
Registerkarten ermöglichen es Benutzern von Tabellenkalkulationen, schnell zwischen Datensätzen zu wechseln, und eine klare visuelle Unterscheidung zwischen mehreren Datenabschnitten zu bieten.

Worksheet tabs act as a visual and interactive index, enabling users to seamlessly navigate between distinct sections within a single workbook. This efficient organization facilitates data comparison and analysis. The clear visual distinction between tabs reduces cognitive load and enhances comprehension, making it easier for users to grasp the overall structure and navigate the information within the workbook.

Several React Spreadsheet controls offer support for tabs including:

  • Telerik Spreadsheet React (part of KendoReact) enables users to effortlessly navigate between spreadsheets through designated tabs.
  • SpreadJS by MESCIUS empowers developers with tabbed navigation for efficient data organization within their React applications.
  • Infragistics Spreadsheet React enables users to effortlessly navigate between spreadsheets through designated tabs.
  • Syncfusion Spreadsheet JavaScript provides tab-based navigation for a familiar and user-friendly experience when working with multiple sheets.

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

Compare React Spreadsheet Controls

Bewahren Sie die Reaktionsfähigkeit der Tabellenkalkulationen während der Berechnungen

Juli 3, 2024
SpreadJS 17.1.0 integriert inkrementelle Berechnungen, die dazu beitragen, die Leistung der Tabellenkalkulation selbst bei der komplexesten Datenverarbeitung aufrechtzuerhalten.

SpreadJS by MESCIUS is a JavaScript library offering a comprehensive spreadsheet solution for enterprise web applications. It delivers an Excel-like user experience with features like data tables, extensive charting, formatting options, and a powerful formula engine supporting over 500 functions. SpreadJS integrates with popular frameworks like React, Angular, and Vue.js, enabling developers to build high-performance, customizable spreadsheet functionalities within their web applications.

The SpreadJS v17.1 release enables incremental computation, which breaks down the entire calculation into pieces during execution. This enables responsiveness to user actions when the calculation task is large, preventing the UI from being unresponsive when a workbook has many formulas. Developers will only need to set the incrementalCalculation attribute of the Workbook class to true. This computation procedure is also displayed in the status bar.

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

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.

Learn more on our SpreadJS product page.

Berechnen von Pivot-Tabellen in .NET-Tabellenkalkulations-Apps

Juli 2, 2024
EPPlus v7.2.0 integriert die Unterstützung für das Berechnen und Abrufen von Daten aus Pivot-Tabellen, sodass .NET-Entwickler diese direkt in ihrem Programm erstellen können.

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 v7.2.0 update adds support for calculating and fetching data from pivot tables, allowing .NET developers to enhance the data analysis capabilities of their applications. This feature allows developers to dynamically summarize, analyze, and present large datasets by creating and manipulating pivot tables programmatically. It includes the ability to define calculations (sum, average, etc.) for rows and columns, format values as percentages or differences, and apply various filters (captions, numbers, dates, etc.) and sorting options. This streamlines data analysis workflows and fosters greater control over the final spreadsheet output, empowering developers to deliver more powerful data-driven solutions.

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

Hervorheben von Erkenntnissen mit bedingter Formatierung

Juni 19, 2024
ASP.NET Core-Tabellenkalkulationssteuerelemente mit der Unterstützung für die bedingte Formatierung erleichtern die Analyse von Daten, kritischen Problemen, Mustern und Trends.

Conditional formatting in a spreadsheet component allows you to dynamically alter the visual appearance of cells based on predefined rules. This functionality enhances data readability by highlighting specific values or trends within your spreadsheet. By visually differentiating critical information, conditional formatting empowers developers to create more user-friendly and informative data presentations within their ASP.NET applications.

Several ASP.NET Core Assembly Spreadsheet Controls offer Conditional Formatting including:

  • DevExpress ASP.NET Core Spreadsheet (part of DevExpress for ASP.NET) integrates conditional formatting for visually distinct data.
  • Telerik Spread Processing (part of Telerik UI for ASP.NET Core) provides developers with programmatic control of conditional formatting for tailored user experiences.
  • IronXL by Iron Software simplifies data interpretation with conditional formatting features that elevate spreadsheet clarity.
  • Infragistics ASP.NET Core Spreadsheet (part of Infragistics Ignite UI) integrates user-defined conditional formatting rules to enhance data readability in web applications.

For an in-depth analysis of features and price, visit our comparison of ASP.NET Core Assembly Spreadsheet Controls.

Compare ASP.NET Core Assembly Spreadsheet Controls

Integrieren Sie Excel-Funktionen in Python-Projekte

Juni 18, 2024
IronXL für Python über .NET ist eine Excel-Bibliothek, die es Python-Entwicklern ermöglicht, Tabellenkalkulationsfunktionen in ihre Anwendungen zu integrieren.

IronXL for Python via .NET by Iron Software is a Python Excel library designed to enable Python developers to manipulate, read and generate Microsoft Excel files easily by leveraging the .NET framework. It allows them to integrate Excel functionality into Python applications without requiring Microsoft Office or Excel Interop to be installed on the server or client machines. This standalone solution provides a comprehensive API for reading, creating, and editing Excel files (XLS, XLSX, XLSM, CSV, TSV, etc.) directly from Python code.

IronXL offers a compelling alternative for developers seeking an efficient and versatile solution for spreadsheet manipulation in Python environments. It facilitates the automation of report generation, data analysis, and financial modeling, all within a familiar Excel format but executed through Python scripts. It simplifies complex tasks like data import/export, formatting control, and chart generation, making it ideal for automating spreadsheet-related workflows across various industries, from data analysis and reporting to financial modeling and content generation. The use cases for IronXL span various industries including finance, research, education, and healthcare, where users need to merge, split, and export data while maintaining the integrity and formatting of their spreadsheets.

IronXL for Python via .NET is licensed based on the number of developers, organization locations and projects, and is available as a perpetual license with one free year of product updates and support services. See our IronXL for Python via .NET licensing page for full details.

For more information, see our IronXL for Python via .NET product page.