Spreadsheet Document API for .NET

Create, read, write, convert, print, and protect Microsoft Excel documents.

Use our cross-platform and comprehensive Spreadsheet API for .NET to create, read, protect, convert, and export Microsoft Excel documents within your apps. Try our free 30-day trial to get started.

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)

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
Microsoft Excel Compatibility

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

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

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

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

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 & Conditional Formatting

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
Mail Merge

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

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

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

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
Document Security

DevExpress Excel-Inspired 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

Time to Rock & Roll – Download our Free Trial Today
And See Why our WinForms Controls Are Consistently Voted #1

Developers have consistently voted DevExpress best-in-class. Among countless other awards, we've received over 70 first place Visual Studio Magazine Reader's Choice awards over the last six years. Download our fully-functional 30-day trial today and experience the DevExpress difference today.

 

Download 30-Day Trial

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