Cross-Platform Spreadsheet Processing

Generate and process Microsoft Excel worksheets and workbooks across multiple platforms and operating systems. Our .NET Spreadsheet API supports the following platforms and operating systems:

  • Windows, Linux, MacOS
  • Azure, Docker
  • .NET 5 / .NET Framework 4.5.2+
  • .NET Core 2.1+ / NET Core 3.0+ / .NET Standard 2.0+


Redistribution and Deployment (.NET Framework)

Install NuGet Packages (.NET Core)

Cross-Platform Spreadsheet Processing - Office File API | DevExpress

Microsoft Excel Compatibility

DevExpress Spreadsheet Document 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

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 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 Spreadsheet API 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

Our .NET Spreadsheet API allows you to password-protect your Excel 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

From XLS to XLSx and everything in between, the DevExpress 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 2019

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

Recent Office File API & Spreadsheet API News



2021 Roadmap

Based on your votes and feedback, we've finalized our 2021 Office File API and Office-inspired Desktop UI Controls Roadmap. We thank you for your continued support and for sharing your needs/requirements.

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 that you're using, please write to us at support@devexpress.com and request the an evaluation version that suits your requirements.

Versions
21.1.4
18.1.16
12.2.18
11.1.12
Release Date
24-June-2021
29-April-2021
15-October-2014
21-June-2012
Supported Frameworks
.NET 5
.NET Core 3.0+
.NET Framework 4.5.2+
.NET Standard 2.0+
.NET Framework 4.0+
.NET Framework 4.5
.NET Framework 4.0
.NET Framework 3.5
.NET Framework 4.0
.NET Framework 3.5
.NET Framework 2.0
Supported IDE
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
Visual Studio 2013
Visual Studio 2012
Visual Studio 2010
Visual Studio 2008
Visual Studio 2010
Visual Studio 2008
Visual Studio 2005

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 Core?

Yes. It supports .NET Core 2.1+ / NET Core 3.0+ / .NET Standard 2.0+. Our Spreadsheet Document API is also compatible with .NET 5. The DevExpress Spreadsheet file generation API works in apps that run on Windows, Linux, and MacOS. You can even deploy your apps on Azure.

How do I get started with the Spreadsheet Document API?

Best in Class Tools

DevExpress is honored to have been voted best in class 20 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.

x20
x18
x19
x19

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.

Best Value
WinForms Controls
WPF Controls
TreeView
Sunburst
ASP.NET Web Forms Controls
Printing & Exporting
ASP.NET MVC Extensions
Printing & Exporting
ASP.NET MVC Client-Side Controls
ASP.NET Core Controls
ASP.NET Core Office Controls
ASP.NET Bootstrap Controls
Themes and Skinning
JavaScript - jQuery, Angular, React, Vue
Blazor UI Components
Grid Layout
Stack Layout
UWP Controls
Reporting
WinForms Document Viewer
WinForms End-User Report Designer
ASP.NET Web Forms Document Viewer
ASP.NET Web Forms End-User Report Designer
ASP.NET MVC Document Viewer
ASP.NET MVC End-User Report Designer
ASP.NET Core Document Viewer
ASP.NET Core End-User Report Designer
Blazor Document Viewer
Blazor End-User Report Designer
WPF Document Viewer
WPF End-User Report Designer
Angular Document Viewer
Angular End-User Report Designer
XPO - ORM Library
Office File API (Basic)
.NET Standard 2.0+ Support (Windows, Linux, MacOS)
Office File API (Complete)
.NET Standard 2.0+ Support (Windows, Linux, MacOS)
Business Intelligence Dashboard
XAF - Cross-Platform .NET App UI
Role-based Access Control and User Authentication (.NET)
Xamarin.Forms UI Controls with Support
Native Mobile UI Controls
CodeRush with Support
C#, VB.NET, XAML
CodeRush Classic
VS 2015 Support
VS 2012, 2013 Support
C#, VB.NET, XAML
HTML, ASP.NET, CSS, Razor, JavaScript
Source Code *
WinForms Controls
ASP.NET Controls
WPF Controls
JavaScript - jQuery, Angular, React
Blazor UI Components
UWP Controls
XPO - ORM Library
Office File API
Data Visualization Dashboard
XAF - Cross-Platform .NET App UI
Technical Support
Priority Support

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