Neuigkeiten zu Spreadsheets

Importieren Sie XLSX-Dateien in Ihre Vue.js Anwendungen

Januar 8, 2024
Integrieren Sie die Microsoft Excel-Dateihandhabung mit einem Tabellenkalkulationssteuerelement, das den XLSX-Import unterstützt, in Ihre Vue.js Apps.

The ability to import XLSX files is a common feature in spreadsheet software, allowing users to open and work with files created in other applications like Microsoft Excel. These versatile controls streamline data integration and boost efficiency by effortlessly populating spreadsheets with pre-existing data, saving valuable time and eliminating error-prone manual entry. This ensures compatibility and ease of data transfer, enabling users to bring in complex datasets with various formatting and formulas intact, which is essential for interoperability and collaboration. Vue.js spreadsheet components eliminate the drudgery of manual data entry and revolutionize the way you manage information within your applications.

Several Vue.js spreadsheet controls support XLSX file import, including:

  • Wijmo FlexSheet (part of Wijmo) by MESCIUS fully supports the import of XLSX files via its FlexGrid component for Vue, which is capable of retaining the styles and formatting of the document.
  • Syncfusion Spreadsheet JavaScript (part of Syncfusion Essential Studio Enterprise) offers all the common Excel features including the ability to import XLSX files and other Excel file formats.
  • Jspreadsheet Pro is a lightweight JavaScript library compatible with Vue that provides import/export functionality for the XLSX file format, as well as many other advanced spreadsheet-like controls.

For an in-depth analysis of features and price, visit our Vue.js Spreadsheet Controls comparison.

Compare Vue.js Spreadsheet Controls

Hinzufügen eines Excel-ähnlichen Menübands zu Ihren .NET-Tabellen

Januar 2, 2024
Spread.NET 17 verfügt über ein neues Menüband-Steuerelement, mit dem Sie kontextbezogene Registerkarten, Schaltflächen und Menüs zu Ihren Tabellenkalkulations-Apps hinzufügen können.

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 release adds a new Ribbon control to modernize your spreadsheet's look and feel. Inspired by Excel, this intuitive interface organizes commands into clear, contextual tabs and groups, making it easy for users to find the tools they need. This modern upgrade not only boosts productivity but also brings a familiar feel to your spreadsheets, streamlining the entire user experience.

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

Erstellen von Gantt-Planungs-Apps in JavaScript

Dezember 27, 2023
SpreadJS 17 führt das optionale GanttSheet-Add-on ein, das eine datengebundene DataTable-Ansicht mit Gantt-Diagrammverhalten und einer Tabellenkalkulations-Benutzeroberfläche bietet.

SpreadJS by MESCIUS is a powerful JavaScript library that lets you build Excel-like spreadsheets within your web applications. It offers tables, charts, formulas, pivot tables, and more, all running within the browser. It works with major frameworks like Angular, React, and Vue, and offers Excel file import and export. SpreadJS empowers developers to create interactive dashboards, analyze data, and streamline workflows, all within the familiar spreadsheet interface.

The SpreadJS 17 release introduces the optional GanttSheet Add-On, a full Gantt implementation that works inside of SpreadJS. It seamlessly integrates with your existing spreadsheets, transforming them into clear and concise Gantt charts. This allows you to visualize tasks, dependencies, and progress at a glance, identifying potential bottlenecks and adjust schedules proactively. GanttSheet offers a flexible and intuitive may to manage tasks, sort data, customize calendar settings, and even import/export plans for smooth collaboration.

To see a full list of what's new in version 17, 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 GanttSheet Add-On is available at an additional cost, and requires a SpreadJS license. See our SpreadJS licensing page for full details.

For more information, visit our SpreadJS product page.

Exportieren von Tabellenkalkulationen in CSV in WinForms-Apps

Dezember 21, 2023
Der Export in CSV bietet eine universelle Kompatibilität und vereinfacht die gemeinsame Nutzung von Daten mithilfe verschiedener Plattformen und Anwendungen.

The ability to export to comma-separated values (CSV) from a spreadsheet control enhances interoperability and data accessibility. It seamlessly translates spreadsheet data into the ubiquitous CSV format, fostering effortless integration with a vast ecosystem of analytical tools, databases, and third-party applications. This democratizes your data, empowering users to leverage existing workflows and external expertise, enriching analysis, and maximizing the reach and impact of your data-driven insights.

Several WinForms spreadsheet components provide CSV export functionality, including:

  • DevExpress WinForms Spreadsheet (part of DevExpress WinForms) supports precision-tuned CSV exports with customizable formatting, separators, and macros.
  • Syncfusion WinForms Spreadsheet (part of Syncfusion Essential Studio) offers flexible CSV export with support for custom delimiters, headers, and intelligent filters.
  • Telerik WinForms Spreadsheet (part of Telerik UI for WinForms) provides CSV export with support for selected ranges and high performance even with large datasets.
  • Spread.NET WinForms (part of Spread.NET by MESCIUS) allows you to craft complex multi-sheet exports with cell mapping, macros, and conditional formatting for enhanced clarity.

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

Compare WinForms Spreadsheet Components

Filtern und Gruppieren von Daten in Angular Spreadsheet-Apps

Dezember 19, 2023
Datenfilterung und -gruppierung ermöglichen es Tabellenkalkulationsbenutzern, große Datensätze effizient und einfach zu verwalten und zu analysieren.

Data filtering and grouping are key spreadsheet features that allow users to manage and analyze large datasets efficiently. Filtering enables users to hide data that does not meet certain criteria, making it easier to focus on relevant information. Grouping clusters related data together, which can then be summarized with functions such as sum, average, and count. These features are vital for working with extensive spreadsheets, enabling users to simplify their view, and gain insights from specific subsets of data.

Several Angular Spreadsheet components provide data filtering and grouping support including:

  • Jspreadsheet Pro supports navigating large datasets with ease using multi-level filtering and summarize key trends with dynamic group summaries.
  • Syncfusion Spreadsheet JavaScript (part of Syncfusion Essential Studio) allows you to gain insights and enhance understanding with nested grouping.
  • Infragistics Spreadsheet Angular (part of Infragistics Ignite UI) lets you simplify data exploration with drag-and-drop grouping and aggregate functions for instant summaries.
  • SpreadJS by MESCIUS supports crafting precise filters using advanced formulas and grouping data by multiple criteria for deeper analysis.

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

Compare Angular Spreadsheet Components