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
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
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 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
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
See Demo
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
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
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: