Product Structure

• Apr 12, 2019
• 4 minutes to read

Use the following links to access reference information about the most important classes and interfaces of the Excel Export Library.

Class/Interface	Description
XlExport	A static class that allows you to create an exporter instance to perform data export to the specified Excel format (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	The main spreadsheet document or workbook.
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 that 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: XlCondFmtRuleAboveAverage - formats cells whose values are above or below the average in a range of cells; XlCondFmtRuleCellIs - formats cells whose values meet the criterion represented by a relational operator; XlCondFmtRuleBlanks - formats blank/non-blank cells; XlCondFmtRuleDuplicates - formats duplicate values; XlCondFmtRuleUnique - formats unique values; XlCondFmtRuleExpression - uses a formula to determine which cells to format; XlCondFmtRuleTop10 - formats top/bottom ranked values; XlCondFmtRuleSpecificText - formats cells based on the text they contain; XlCondFmtRuleTimePeriod - formats dates that fall within a specified time period; XlCondFmtRuleDataBar - formats cells by using data bars; XlCondFmtRuleIconSet - formats cells by using icon sets; XlCondFmtRuleColorScale - formats cells using a gradation of two or three colors.
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.v19.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.