Neuigkeiten zu Spreadsheets

Importieren und Exportieren von Excel-XLSX-Dateien in JavaScript

Dezember 5, 2023

Verwenden Sie SpreadJS von MESCIUS, um komplette JavaScript-Tabellenkalkulationen in Ihre Unternehmensanwendungen zu integrieren.

SpreadJS is a complete enterprise JavaScript spreadsheet solution used to create financial reports and dashboards, budgeting and forecasting models, scientific, engineering, healthcare, education, science lab notebooks, and other similar JavaScript business applications. Spreadsheets are a primary medium for displaying and sharing vital company data and it is crucial that this data can be easily viewed and updated in your JavaScript applications.

In this blog post, MESCIUS Product Manager Kevin Ashley shows you how to leverage the power of SpreadJS to import and export Excel spreadsheets into your enterprise web applications. Steps include:

Setting up the JavaScript Spreadsheet Project
Adding Excel Import Code
Adding Data to the Imported Excel File
Adding a Sparkline
Adding Excel Export Code

View the complete blog and start working directly with Excel files in your JavaScript applications.

For more information visit our SpreadJS product page.

Veranschaulichen Sie Daten, indem Sie Diagramme zu ASP.NET Core Tabellenkalkulationen hinzufügen

November 27, 2023

Visualisieren Sie die Daten und Trends Ihrer Tabellenkalkulation mit Diagrammen, um die Datenkommunikation zu verbessern und die Entscheidungsfindung zu verbessern.

Charts help to transform complex numerical spreadsheet data into easily understandable graphical representations. They make it easier to identify patterns, trends, and relationships within the data, enabling faster comprehension and identification of key insights. This visual approach enhances communication and promotes informed decision-making. Charts can be particularly useful for presentations and performance tracking, allowing for effective data sharing and dissemination of insights.

Several ASP.NET Core spreadsheet controls offer charting support including:

IronXL by Iron Software is a lightweight and easy-to-use library which can be used for creating charts in ASP.NET Core spreadsheets. It supports a broad selection of chart types, such as bar charts, line charts, pie charts, and scatter plots.
Document Solutions for Excel, .NET Edition by MESCIUS (formerly GrapeCity) is a comprehensive library for working with Excel files in ASP.NET Core applications. It includes a powerful charting module that supports a wide range of chart types and customization options.
Aspose.Cells for .NET is a mature and feature-rich library for creating charts in ASP.NET Core spreadsheets. It supports a variety of charts, including custom chart types.

Alternatively, many spreadsheet controls are available as part of multi-function suites:

DevExpress ASP.NET Core Spreadsheet (part of DevExpress ASP.NET and Blazor) is a popular and well-supported spreadsheet component which supports adding charts. It offers a user-friendly interface and supports a comprehensive range of chart types and extensive customization possibilities.
Infragistics ASP.NET Core Spreadsheet (part of Infragistics Ignite UI) is a powerful and versatile library which allows you to create charts in ASP.NET Core spreadsheets. It provides an extensive library of chart types and granular customization controls for crafting personalized charts.
Syncfusion ASP.NET Core Spreadsheet (part of Syncfusion Essential Studio Enterprise) is a high-performance ASP.NET Core component which lets you create charts in spreadsheets. It includes a rich collection of chart types and versatile customization options for tailoring charts to your audience and data.

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

Compare ASP.NET Core Spreadsheets

Sichern von Tabellenkalkulationen in ASP.NET Core-Apps

November 22, 2023

Helfen Sie Benutzern, vertrauliche Tabellenkalkulationsdaten vor unbefugtem Zugriff, Änderung oder Löschung zu schützen.

Spreadsheet security features safeguard sensitive data within a spreadsheet. This can include password protection for opening the spreadsheet, encrypting the data, and setting permissions that control who can view or edit specific cells, ranges, or sheets. In an environment where spreadsheets contain confidential or proprietary information, such security features are crucial for preventing unauthorized access and ensuring that data manipulation is restricted to authorized users.

Several ASP.NET Core spreadsheet components provide spreadsheet security including:

IronXL by Iron Software protects sensitive data using spreadsheet permissions and passwords.
Aspose.Cells for .NET provides robust security features to protect your spreadsheet data, including access control and data validation.
Telerik Spread Processing (part of Telerik UI for ASP.NET Core) offers comprehensive security mechanisms to safeguard your spreadsheet data, including worksheet protection.
Syncfusion ASP.NET Core Spreadsheet (part of Syncfusion Essential Studio Enterprise) ensures data integrity and confidentiality with advanced security measures including password encryption and workbook protection.

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

Compare ASP.NET Core Spreadsheet Components

Visualisieren von Daten durch Hinzufügen von Diagrammen zu WPF-Tabellenkalkulationen

November 20, 2023

Verwandeln Sie komplexe Daten mithilfe von .NET WPF-Tabellenkalkulationskomponenten in überzeugende Visualisierungen. Verbessern Sie Datenanalysen und Erkenntnisse mit interaktiven Diagrammen und Grafiken.

Charts are integral to spreadsheets, enabling users to transform data into visually compelling representations. These graphical formats, such as pie, line, bar, and area charts, effectively convey complex information by highlighting trends, patterns, and anomalies. Spreadsheet software with advanced charting capabilities empowers users to create dynamic charts that adapt seamlessly to data updates, making them invaluable tools for reporting, presentations, and data analysis.

Several .NET WPF spreadsheet components provide chart support including:

DevExpress WPF Spreadsheet (Part of DevExpress WPF) helps you visualize spreadsheet data effectively with a comprehensive collection of charts for WPF.
Infragistics WPF Spreadsheet (Part of Infragistics Ultimate UI for WPF) enhances WPF spreadsheet data analysis and insights with a wide range of customizable charts and graphs.
Spread.NET WPF by MESCIUS (formerly GrapeCity) creates impactful data visualizations with a variety of built-in charts for WPF spreadsheets.
Telerik WPF Spreadsheet (Part of Telerik UI for WPF) elevates data presentation in WPF spreadsheets with a rich collection of interactive charts and graphs.

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

Compare .NET WPF Spreadsheet Components

Importieren und Exportieren von CSV-Dateien mit WinForms C# & VB.NET

November 17, 2023

Verwenden Sie Spread.NET, um direkt in Ihren .NET WinForms-Anwendungen mit CSV-Dateien zu arbeiten.

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 Microsoft Excel spreadsheets. Developers can 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, MESCIUS Product Manager Kevin Ashley takes you through all the steps required to import and export data in CSV files using Spread.NET, including:

Creating / configuring the Project
Creating the File Menu
Creating / configuring SplitContainer
Adding Event Handler code
...and much more!

He also demonstrates how to use the Spread Designer tool to give users the ability to edit Excel spreadsheet instances inside your running application.

Read the full blog and start integrating CSV data import/export into your Windows applications.