DevExpress.Export.Xl Namespace

Contains classes and interfaces that constitute the Excel Export Library used for generating spreadsheet files.

Classes

	Class	Description
	XlBorder	Provides access to the line characteristics of a cell border.
	XlBordersBase	Serves as a base for the XlBorder class and specifies the border line style options.
	XlCellAlignment	Contains alignment settings for a cell.
	XlCellFormatting	Represents the object that specifies cell format characteristics.
	XlCellRange	Defines a range of cells.
	XlColor	Represents a color used in the spreadsheet document.
	XlColorFilter	A filter by cell fill or font color.
	XlCondFmtCustomIcon	Provides access to the particular icon in the custom icon set.
	XlCondFmtRule	Base class for the conditional formatting rules.
	XlCondFmtRuleAboveAverage	Represents the "Above or Below Average..." conditional formatting rule.
	XlCondFmtRuleBlanks	Represents the conditional formatting rule that highlights blank/non-blank cells.
	XlCondFmtRuleCellIs	Represents the conditional formatting rule that uses the relational operator.
	XlCondFmtRuleColorScale	Represents the Color Scale conditional formatting rule.
	XlCondFmtRuleDataBar	Represents the Data Bar conditional formatting rule.
	XlCondFmtRuleDuplicates	Represents the conditional formatting rule for cells with duplicate values.
	XlCondFmtRuleExpression	Represents the conditional formatting rule that uses a relational operator to determine which cells to format.
	XlCondFmtRuleIconSet	Represents the Icon Set conditional formatting rule.
	XlCondFmtRuleSpecificText	Represents "A Text That Contains..." conditional formatting rule.
	XlCondFmtRuleTimePeriod	Represents the "Date Occurring..." conditional formatting rule.
	XlCondFmtRuleTop10	Represents the "Top/Bottom N" conditional formatting rule.
	XlCondFmtRuleUnique	Represents the conditional formatting rule for cells with unique values.
	XlCondFmtRuleWithFormatting	Provides formatting settings for the conditional formatting rules.
	XlCondFmtValueObject	Represents a minimum or maximum threshold for a conditional formatting rule.
	XlConditionalFormatting	Represents the worksheet ranges and conditional formatting rules applied to them.
	XlCustomFilterCriteria	Specifies a criterion value and comparison operator for a custom filter.
	XlCustomFilters	A custom filter that uses filter values and comparison operators to construct the filter expression.
	XlDataValidation	Represents the data validation rule defined for a current worksheet.
	XlDateGroupItem	A group of dates or times used in the filter criteria.
	XlDocumentCustomProperties	Contains custom document properties associated with a workbook.
	XlDocumentProperties	Contains basic document properties associated with a workbook.
	XlDynamicFilter	A dynamic filter that shows dates that fall within a specified time period or displays values that are above or below the average.
	XlExport	Represents an object that creates an exporter for generating spreadsheet files of the specified format.
	XlExpression	An object which can be used to specify a worksheet cell formula.
	XlFill	Contains the cell background attributes.
	XlFilterColumn	A column in the filter range to which filtering is applied.
	XlFont	Contains the cell font attributes.
	XlFontBase	Serves as a base for the XlFont class and specifies the common font characteristics.
	XlFormatting	Serves as a base for the XlCellFormatting class and provides properties to change cell format settings.
	XlFunc	Provides static methods used to construct an internal representation of an expression (an IXlFormulaParameter object).
	XlHeaderFooter	Represents the object that specifies headers and footers of a worksheet.
	XlHyperlink	Represents a hyperlink in a worksheet.
	XlHyperlinkBase	Serves as the base for the XlHyperlink and XlPictureHyperlink classes that define hyperlinks for cells and pictures.
	XlNumberFormat	Represents the object that specifies a cell number format.
	XlOper	A static class that implements methods to create arithmetic and logical operations in the IXlFormulaParameter expression.
	XlPageMargins	Represents the object that specifies page margins for a worksheet.
	XlPageSetup	Represents the object that specifies page formatting options.
	XlPictureHyperlink	Represents a hyperlink associated with a picture.
	XlPrintOptions	Represents the object that specifies printing options for a worksheet.
	XlPrintTitles	Represents the object that specifies rows and columns to be repeated on every printed page.
	XlRichTextRun	Represents a region of the cell text with its own set of font characteristics.
	XlRichTextString	Represents a rich formatted text in a cell.
	XlSparkline	A single sparkline in the sparkline group.
	XlSparklineGroup	A sparkline group in a worksheet.
	XlTableColumnInfo	Represents an object used to create a table column with custom formatting applied to its regions.
	XlTableReference	Represents a reference to table data.
	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.

Interfaces

	Interface	Description
	IXlCell	Represents a single cell in a worksheet.
	IXlCellError	Contains information about a cell error.
	IXlColumn	Represents a single column in a worksheet.
	IXlDocument	Represents an interface that exposes the specific functionality of a workbook.
	IXlDocumentOptions	Contains options related to culture-specific settings of a workbook and document format specifications and limits.
	IXlExporter	Represents an exporter used to create a spreadsheet document and export it to a stream.
	IXlFilterColumns	A collection of XlFilterColumn objects.
	IXlFilterCriteria	A base interface for classes that specify the filter criteria applied to worksheet and table columns.
	IXlFormulaParameter	An internal representation of an expression. Used to set the cell formula.
	IXlMergedCells	Represents a collection of merged cells in a worksheet.
	IXlOutlineProperties	Contains options used to specify the summary rows and columns location.
	IXlPageBreaks	A collection of page breaks in a worksheet.
	IXlPicture	Represents a picture embedded in a worksheet.
	IXlRow	Represents a single row in a worksheet.
	IXlSheet	Represents a worksheet in a workbook.
	IXlSheetSelection	Defines the cell selection within a worksheet.
	IXlSheetViewOptions	Provides access to a set of display options for a worksheet.
	IXlTable	Represents a table in a worksheet.
	IXlTableCollection	A read-only collection of tables contained in a worksheet.
	IXlTableColumn	Represents a single column in a table.
	IXlTableColumnCollection	A collection of columns in a table.
	IXlTableStyleInfo	Contains table style settings.

Structures

	Structure	Description
	XlAnchorPoint	Represents an anchor point used to position a picture in a worksheet.
	XlCellPosition	Defines the column, row and the reference type (relative or absolute).
	XlCustomPropertyValue	Represents the value of a custom document property.
	XlSourceRectangle	Specifies the portion of the picture to display in a worksheet.
	XlVariantValue	A variant value that can be used as a cell value, filter value or function argument.

Enumerations

	Enumeration	Description
	XlAnchorType	Lists anchoring types used to position an IXlPicture object in a worksheet or specifies how a picture should be moved and resized when a two cell anchoring is used.
	XlBorderLineStyle	Lists values used to specify the line styles for cell borders.
	XlCalendarType	Lists calendar types used to interpret filter values defined by the XlDateGroupItem instances.
	XlCellErrorType	Lists values used to specify the type of cell errors.
	XlColorType	Lists values used to specify the color type.
	XlCommentsPrintMode	Lists values used to specify how comments anchored to worksheet cells are printed.
	XlCondFmtAverageCondition	Lists the types of format operators used in the "Above or Below Average..." conditional formatting rule.
	XlCondFmtAxisPosition	List values that specify the axis position between negative and positive bars when the data bar conditional formatting is applied.
	XlCondFmtColorScaleType	Lists types of the color scale for the color scale conditional formatting rule.
	XlCondFmtIconSetType	Lists values that sets the icon set type for the icon set conditional format.
	XlCondFmtOperator	Lists the types of relational operators used in the conditional formatting rule.
	XlCondFmtSpecificTextType	List values specifying the type of the conditional format operator in a conditional formatting rule.
	XlCondFmtTimePeriod	Lists applicable time periods in a "date occurring..." conditional formatting rule.
	XlCondFmtType	Lists the types of the conditional formatting operators used in the conditional formatting rule.
	XlCondFmtValueObjectType	Lists values the specify the type of the threshold value to be used in conditional formatting rules
	XlDataBarDirection	Lists values that specify the direction of data bars when the data bar conditional format is applied.
	XlDataValidationErrorStyle	Lists the styles of the data validation error alerts.
	XlDataValidationImeMode	Lists values that specify how the input method editor (IME) is controlled by data validation.
	XlDataValidationOperator	Lists the types of operators that can be used in certain data validation types.
	XlDataValidationType	Lists the types of data validation.
	XlDateTimeGroupingType	Lists grouping types used to specify the filter criteria for DateTime values.
	XlDisplayBlanksAs	Lists values used to specify how empty cells are displayed on a sparkline.
	XlDocumentFormat	Lists values used to specify the document format.
	XlDocumentSecurity	Lists the security levels of the document.
	XlDocumentTheme	Lists values used to specify the document theme.
	XlDynamicFilterType	Lists the types of dynamic filter, i.e., a filter whose results may depend on the data to which it is applied or the current date.
	XlErrorsPrintMode	Lists values used to specify how cell errors are printed.
	XlExpressionStyle	Lists possible ways to interpret and calculate a formula in a worksheet.
	XlFilterOperator	Lists comparison operators used in a custom filter.
	XlFilterType	Lists types of filters available for the AutoFilter functionality.
	XlFontFamily	Lists values used to specify the font family to which a cell font may belong.
	XlFontSchemeStyles	Lists values used to specify the font scheme.
	XlHorizontalAlignment	Lists values used to specify the horizontal alignment of the cell content.
	XlIgnoreErrors	Lists the types of errors which occur in cell formulas and can be skipped using the IgnoreErrors property.
	XlPageOrientation	Lists values used to specify the page orientation applied when a worksheet is being printed.
	XlPagePrintOrder	Lists values used to specify the order in which worksheet pages are numbered and printed when the worksheet data does not fit on one page.
	XlPageUnits	Lists values used to specify the units of margin measurement.
	XlPatternType	Lists the types of patterns available for cell shading.
	XlPositionType	Lists reference types used to specify a cell position.
	XlReadingOrder	Lists values used to specify the reading order of the cell.
	XlScriptType	Lists values used to format the text in a cell as superscript or subscript.
	XlSheetVisibleState	Lists values used to specify the worksheet visibility.
	XlSparklineAxisScaling	Lists values used to specify how to calculate the minimum and maximum values for the vertical axis of a sparkline group.
	XlSparklineType	Lists values used to specify sparkline chart types (types of sparkline groups).
	XlSummary	Lists summary functions used in subtotals.
	XlTablePart	Lists special item specifiers used within structured references to refer to specific parts of a table or table column(s).
	XlThemeColor	Lists the base colors of the document theme.
	XlTotalRowFunction	Lists functions to calculate the totals of table columns.
	XlUnderlineType	Lists underline styles.
	XlVariantValueType	Lists values used to specify a variant value type.
	XlVerticalAlignment	Lists values used to specify the vertical alignment of the cell content.

Is this topic helpful?