Cross-Platform Spreadsheet Processing

Generate and process Microsoft Excel worksheets and workbooks across all platforms and operating systems that support recent .NET versions. Our Spreadsheet API library is powered by our Skia-based cross-platform rendering engine and supports the following platforms and operating systems:

  • Windows, Linux, MacOS
  • Azure, AWS, Docker
  • .NET 7, .NET 6
  • .NET Framework 4.5.2+

Download using DevExpress NuGet feed

Learn more about cross-platform support

Cross-Platform Spreadsheet Processing - Office File API | DevExpress

Microsoft Excel Compatibility

Our Spreadsheet API supports nearly all Microsoft Excel document formats including:

  • XLSX, XLSM, XLSB, XLS
  • XLTX, XLTM, XLT
  • XML Spreadsheet 2003
  • CSV
  • TXT
  • Export to PDF / HTML / Image

You can also convert your spreadsheets to accessible PDF files that conform PDF/A-1a, PDF/A-2a, PDF/A-3a, and PDF/UA standards. Read the blog post

See Demo

Microsoft Excel Compatibility - Office File API | DevExpress

Supported Document Elements

With our comprehensive Spreadsheet API, you can create, access, modify, or remove the following Excel document elements:

  • Workbook, Worksheets, Chart Sheets
  • Rows, Columns, Cells
  • Tables, Pivot Tables
  • Charts, Sparklines
  • Pictures, Shapes
  • Document Properties
  • Defined Names
  • Comments
  • Hyperlinks
  • Page Breaks
  • Headers, Footers
  • Print Titles
Supported Document Elements - Office File API | DevExpress

Excel Compatible Functions

Over 400 built-in functions with array formula support allow you to create formulas and perform high-precision and multi-threaded calculations at incredibly fast speeds.

From basic mathematical functions to complex formulas with statistical, financial, and real-time data (RTD) functions, DevExpress Spreadsheet API includes everything you need to incorporate Excel-inspired data analysis functionality in your app.

And of course, you can create your own functions. Custom functions are available for all spreadsheet calculations and can be used within formulas.

Excel Compatible Functions - Office File API | DevExpress

Excel-inspired Pivot Tables

Insert Excel-like pivot tables to summarize and analyze large amounts of data. Pivot Tables are highly flexible and can be quickly modified to address your specific usage scenario.

Excel-inspired Pivot Tables - Office File API | DevExpress

Charts, Sparklines, Shapes

Our Excel Spreadsheet API library supports shapes (from simple lines and rectangles, to 3D shapes), sparklines (Line, Column, Win/Loss), and a wide range of 2D/3D charts:

  • Column and Bar Charts
  • Pie and Doughnut Charts
  • Area and Line Charts
  • Scatter, Radar, and Bubble Charts
  • Box and Whisker Charts
  • Histogram and Pareto Charts
  • Treemap and Sunburst Charts
  • Waterfall Charts
  • Funnel Charts
  • Stock Charts
Charts, Sparklines, Shapes - Office File API | DevExpress

Cell Styles & Conditional Formatting

Create Excel worksheets that are fully optimized for clarity and readability. Use cell styles to apply predefined formats, and other formatting options to intuitively present workbook data. Cell value formatting options include:

  • Predefined and Custom Cell Styles
  • Cell Formatting Options (Number Format, Font, Alignment, Borders, Fill)
  • Style Flags
  • Rich Text Formatting

You can also highlight cells based on specific criteria. Cells can be highlighted with data bars, icons, and predefined color scales.

Cell Styles and Conditional Formatting - Office File API | DevExpress

Mail Merge

Mail Merge is built-in and allows you to automatically generate a batch of Excel documents based on a single document template. Our Spreadsheet API supports the following Mail Merge functions (placeholders):

  • FIELD
  • FIELDPICTURE
  • RANGE
  • PARAMETER

See Demo

Mail Merge - Office File API | DevExpress

Bind to Data

You can bind a cell range or table in a worksheet to a data source or use a cell range as a data source for any DevExpress or third-party data-aware UI control (Data Grid, Chart Control, etc.).

Our .NET Spreadsheet API fully supports data export and import. You can import data to worksheet cells from arrays, lists, and data tables – and yes, you can export a cell range to a DataTable.

Bind to Data - Office File API | DevExpress

Filter, Sort, Group, and Search

Just like Microsoft Excel, DevExpress Spreadsheet API includes an AutoFilter - designed to filter data against column values and to display only the rows that meet specific criteria.

As you would expect, our Spreadsheet API supports grouping (outlines) and sorting against an unlimited number of columns. You can sort data by text (alphabetically, according to the current culture), numbers, dates, and time.

And of course, you can search within a worksheet, specify whether the operation should be case-sensitive, and search using wildcard characters.

Filter, Sort, Group, and Search - Office File API | DevExpress

Data Validation

Our Data Validation API helps you reduce data entry errors and keep workbook data concise and accurate. You can easily define restrictions and provide text-based feedback as to what can be entered into spreadsheet cells.

Data Validation - Office File API | DevExpress

Document Security

Excel Spreadsheet API allows you to password-protect your worksheets/workbooks and prevent unauthorized access. Security options include:

  • Restrict Document Modification
  • Encrypt a Document with a Password
  • Specify a Password to Open or Edit a Document
  • Grant User Permissions
  • Electronically Sign Microsoft Excel Documents

See Demo

Document Security - Office File API | DevExpress

DevExpress Spreadsheet UI Controls

Embed Excel UI into your desktop and web apps.

From XLS to XLSx and everything in between, our Spreadsheet UI controls allow you to quickly incorporate advanced spreadsheet functionality in your next desktop and web application.

Our Spreadsheet controls ship with a comprehensive collection of end-user options so you can deliver Microsoft Excel-inspired functionality with ease. If your app requires a full spreadsheet processing user interface (if you need to introduce an Excel-inspired UX into your app), please refer to the following web pages for more information on our Spreadsheet controls:

DevExpress Excel-Inspired Spreadsheet UI Controls - Office File API | DevExpress

Newest Office File API & Spreadsheet API Features

for the .NET, .NET Core, Visual Studio 2022

Our goal is perfection and thanks to feedback from our loyal users, we continue to improve the capabilities of our Spreadsheet Document API.
See what we've been up to in the recent release cycle.



RC4 CryptoAPI Encryption - Spreadsheet Document API | DevExpress

RC4 CryptoAPI Encryption

DevExpress Spreadsheet Document API can import and export RC4 CryptoAPI encrypted XLS files. RC4 CryptoAPI is now the default encryption method for binary files if you use the Strong encryption type to encrypt your documents.

Excel 2016 Charts - Spreadsheet Document API | DevExpress

Excel 2016 Charts

The DevExpress Spreadsheet Document API supports a broad range of 2D and 3D chart types. In our most recent major release, we extended the list of supported chart types and added support for Excel 2016 charts (Box and Whisker, Funnel, Histogram, Sunburst, Treemap, Waterfall, and Pareto).

Document Theme API - Spreadsheet Document API | DevExpress

Document Theme API

You can access and modify document theme in code. Load a custom theme from a THMX file or customize predefined theme colors as needed.

 

Free 30-Day TrialSee What's New

Office File API & Spreadsheet API News



Generate Accessible PDF Files

Our most recent release includes enhanced PDF export options for our Spreadsheet and Word Processing. You can now convert your spreadsheet and rich text documents to accessible PDF files.

Digital Signatures in Office Documents

As of our last major release, our Office File API offers support for digital signatures. You can now electronically sign Microsorf Word, Excel, and PowerPoint documents.

Multiple Signatures and Timestamps

Our PDF Document API allows you to apply multiple signatures to a document without existing signatures and to apply new signatures to a document that has yet to be signed.

More News

Supported IDEs

Review the list of development tools and frameworks supported by our products. We strongly recommend that you always download and use the most recent versions. If the latest version does not support the IDE or framework you're using, please submit a support ticket via the DevExpress Support Center and request an evaluation version that suits your requirements.

Version
24.1.5
23.1.12
22.1.14
18.1.18
Release Date
15-August-2024
15-August-2024
7-May-2024
5-May-2022
Support Status
Supported
Limited Support
Not Supported
(for legacy apps)
Not Supported
(for legacy apps)
Minor Updates
Yes
No
No
No
Security Updates
Yes
Yes
No
No
Supported Frameworks
.NET 6 / .NET 7 / .NET 8
.NET Framework 4.5.2+
.NET 6
.NET 5
.NET Framework 4.5.2+
.NET Standard 2.0+
.NET 6
.NET 5
.NET Core 3.0+
.NET Framework 4.5.2+
.NET Standard 2.0+
.NET Framework 4.0+
Supported IDE
Visual Studio 2022
Visual Studio 2019
Visual Studio 2017
Visual Studio 2015
Visual Studio 2022
Visual Studio 2019
Visual Studio 2017
Visual Studio 2015
Visual Studio 2022
Visual Studio 2019
Visual Studio 2017
Visual Studio 2015
Visual Studio 2013
Visual Studio 2012
Visual Studio 2019
Visual Studio 2017
Visual Studio 2015
Visual Studio 2013
Visual Studio 2012
Visual Studio 2010

Frequently Asked Questions

Is MS Office required for the Spreadsheet Document API to work with documents?

No, you do not need a copy of Microsoft Excel to generate XLS, XLSx files.

What can I do with data and files using the Spreadsheet Document API?

You can manage spreadsheet or Excel documents through files, streams and byte arrays, print and export spreadsheets to PDF, merge-split spreadsheet documents, generate spreadsheets using templates, modify spreadsheet content, analyze and visualize data, protect spreadsheets with passwords and digital signatures, and convert documents to different spreadsheet and image file formats.

Does the DevExpress Spreadsheet Document API support .NET?

Yes. It supports .NET 6, .NET 7, .NET Standard 2.0+. The DevExpress Spreadsheet file generation API works in apps that run on Windows, Linux, and MacOS. You can even deploy your apps on Azure and AWS.

How do I get started with the Spreadsheet Document API?

Best in Class Tools

DevExpress is honored to have been voted best in class 19 times in this year's Visual Studio Magazine Reader's Choice Awards.

Experience the DevExpress difference and see why your peers consistently vote our products #1. With our Universal Subscription, you will build your best, see complex software with greater clarity, increase your productivity and create stunning applications for Windows, Web and your Mobile world.

19 VSM Awards in 2023 x19
20 VSM Awards in 2022 x20
20 VSM Awards in 2021 x20
18 VSM Awards in 2020 x18

60 Day Unconditional Money Back Guarantee

We are so confident in our products and services that we back them with a 60 day no questions asked money back guarantee. If within the first 60 days of ownership you are not satisfied with the capabilities of our tools, you can request a full refund of the amount you paid to DevExpress by writing to clientservices@devexpress.com or by calling +1 (818) 844-3383.

Tag <dxtransform> is invalid. Transformation failed: An error occurred while loading document '../../../App_Data/GeneratedData/ProductsStructure.xml'. See InnerException for a complete description of the error.

* DevExpress does not include/ship source code for certain products, including CodeRush, TestCafe Studio, and Report & Dashboard Server.

Start your free 30-day trial today!

Download our fully-functional 30-day trial today and
experience the DevExpress difference today.

 

Download Free Trial