Nouvelles Spreadsheets

Améliorez la gestion des données dans les feuilles de calcul .NET 8

Août 30, 2024
L’ajout de fonctionnalités de recherche et de remplacement aux tableurs .NET 8 favorise la productivité et la cohérence, tout en atténuant les erreurs.

Find and replace is a useful feature found in spreadsheet applications that allows users to quickly locate specific values, i.e. text, numbers, or formulas, identifying all instances of that search term within a spreadsheet and then being able to replace them with a new value. By automating the process of manually searching for and modifying each occurrence individually, find and replace enhances productivity, reduces the likelihood of human error, and ensures consistency throughout the spreadsheet. This functionality is especially beneficial for tasks that involve managing large volumes of data, updating outdated information, correcting mistakes, or standardizing data formats.

Several .NET 8 spreadsheet components allow you to find and replace, including:

  • DevExpress WinForms Spreadsheet enhances data management in .NET 8, facilitating find and replace operations via the user interface or directly in code.
  • Telerik WPF Spreadsheet (part of Telerik UI for WPF) allows you to efficiently locate and replace content using find and replace in .NET 8 spreadsheet applications.
  • IronXL by Iron Software is a library that supports .NET 8 and offers several cell range functions including find and replace for Microsoft Excel spreadsheets.
  • MindFusion.Spreadsheet for WPF can provide spreadsheet applications in .NET 8 with intuitive find-and-replace capabilities for consistent and accurate data manipulation.

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

Compare .NET 8 Spreadsheet Components

Implémentez des fonctions Excel dans vos applications Web

Août 28, 2024
Utilisez l’éditeur Web Excel LEADTOOLS pour charger et enregistrer des fichiers XLS/XLSX depuis votre code.

LEADTOOLS Document SDK is ideal for developing document and document imaging applications. Features include PDF viewing, comprehensive annotation and markup, specialized bitonal image displaying, and image processing. Other features include performance and memory optimizations for bitonal images, document image cleanup, including inverted text, border, hole-punch, and line removal, and scanning with LEADTOOLS Fast TWAIN and WIA. The LEADTOOLS Excel SDK - included in the Document SDK - gives developers the power to load, create, edit, and save Excel sheets programmatically.

In this blog post (the second in a 3-part series on the Excel SDK), LEADTOOLS Associate Marketing Web Developer Ryan Fritz shows you how to use the new Excel Web Editor to load an XLS/XLSX file, implement a common Excel function, and then save the updated file.

Read the complete blog and learn how to give your web applications this powerful and useful capability.

LEADTOOLS Document 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 SDK licensing page for full details.

Learn more on our LEADTOOLS Document SDK product page.

Améliorez votre feuille de calcul grâce à des formules améliorées par l’IA

Août 23, 2024
Utilisez DevExpress WinForms Spreadsheet pour permettre des calculs avancés avec des formules définies par l’utilisateur et optimisées par l’intelligence artificielle.

DevExpress DXperience is a comprehensive software development suite designed to enhance productivity and streamline the creation of high-performance applications across various platforms. It offers a wide range of tools and components for developers working with .NET frameworks including Windows Forms, WPF, ASP.NET, and Blazor as well as JavaScript, Angular, React, Vue, and jQuery. The suite includes powerful UI controls, data visualization tools, reporting capabilities, and cross-platform libraries that enable developers to build modern, responsive, and visually appealing applications efficiently.

In this blog post, DevExpress's Maria Nikulina shows you how to integrate OpenAI services with the DevExpress WinForms Spreadsheet Control (included with DXperience) to implement user-defined formulas for advanced calculations. These formulas let you automate repetitive tasks, efficiently analyze data, and execute advanced calculations not possible with built-in functions.

Steps include:

  • Setting up the DevExpress WinForms Spreadsheet Control
  • Setting up the OpenAI Client
  • Creating a User-Defined Function
  • Registering the Custom Function
  • Using the Custom Function within the Spreadsheet

Detailed sample code is included.

Read the complete blog to learn how to take Excel formula calculations to a whole new level by integrating AI services.

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

The DevExpress WinForms Spreadsheet Control is available to buy in the following products:

Affinez l’analyse Excel grâce à la recherche automatisée d’objectifs

Août 23, 2024
Document Solutions for Excel, .NET 7.2 peut désormais automatiser l’analyse de scénarios et la prise de décision dans vos applications .NET.

Document Solutions for Excel, .NET Edition by MESCIUS is designed to enable developers to create and manipulate Excel documents programmatically within .NET applications. It provides a robust API for interacting with Excel spreadsheets, allowing developers to automate tasks such as data extraction, formatting, and generation of reports. The framework offers comprehensive support for various Excel features, including formulas, charts, conditional formatting, and data validation. It also provides tools for handling large datasets and optimizing performance, making it suitable for both small-scale and enterprise-level applications.

The Document Solutions for Excel 7.2 release now incorporates Goal Seek functionality, providing developers with the ability to programmatically implement scenario analysis and decision-making processes within their .NET applications. By leveraging the Goal Seek API, developers can automate the process of determining the optimal input values required to achieve a specific target output within an Excel spreadsheet. This feature significantly enhances the capabilities of the framework, empowering developers to create more sophisticated and dynamic applications that can effectively support complex modeling and analysis tasks.

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

Document Solutions for Excel, .NET Edition is licensed per developer and is available in several license options for differing distribution needs. Team licenses are also available for multiple developers within the same organization. See our Document Solutions for Excel, .NET Edition licensing page for full details.

Document Solutions for Excel, .NET Edition is available to buy in the following products:

Optimisez l’organisation des données avec des tableaux

Août 20, 2024
Les tableaux des feuilles de calcul offrent un moyen structuré d’organiser et d’optimiser l’intégrité des données et permettent une analyse et un reporting efficaces.

Spreadsheet tables are organized groups of data in a spreadsheet, often with a header row and a range of cells containing related information. They make data management easier by grouping related information, improving how it looks and how easy it is to use. You can use functions and formulas on entire tables to automate calculations and reduce manual work. Tables often let you filter and sort data based on specific criteria, making analysis and reporting easier. Common uses include financial analysis, inventory management, project tracking, and customer databases.

Several WinForms spreadsheet controls offer table support including:

  • DevExpress WinForms Spreadsheet (part of DevExpress WinForms) enables developers to create and manage tables with sorting, filtering, and data binding capabilities.
  • Aspose.Cells for .NET provides programmatic control over tables in Excel files, enabling creation, formatting, and manipulation.
  • Spread.NET WinForms (part of Spread.NET by MESCIUS) simplifies creating data-bound tables with automatic formatting and built-in filtering options.
  • Infragistics WinForms Spreadsheet (part of Infragistics Ultimate UI for Windows Forms) allows users to define and format tables, offering filtering and calculated columns.

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

Compare WinForms Spreadsheet Controls