Neuigkeiten zu Spreadsheets

Präzise Platzierung von Zellbildern für eine ausgefeilte Präsentation

September 26, 2024
Spread.NET v17.2 ermöglicht es Benutzern, die Bildplatzierung in Zellen anzupassen, zu füllen oder anzupassen, was Flexibilität und Präzision bei der Anzeige von Tabellenkalkulationen bietet.

Spread.NET by MESCIUS is a powerful tool for building Excel-like applications in your .NET projects. It lets you create interactive spreadsheets, grids, dashboards, and even forms within WinForms, ASP.NET, and WPF applications. With its rich feature set, including a robust calculation engine, formula support, and Excel compatibility, Spread.NET empowers developers to build data analysis tools, budgeting apps, scientific dashboards, and more, all within the familiar .NET environment.

The Spread.NET v17.2 release introduces greater cell image versatility and customization. With four new distinct sizing options—Fit, Fill, Original, and Custom—users gain precise control over how images are displayed within cells. The Fit mode maintains the image's aspect ratio while ensuring it fits within the cell, preventing distortion. The Fill option covers the entire cell, disregarding the aspect ratio for full coverage. Original preserves the image's natural size, even if it exceeds the cell's dimensions, while Custom allows users to set specific height and width parameters. These flexible sizing options enhance the presentation of images, offering tailored solutions to fit various content needs, whether it’s for data visualization, design, or reporting purposes. This feature significantly improves visual control, ensuring consistency and a professional appearance across documents.

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

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.

Integrieren Sie Diagramme in JavaScript-Tabellenkalkulations-Apps

September 24, 2024
Verwenden Sie JavaScript-Steuerelemente für Tabellenkalkulationen mit integrierter Diagrammfunktion, um Daten auf visuell ansprechende Weise zu analysieren und darzustellen.

JavaScript spreadsheet controls with built-in chart features enable developers to visualize data directly within web-based spreadsheet applications. These charts are generated dynamically from the data within the spreadsheet, providing users with a more intuitive way to analyze and interpret complex datasets. By integrating charting capabilities, developers can offer real-time data visualization without relying on external libraries, resulting in more efficient user experiences. This functionality improves data-driven decision-making, enhances user engagement, and reduces the complexity of handling complex datasets in web applications.

Several JavaScript spreadsheet controls offer charts including:

  • SpreadJS by MESCIUS allows you to seamlessly integrate dynamic charts into spreadsheets, enabling advanced data visualization and analysis.
  • Jspreadsheet Pro lets you create interactive charts within your spreadsheet, simplifying data insights and enhancing user interaction.
  • Infragistics Spreadsheet React (part of Ignite UI by Infragistics) facilitates real-time chart generation directly from spreadsheet data for improved decision-making.
  • Syncfusion Spreadsheet JavaScript (part of Syncfusion Essential Studio Enterprise Edition) enables embedded charting to visualize spreadsheet data with minimal coding.

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

Compare JavaScript Spreadsheet controls

Verbessern Sie die Datenanalyse von Tabellenkalkulationen in .NET-Anwendungen

September 5, 2024
EPPlus v7.3.0 integriert neue Funktionen, um komplexere statistische und mathematische Operationen zu ermöglichen und die Möglichkeiten zur Formelberechnung zu verbessern.

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.3.0 update introduces four new functions that are supported in formula calculations, enhancing the library's capability for data analysis within Microsoft Excel spreadsheets. The GROWTH function enables exponential growth calculations, while DPRODUCT allows the multiplication of values in a field of a list or database based on specified criteria. The DSTDEV and DSTDEVP functions calculate the standard deviation of values in a field within a list or database, but they differ in their scope. DSTDEV is for samples, while DSTDEVP is used for entire populations. These functions allow developers to perform more complex statistical and mathematical operations directly within spreadsheet documents, significantly improving the efficiency of data-driven applications.

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

Visualisieren Sie Ihre Daten mit der Unterstützung von Zellenbildern

September 2, 2024
Verbessern Sie Ihre React-Tabellenkalkulationen mit der Möglichkeit, Bilder zu integrieren, die Datenklarheit zu verbessern und visuell ansprechende Präsentationen zu erstellen.

Cell image support refers to the capability of a spreadsheet component to incorporate and manipulate images directly within individual cells. This feature allows developers to visually represent data, such as charts, diagrams, or photographs, within the spreadsheet interface. By integrating images into cells, developers can enhance the overall effectiveness of their spreadsheet-based applications  as well as making them more engaging for users, facilitating data visualization and analysis.

Several React spreadsheet controls offer support for cell images, including:

  • SpreadJS by MESCIUS lets you seamlessly embed images into cells, enabling React developers to enhance visual data representation in their applications.
  • Jspreadsheet Pro provides seamless image insertion and manipulation functionality within cells for creating dynamic spreadsheets in React.
  • Syncfusion Spreadsheet JavaScript (part of Syncfusion Essential Studio Enterprise) facilitates the integration of images into cells, providing a rich and interactive experience.

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

Compare React Spreadsheet Controls

Vereinfachen Sie die Verarbeitung von Tabellenkalkulationen mit der API Node.js

September 2, 2024
Aspose.Cells for Node.js via C++ ermöglicht es Entwicklern, die Bearbeitung und Konvertierung von Tabellenkalkulationen in ihre Node.js-Apps zu integrieren.

Aspose.Cells for Node.js via C++ is a powerful and comprehensive API that enables developers to work with Microsoft Excel files within Node.js applications, leveraging the robust capabilities of C++. This product allows for the creation, manipulation, conversion, and rendering of Excel spreadsheets, all without requiring Microsoft Excel to be installed. With support for a wide range of Excel file formats, including XLS, XLSX, CSV, and more, Aspose.Cells for Node.js via C++ provides developers with the flexibility to handle complex spreadsheet tasks in their applications efficiently.

The key benefits of Aspose.Cells for Node.js via C++ include its high performance, ease of integration, and extensive feature set. Developers can automate complex spreadsheet processing tasks, such as data analysis, formula calculations, and chart creation, directly within their Node.js applications. This makes it particularly useful for scenarios where server-side spreadsheet processing is needed, such as in web-based data analysis tools, reporting systems, and enterprise-level applications. By offloading heavy Excel processing tasks to Aspose.Cells, developers can significantly enhance the performance and scalability of their applications while maintaining full control over spreadsheet operations.

Aspose.Cells for Node.js via C++ is offered as Developer Small Business, Developer OEM, Developer SDK, Site Small Business, Site OEM, and Site SDK licenses catering to a range of business needs. Licenses are perpetual, and include 1 year of support and maintenance. Subscription renewals are also available. See our Aspose.Cells for Node.js via C++ licensing page for full details.

Aspose.Cells for Node.js via C++ is available in the following products: