Excel Export API
- 4 minutes to read
Use the following links to obtain reference information about the most important classes and interfaces of the Excel Export Library.
A static class used to create an exporter instance that allows you to save spreadsheet data to the supported Excel formats (XLSX, XLS, or CSV).
This is the entry point for programmatic generation of spreadsheet files with the Excel Export Library.
An exporter used to create a spreadsheet document and export it to a stream.
A workbook (the main spreadsheet document).
An individual worksheet in a workbook.
An individual row in a worksheet.
An individual column in a worksheet.
A box at the intersection of a column and a row in a worksheet. A cell can contain worksheet data, a formula and formatting.
A continuous range of cells in a worksheet.
A collection of merged cells in a worksheet.
A data value contained in a cell.
Contains options to change cell format settings: fill, font, alignment, borders, and number format.
Contains cell background attributes.
Contains cell font attributes.
Contains alignment settings for a cell.
Provides access to the line characteristics of a cell border.
Allows you to specify a cell number format.
A rich formatted text in a cell.
Allows you to create a conditional formatting rule(s) and apply it to the specified cell range(s).
The following types of conditional formatting rules are available:
Provides the capability to parse and validate string formulas.
Using the XlFormulaParser in your code requires a reference to the DevExpress.Spreadsheet.v21.1.Core.dll assembly.
Allows you to construct a formula from a combination of the most commonly used functions (static methods of the XlFunc class),
arithmetic and relational operators (static methods of the XlOper class) and constants.
Allows you to create a tokenized representation of a formula.
A collection of columns in a worksheet to which filtering is applied.
Identifies a particular column in the filtered range and contains filter information that has been applied to this column.
Allows you to specify the filter criteria.
The following types of filters are supported:
Contains page settings: orientation, paper size, scaling options, printing DPI, etc.
Contains printing options for a worksheet.
Allows you to specify page margins for a worksheet
Allows you to add headers and footers to a worksheet.
Allows you to specify rows and columns that should be repeated on every printed page.
A data validation rule specified for a cell range(s) in a worksheet.
An embedded image in a worksheet.
A hyperlink associated with a cell or cell range.
A hyperlink associated with a picture.
A table in a worksheet.
A group of sparklines in a worksheet.
A single sparkline in the sparkline group.