Spreadsheets News

Elevate Your Spreadsheet with AI-Enhanced Formulas

August 23, 2024
Use DevExpress WinForms Spreadsheet to unlock advanced calculations with user-defined formulas powered by Artificial Intelligence.

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:

Refine Excel Analysis with Automated Goal Seeking

August 23, 2024
Document Solutions for Excel, .NET 7.2 can now automate scenario analysis and decision making within your .NET applications.

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:

Enhance Data Organization with Tables

August 20, 2024
Tables in spreadsheets provide a structured way to organize data, enhance data integrity, and enable efficient analysis and reporting.

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

Import and Export Excel XLSX Using WPF

August 9, 2024
Find out how Spread.NET by MESCIUS can enhance your WPF projects with seamless Excel spreadsheet import and export capabilities in C# or VB.

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 spreadsheet applications with Spread.NET. These steps include:

  • Create a WPF Spreadsheet Application
  • Define the User Interface for a WPF Spreadsheet App
  • Add Excel XLSX Import Code - Invoke ExcelOpen Method
  • Add Excel XLSX Export Code - Invoke SaveExcel Method

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

Read the full blog to get started using the full capabilities of the Spread.NET WPF 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.

Allow Spreadsheets to Perform Clipboard Operations

August 2, 2024
Enhance Angular spreadsheet applications with the ability to cut, copy and paste data, streamlining data manipulation and management tasks.

A spreadsheet control that supports clipboard operations gives users the ability to cut, copy and paste data within or between spreadsheets. These functions enable users to efficiently transfer, duplicate, or relocate information by temporarily storing selected cells or ranges in a system-wide clipboard. This functionality forms a key part of a spreadsheet application, saving time and increasing productivity by enabling quick duplication or relocation of data without the need to manually re-enter information. By reducing the risk of errors that might occur during manual data entry or reformatting, these operations help maintain data integrity and streamline data manipulation and management tasks.

Several Angular spreadsheet components support the use of clipboard operations, including:

  • SpreadJS by MESCIUS is a complete JavaScript spreadsheet solution with full support for Angular that allows users to easily perform clipboard operations.
  • Jspreadsheet Pro facilitates clipboard integration into Angular applications, providing seamless data transfer with intuitive cut, copy, and paste functionalities.
  • Infragistics Spreadsheet Angular (part of Infragistics Ignite UI) is a lightweight component that enables users to perform cut, copy, and paste clipboard operations.
  • Syncfusion Spreadsheet JavaScript (part of Syncfusion Essential Studio Enterprise) lets you execute clipboard commands for easy data manipulation in Angular.

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

Compare Angular Spreadsheet Controls