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.

Class/Interface

Description

XlExport

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.

IXlExporter

An exporter used to create a spreadsheet document and export it to a stream.

IXlDocument

A workbook (the main spreadsheet document).

IXlSheet

An individual worksheet in a workbook.

IXlRow

An individual row in a worksheet.

IXlColumn

An individual column in a worksheet.

IXlCell

A box at the intersection of a column and a row in a worksheet. A cell can contain worksheet data, a formula and formatting.

XlCellRange

A continuous range of cells in a worksheet.

IXlMergedCells

A collection of merged cells in a worksheet.

XlVariantValue

A data value contained in a cell.

XlCellFormatting

Contains options to change cell format settings: fill, font, alignment, borders, and number format.

XlFill

Contains cell background attributes.

XlFont

Contains cell font attributes.

XlCellAlignment

Contains alignment settings for a cell.

XlBorder

Provides access to the line characteristics of a cell border.

XlNumberFormat

Allows you to specify a cell number format.

XlRichTextString

A rich formatted text in a cell.

XlConditionalFormatting

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:

DevExpress.Spreadsheet.XlFormulaParser

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.

IXlFormulaParameter

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.

XlExpression

Allows you to create a tokenized representation of a formula.

IXlFilterColumns

A collection of columns in a worksheet to which filtering is applied.

XlFilterColumn

Identifies a particular column in the filtered range and contains filter information that has been applied to this column.

IXlFilterCriteria

Allows you to specify the filter criteria.

The following types of filters are supported:

  • XlCustomFilters - a custom filter that uses filter values and comparison operators to construct the filter expression;
  • XlDynamicFilter - a dynamic filter;
  • XlTop10Filter - a "Top 10" filter that displays top/bottom ranked values;
  • XlValuesFilter - a filter by a list of cell values or date and time values;
  • XlColorFilter - a filter by cell color or font color.

XlPageSetup

Contains page settings: orientation, paper size, scaling options, printing DPI, etc.

XlPrintOptions

Contains printing options for a worksheet.

XlPageMargins

Allows you to specify page margins for a worksheet

XlHeaderFooter

Allows you to add headers and footers to a worksheet.

XlPrintTitles

Allows you to specify rows and columns that should be repeated on every printed page.

XlDataValidation

A data validation rule specified for a cell range(s) in a worksheet.

IXlPicture

An embedded image in a worksheet.

XlHyperlink

A hyperlink associated with a cell or cell range.

XlPictureHyperlink

A hyperlink associated with a picture.

IXlTable

A table in a worksheet.

XlSparklineGroup

A group of sparklines in a worksheet.

XlSparkline

A single sparkline in the sparkline group.

See Also