DevExpress.Export.Xl Namespace

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

Assembly: DevExpress.Printing.v19.2.Core.dll

Classes

Name 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 static 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 static 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 static 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.
XlValueObject An object that can be used to create a criterion for data validation and as a threshold value specified in the conditional formatting rule.
XlValuesFilter A filter by a list of cell values or date and time values.

Interfaces

Name 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.

Structs

Name 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.

Enums

Name 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 IXlSheet.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.