Nouvelles Spreadsheets

Synthétisez de façon dynamique des jeux de données volumineux

Avril 4, 2024
Tirez parti de la fonctionnalité de tableau croisé dynamique dans les contrôles de feuille de calcul .NET pour simplifier l’exploration et l’analyse des données au sein de vos applications.

.NET spreadsheet controls with built-in pivot table functionality empower developers to seamlessly integrate robust data analysis into their applications. This feature allows users to effortlessly rearrange and aggregate large datasets, gaining insights through customizable views without modifying the original data. Pivot tables streamline decision-making by simplifying complex tasks like sorting, filtering, and visualizing information, ultimately enhancing the usability and effectiveness of these spreadsheet applications.

Several .NET Spreadsheet controls support pivot tables including:

  • DevExpress WPF Spreadsheet (part of DevExpress WPF) offers advanced pivot table functionality for dynamic data analysis, enhancing usability and decision-making.
  • Document Solutions for Excel, .NET Edition by MESCIUS enables seamless integration of pivot tables into .NET applications for efficient data summarization and analysis tasks.
  • Aspose.Cells for .NET provides robust pivot table functionality, allowing developers to efficiently summarize and analyze large datasets within their .NET applications.
  • EPPlus empowers developers with pivot table capabilities in Excel files, facilitating dynamic data analysis within .NET applications effortlessly.

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

Compare .NET Spreadsheet Controls

Ajoutez des fonctionnalités de calcul avancées à votre application

Mars 22, 2024
L’API Document Solutions for Excel permet à vos applications .NET de bénéficier d’une analyse avancée des données grâce à des fonctions Excel intégrées.

Document Solutions for Excel, .NET Edition (DsExcel, previously GcExcel) is a high-speed, small-footprint, server-side spreadsheet API that requires no dependencies on Excel. With full .NET support, you can generate, load, modify, and convert spreadsheets in .NET, .NET Framework, .NET Core, Mono, and Xamarin. Apps using the spreadsheet API can be deployed to cloud, Windows, Mac, or Linux. Its powerful calculation engine and breadth of features means you'll never have to compromise design or requirements. The interface-based API is modeled on Microsoft Excel's document object model which means you can import, calculate, query, generate, and export any spreadsheet scenario.

Formulas and functions play an important role in data analysis. Microsoft Excel provides a range of functions that simplify the extraction of key metrics during data analysis. In this pair of blog posts from MESCIUS, Software Engineer Prabhat Sharma demonstrates how to use DsExcel to implement Excel functions and other Excel-like functionalities.

Part 1 of the blog shows you how to drill into sales data and integrate the following functions:

  • LOOKUP and Reference Functions
  • FILTER Function
  • TRANSPOSE Function

Part 2 of the blog digs into monthly budget data to show you how to use:

  • SUBTOTAL
  • CHOOSEROWS/CHOOSECOLS
  • SUMIF/AVERAGEIF
  • PMT/PPMT/IPMT
  • IF combined with AND/OR

Document Solutions for Excel is licensed per developer for either one distribution location or unlimited distribution locations. Licenses are perpetual, and include a one year subscription for all software releases (including hotfixes and major releases) plus Platinum Support. See our Document Solutions for Excel, .NET Edition licensing page for full details.

Learn more about Document Solutions for Excel, .NET Edition.

Manipulez des feuilles de calcul par programmation

Mars 21, 2024
LEADTOOLS v23 ajoute une nouvelle API Excel et un éditeur Web de type Excel basé sur la technologie primée Document SDK.

LEADTOOLS Document Suite is a comprehensive set of powerful document imaging SDKs designed to facilitate document processing and management tasks within software applications. It offers developers advanced capabilities for tasks such as OCR (Optical Character Recognition), barcode recognition, PDF manipulation, document conversion, annotation, and more. Leveraging this suite, developers can seamlessly integrate sophisticated document functionality into their software solutions, enabling efficient handling of various document formats and improving productivity in document-centric workflows.

The LEADTOOLS Document Suite SDK v23 update ushers in a new era of streamlined document management and enhanced productivity. The integration of the Excel API and Excel Web Editor empowers developers to seamlessly manipulate Microsoft Excel documents directly within their applications, regardless of platform. The Excel API offers programmatic control over Excel files, enabling efficient extraction, modification, and creation, while the Excel Web Editor fosters real-time collaborative editing within web applications. These powerful additions not only streamline document workflows but also equip developers with a comprehensive suite of Excel editing functionalities within the LEADTOOLS Document Suite ecosystem.

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

LEADTOOLS Document Suite SDK is licensed as Development Licenses, for developers to use the SDKs, and Deployment Licenses, for the right to distribute end user solutions. See our LEADTOOLS Document Suite SDK licensing page for full details.

Learn more on our LEADTOOLS Document Suite SDK product page.

Ajoutez la validation des données à vos feuilles de calcul .NET 8

Mars 21, 2024
Développez des applications de feuille de calcul avec des outils de validation des données intégrés pour éviter les erreurs, assurer la qualité des données et rationaliser l’analyse des données.

Data validation is a crucial feature for maintaining the integrity of data within a spreadsheet. It restricts the type of data or the values that users can enter into a cell. For example, a cell can be configured to only accept dates or numbers within a certain range. This minimizes input errors and ensures that data adheres to specified parameters, which is particularly important in scenarios where spreadsheets are used for data entry by multiple users or when the data feeds into critical business processes.

Several .NET 8 spreadsheet products offer data validation, including:

  • DevExpress Office File API (Spreadsheet Document API) is a high performance API for managing spreadsheet data in Microsoft Excel documents, supporting .NET 8 and offering data validation functionality.
  • Telerik Spread Processing (part of the Telerik UI product range) is a document processing library that supports .NET 8 and streamlines spreadsheet management, enabling data validation to ensure compliant input.
  • Infragistics WinForms Spreadsheet (part of Infragistics Ultimate UI for Windows Forms) provides data validation features to ensure data accuracy in desktop .NET 8 spreadsheet applications.
  • IronXL by Iron Software is a C# library for working with Excel files, without requiring Microsoft Office or Excel Interop, that supports .NET 8 and offers data validation for controlling data types and values in Excel files.

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

Compare .NET 8 Spreadsheet Controls

Utilisez divers types de cellules pris en charge dans vos applications de feuille de calcul

Février 27, 2024
Améliorez la flexibilité et les informations dérivées de vos données avec des types de cellules dédiés pour les nombres, les dates, les formules, etc.

Using varied cell types in spreadsheets enhances organization, efficiency, and clarity. Text-based cells streamline labeling and categorization, while numeric cells enable calculations and analysis. Date and time cells simplify the tracking of schedules and deadlines. Formulas automate complex computations, and logical cells support conditional formatting and decision-making processes. This diversity in cell types optimizes data representation and manipulation, making your spreadsheets more powerful and versatile tools.

Several JavaScript spreadsheet controls offer support for different cell types, including:

  • Telerik Spreadsheet for jQuery offers a variety of cell types including numeric, text, date, and boolean, along with the ability to define custom cell types and formatting.
  • SpreadJS by MESCIUS supports pre-defined cell types such as text, number, date, and formula, as well as custom cell types with user-defined formatting and validation rules.
  • Jspreadsheet Pro provides a range of built-in cell types including numeric, text, date, time, formula, and hyperlink, plus user-defined cell types with custom formatting and validation.
  • Syncfusion Spreadsheet includes various cell types such as general, number, currency, percentage, date, time, and formula, as well as custom cell types with tailored behavior.

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

Compare JavaScript Spreadsheet Controls