DevExpress.Export.Xl Namespace
Contains classes and interfaces that constitute the Excel Export Library used for generating spreadsheet files.
Assembly: DevExpress.Printing.v18.1.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. |
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. |
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. |