Neuigkeiten zu Spreadsheets

Importieren und Exportieren von CSV-Dateien mit WinForms

Februar 4, 2025

Nutzen Sie die Spread.NET von MESCIUS, um Ihre WinForms-Projekte mit integrierten Import- und Exportfunktionen für Excel-Tabellenkalkulationen in C# oder VB zu verbessern.

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 guides you through the four essential steps to import and export Excel spreadsheets on your way to creating robust .NET WinForms spreadsheet applications with Spread.NET. These steps include:

Configure a .NET WinForms Spreadsheet Application
Import a CSV File into a .NET Spreadsheet
Convert a CSV File into an Excel XLSX File using C# or VB.NET
Export a .NET Spreadsheet Instance to a CSV File
Handle CSV Files with a UI Spreadsheet Ribbon Toolbar

Sample code is included in the blog and you can download the sample app in either C# or VB.

Read the full blog post to discover how to use the full capabilities of the Spread.NET WinForms component.

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.

Verbessern Sie die Einblicke in Tabellenkalkulationen mit Sparklines

Januar 23, 2025

Sparkline-Diagramme bieten prägnante Visualisierungen in der Zelle und erleichtern das Erkennen von Trends und Mustern, ohne dass Diagramme in Originalgröße erforderlich sind.

Sparklines are compact, embedded charts that provide a visual representation of data trends within individual spreadsheet cells. Unlike traditional charts, they do not require a separate charting area, making them ideal for summarizing data patterns, such as sales performance, stock trends, or operational metrics, in a space-efficient manner. These microcharts enhance readability and decision-making by offering a quick, at-a-glance view of trends without overwhelming users with excessive detail.

Several ASP.NET Core spreadsheet controls offer sparkline functionality including:

DevExpress ASP.NET Core Spreadsheet (part of DevExpress ASP.NET and Blazor) supports line, column, and win/loss sparklines for easy integration into web applications.
Aspose.Cells for .NET provides extensive sparkline customization options, enabling precise control over styles, colors, and axis settings to enhance data presentation.
Document Solutions for Excel, .NET Edition by MESCIUS includes comprehensive sparkline support with Excel compatibility and programmatic creation.
Infragistics ASP.NET Core Spreadsheet (part of Infragistics Ignite UI) supports sparklines, enabling users to embed lightweight visualizations directly within spreadsheet cells.

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

Compare ASP.NET Core Spreadsheet Controls

Bereichern von Tabellenkalkulationsdaten mit Bildintegration

Januar 8, 2025

Das Einbetten von Bildern verbessert die Visualisierung von Tabellenkalkulationsdaten und bietet klare Einblicke und einen umfassenden Kontext für die Entscheidungsfindung.

Image support within a spreadsheet component allows developers to seamlessly integrate and manipulate images directly within the spreadsheet environment, enabling features such as inserting, resizing, positioning, and formatting images within cells or as background elements. By embedding images alongside numerical or textual data, users can enhance data visualization, streamline report generation, and provide richer context for decision-making, ultimately improving communication and enabling more effective data analysis within applications.

Several WinForms spreadsheet components support inserting images, including:

DevExpress WinForms Spreadsheet (part of DevExpress WinForms) seamlessly integrates and manipulates images directly within your spreadsheets.
Spread.NET WinForms (part of Spread.NET by MESCIUS) enhances the visual impact of your spreadsheets with the ability to insert, resize and format images alongside your data.
Telerik WinForms Spreadsheet (part of Telerik UI for WinForms) adds a new dimension to your data analysis by embedding images within your spreadsheets.
MindFusion.Spreadsheet for WinForms by MindFusion Group allows you to use images to create a clear and informative vision of your spreadsheet data.

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

Compare WinForms Spreadsheet Controls

Vereinfachen von Formeln mittels einer Automatisierung des Auslaufbereichs

Januar 7, 2025

DevExpress Office File API integriert eine Unterstützung für den Überlaufbereich, optimiert Tabellenkalkulations-Workflows und verbessert die Effizienz der Datenbearbeitung.

The DevExpress Office File API is a robust library designed to simplify the creation, editing, and processing of popular office document formats, including Word, Excel, PowerPoint, and PDF. It allows developers to integrate advanced document management features into their applications without relying on external software like Microsoft Office. Key features include document generation, data import/export, template customization, and seamless integration with modern platforms. The API supports advanced formatting, encryption, and digital signatures, ensuring secure and professional-grade output. Ideal for enterprise applications, it streamlines workflows for reporting, data analysis, and document automation, saving time and enhancing productivity for developers and end-users alike.

The DevExpress Office File API v24.2 update introduces support for dynamic array formulas, enabling developers to enhance spreadsheet functionality with automated formula calculations that dynamically spill into adjacent cells. This update simplifies data manipulation by allowing efficient recalculations, importing, and exporting of Excel documents with dynamic array formulas. Developers gain precise control through APIs that manage dynamic array formulas programmatically, identify spill ranges, and customize behavior to suit specific application needs. This capability not only streamlines complex data workflows but also ensures seamless compatibility with modern Excel features, offering greater flexibility and efficiency in application development.

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

DevExpress Office File API is licensed per developer and is available as a Perpetual License with a 12 month support and maintenance subscription. See our DevExpress Office File API licensing page for full details.

DevExpress Office File API is available individually or in the following products:

Verbessern der Tabellenkalkulationen mit KI-gestützten Analysen

Dezember 23, 2024

Mit dem Pine AI Cell Analysis-Tool können Sie Daten in Ihrer Arbeitsmappe analysieren, eine Anfrage eingeben und die Ergebnisse direkt in den Zellen anzeigen.

Pine AI Excel Add-In, developed by Pinexl, integrates OpenAI's ChatGPT into Microsoft Excel, enabling users to generate, debug, and interpret complex formulas and Visual Basic for Applications (VBA) code by simply describing their requirements. This tool enhances productivity by automating tasks such as data analysis, summarization, transformation, and translation directly within Excel spreadsheets. For instance, users can extract specific information from unstructured data, fill in missing details like country names based on city data, and translate text without leaving the Excel environment. By streamlining these processes, Pine AI reduces the time spent on manual data manipulation and extensive online research, making it a valuable asset for professionals seeking to optimize their workflow within Excel.

Pine AI's data analysis functionality has been separated into two tools; Range Analysis and Cell Analysis. The Range Analysis tool is the data analysis function of the preceding Data Analysis tool, allowing you to evaluate and summarize a range of cells. The Pine AI Cell Analysis tool allows you to analyze individual cells, make requests on that data, and have the findings returned directly to another cell in the same or a new worksheet within your current active workbook. Use Pine AI Cell Analysis to extract strings from text, obtain additional information based on cell values, and even translate cell content into any language.

Pine AI Excel Add-In is licensed per user on an annual subscription basis. To continue using the software you will need an active subscription. See our Pine AI Excel Add-In licensing page for full details.

Learn more on our Pine AI Excel Add-In product page.