Spreadsheet Document API for .NET

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

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

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-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.

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

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.

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

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.

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.

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.

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

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:

• WinForms Spreadsheet
• WPF Spreadsheet
• ASP.NET Core Spreadsheet
• ASP.NET & MVC Spreadsheet
• Bootstrap Spreadsheet