DevExpress.Export.Xl Namespace
Contains classes and interfaces that constitute the Excel Export Library used for generating spreadsheet files.
Assembly: DevExpress.Printing.v24.2.Core.dll
NuGet Package: DevExpress.Printing.Core
#Classes
Name | Description |
---|---|
Xl |
Provides access to the line characteristics of a cell border. |
Xl |
Serves as a base for the Xl |
Xl |
Lists built-in styles similar to Excel’s built-in table styles. |
Xl |
Contains alignment settings for a cell. |
Xl |
Represents the object that specifies cell format characteristics. |
Xl |
Defines a range of cells. |
Xl |
Represents a color used in the spreadsheet document. |
Xl |
A filter by cell fill or font color. |
Xl |
Provides access to the particular icon in the custom icon set. |
Xl |
Base class for the conditional formatting rules. |
Xl |
Represents the “Above or Below Average…” conditional formatting rule. |
Xl |
Represents the conditional formatting rule that highlights blank/non-blank cells. |
Xl |
Represents the conditional formatting rule that uses the relational operator. |
Xl |
Represents the Color Scale conditional formatting rule. |
Xl |
Represents the Data Bar conditional formatting rule. |
Xl |
Represents the conditional formatting rule for cells with duplicate values. |
Xl |
Represents the conditional formatting rule that uses a relational operator to determine which cells to format. |
Xl |
Represents the Icon Set conditional formatting rule. |
Xl |
Represents “A Text That Contains…” conditional formatting rule. |
Xl |
Represents the “Date Occurring…” conditional formatting rule. |
Xl |
Represents the “Top/Bottom N” conditional formatting rule. |
Xl |
Represents the conditional formatting rule for cells with unique values. |
Xl |
Provides formatting settings for the conditional formatting rules. |
Xl |
Represents a minimum or maximum threshold for a conditional formatting rule. |
Xl |
Represents the worksheet ranges and conditional formatting rules applied to them. |
Xl |
Specifies a criterion value and comparison operator for a custom filter. |
Xl |
A custom filter that uses filter values and comparison operators to construct the filter expression. |
Xl |
Represents the data validation rule defined for a current worksheet. |
Xl |
A group of dates or times used in the filter criteria. |
Xl |
Contains custom document properties associated with a workbook. |
Xl |
Contains basic document properties associated with a workbook. |
Xl |
Contains display options for the workbook. |
Xl |
A dynamic filter that shows dates that fall within a specified time period or displays values that are above or below the average. |
Xl |
Represents an object that creates an exporter for generating spreadsheet files of the specified format. |
Xl |
An object which can be used to specify a worksheet cell formula. |
Xl |
Contains the cell background attributes. |
Xl |
A column in the filter range to which filtering is applied. |
Xl |
Contains the cell font attributes. |
Xl |
Serves as a base for the Xl |
Xl |
Serves as a base for the Xl |
Xl |
Provides static methods used to construct an internal representation of an expression (an IXl |
Xl |
Represents the object that specifies headers and footers of a worksheet. |
Xl |
Represents a hyperlink in a worksheet. |
Xl |
Serves as the base for the Xl |
Xl |
Represents the object that specifies a cell number format. |
Xl |
A static class that implements methods to create arithmetic and logical operations in the IXl |
Xl |
Represents the object that specifies page margins for a worksheet. |
Xl |
Represents the object that specifies page formatting options. |
Xl |
Represents a hyperlink associated with a picture. |
Xl |
Represents the object that specifies printing options for a worksheet. |
Xl |
Represents the object that specifies rows and columns to be repeated on every printed page. |
Xl |
Represents a region of the cell text with its own set of font characteristics. |
Xl |
Represents a rich formatted text in a cell. |
Xl |
A single sparkline in the sparkline group. |
Xl |
A sparkline group in a worksheet. |
Xl |
Represents an object used to create a table column with custom formatting applied to its regions. |
Xl |
Represents a reference to table data. |
Xl |
A Top 10 filter that displays top/bottom ranked values. |
Xl |
An object that can be used to create a criterion for data validation and as a threshold value specified in the conditional formatting rule. |
Xl |
A filter by a list of cell values or date and time values. |
#Interfaces
Name | Description |
---|---|
IXl |
Represents a single cell in a worksheet. |
IXl |
Contains information about a cell error. |
IXl |
Represents a single column in a worksheet. |
IXl |
Represents an interface that exposes the specific functionality of a workbook. |
IXl |
Contains options related to culture-specific settings of a workbook and document format specifications and limits. |
IXl |
Represents an exporter used to create a spreadsheet document and export it to a stream. |
IXl |
A collection of Xl |
IXl |
A base interface for classes that specify the filter criteria applied to worksheet and table columns. |
IXl |
An internal representation of an expression. Used to set the cell formula. |
IXl |
Represents a collection of merged cells in a worksheet. |
IXl |
Contains options used to specify the summary rows and columns location. |
IXl |
A collection of page breaks in a worksheet. |
IXl |
Represents a picture embedded in a worksheet. |
IXl |
Represents a single row in a worksheet. |
IXl |
Represents a worksheet in a workbook. |
IXl |
Defines the cell selection within a worksheet. |
IXl |
Provides access to a set of display options for a worksheet. |
IXl |
Represents a table in a worksheet. |
IXl |
A read-only collection of tables contained in a worksheet. |
IXl |
Represents a single column in a table. |
IXl |
A collection of columns in a table. |
IXl |
Contains table style settings. |
#Structs
Name | Description |
---|---|
Xl |
Represents an anchor point used to position a picture in a worksheet. |
Xl |
Defines the column, row and the reference type (relative or absolute). |
Xl |
Represents the value of a custom document property. |
Xl |
Specifies the portion of the picture to display in a worksheet. |
Xl |
A variant value that can be used as a cell value, filter value or function argument. |
#Enums
Name | Description |
---|---|
Xl |
Lists anchoring types used to position an IXl |
Xl |
Lists values used to specify the line styles for cell borders. |
Xl |
Lists calendar types used to interpret filter values defined by the Xl |
Xl |
Lists values used to specify the type of cell errors. |
Xl |
Lists values used to specify the color type. |
Xl |
Lists values used to specify how comments anchored to worksheet cells are printed. |
Xl |
Lists the types of format operators used in the “Above or Below Average…” conditional formatting rule. |
Xl |
List values that specify the axis position between negative and positive bars when the data bar conditional formatting is applied. |
Xl |
Lists types of the color scale for the color scale conditional formatting rule. |
Xl |
Lists values that sets the icon set type for the icon set conditional format. |
Xl |
Lists the types of relational operators used in the conditional formatting rule. |
Xl |
List values specifying the type of the conditional format operator in a conditional formatting rule. |
Xl |
Lists applicable time periods in a “date occurring…” conditional formatting rule. |
Xl |
Lists the types of the conditional formatting operators used in the conditional formatting rule. |
Xl |
Lists values the specify the type of the threshold value to be used in conditional formatting rules |
Xl |
Lists values that specify the direction of data bars when the data bar conditional format is applied. |
Xl |
Lists the styles of the data validation error alerts. |
Xl |
Lists values that specify how the input method editor (IME) is controlled by data validation. |
Xl |
Lists the types of operators that can be used in certain data validation types. |
Xl |
Lists the types of data validation. |
Xl |
Lists grouping types used to specify the filter criteria for Date |
Xl |
Lists values used to specify how empty cells are displayed on a sparkline. |
Xl |
Lists values used to specify the document format. |
Xl |
Lists the security levels of the document. |
Xl |
Lists values used to specify the document theme. |
Xl |
Lists the types of dynamic filter, i. |
Xl |
Lists values used to specify how cell errors are printed. |
Xl |
Lists possible ways to interpret and calculate a formula in a worksheet. |
Xl |
Lists comparison operators used in a custom filter. |
Xl |
Lists types of filters available for the Auto |
Xl |
Lists values used to specify the font family to which a cell font may belong. |
Xl |
Lists values used to specify the font scheme. |
Xl |
Lists values used to specify the horizontal alignment of the cell content. |
Xl |
Lists the types of errors which occur in cell formulas and can be skipped using the IXl |
Xl |
Lists values used to specify the page orientation applied when a worksheet is being printed. |
Xl |
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. |
Xl |
Lists values used to specify the units of margin measurement. |
Xl |
Lists the types of patterns available for cell shading. |
Xl |
Lists reference types used to specify a cell position. |
Xl |
Lists values used to specify the reading order of the cell. |
Xl |
Lists values used to format the text in a cell as superscript or subscript. |
Xl |
Lists values used to specify the worksheet visibility. |
Xl |
Lists values used to specify how to calculate the minimum and maximum values for the vertical axis of a sparkline group. |
Xl |
Lists values used to specify sparkline chart types (types of sparkline groups). |
Xl |
Lists summary functions used in subtotals. |
Xl |
Lists special item specifiers used within structured references to refer to specific parts of a table or table column |
Xl |
Lists the base colors of the document theme. |
Xl |
Lists functions to calculate the totals of table columns. |
Xl |
Lists underline styles. |
Xl |
Lists values used to specify a variant value type. |
Xl |
Lists values used to specify the vertical alignment of the cell content. |