Class | Description | |
---|---|---|
C1XLBook | Represents an Excel workbook containing one or more worksheets. Contains methods for loading and saving XLS files, and exposes a collection of XLSheet objects that represent the individual worksheets. | |
XLBorderFormatting | The border formatting. | |
XLCell | Represents individual cells in an XLSheet and provides properties for getting and setting the cell Value, Style, and Hyperlink. | |
XLCellRange | Represents a range of XLCell objects in an XLSheet. | |
XLCellRangeCollection | Represents a collection of XLCellRange objects on an XLSheet. | |
XLColumn | Represents a column in a worksheet. This class provides properties for setting the column's width, style, and visibility. | |
XLColumnCollection | Represents a collection of XLColumn objects that represent the individual columns in each XLSheet. | |
XLConditionalFormatting | Conditional formatting. | |
XLConditionalFormattingCollection | The collection of conditional formattin ranges. | |
XLConditionalFormattingRangeCollection | The collection of conditional formatting ranges. | |
XLConditionalFormattingRule | Conditional formatting. | |
XLConditionalFormattingRuleCollection | The collection of conditional formattin ranges. | |
XLFont | XLFont | |
XLFontFormatting | The font formatting. | |
XLNamedRange | Represents a named range of XLCell objects on one or several worksheets. | |
XLNamedRangeCollection | Represents a collection of XLNamedRange objects. | |
XLPatternFormatting | The pattern formatting. | |
XLPrintSettings | Provides options and settings for printing XLSheet objects. | |
XLRange | The simple cell range. | |
XLRow | Represents a row in a worksheet, provides properties for setting the row's height, style, and visibility. | |
XLRowCollection | Represents a collection of XLRow objects that represent the individual rows in each XLSheet. | |
XLSheet | Represents individual worksheets in an Excel workbook (C1XLBook). | |
XLSheetCollection | Collection of XLSheet objects that represent the individual worksheets in a C1XLBook. | |
XLStyle | Contains style elements used to define the appearance of the cells. |
Interface | Description | |
---|---|---|
ICloneable | Supports cloning, which creates a new instance of a class with the same value as an existing instance. |
Enumeration | Description | |
---|---|---|
CalculationMode | Specifies calculation mode for all formulas in the workbook. | |
CompatibilityMode | Specifies limits to sheet size that correspond to specific versions of Microsoft Excel. | |
ConsolidationFunction | Specifies consolidation function for sheet subtotals. | |
FileFormat | Specifies the file format to use when loading or saving workbooks. | |
XLAlignHorzEnum | Specifies how to align cell content horizontally within a cell. | |
XLAlignVertEnum | Specifies how to align cell content vertically within a cell. | |
XLConditionalFormattingOperator | Conditional formatting operator (applicable when cell type formating). | |
XLConditionalFormattingType | Conditional formatting type. | |
XLDiagonalFlags | Specifies the type of diagonal line to draw across the cells. | |
XLFontScript | The Excel font superscript/subscript style (escapement type). | |
XLLineStyleEnum | Specifies the line style used for the cell borders. | |
XLPatternEnum | Specifies the pattern used to fill the cell background. | |
XLRangeType | The range type. | |
XLReadingDirection | Specifies the reading direction (East Asian versions of MS Excel). | |
XLReferenceMode | The reference mode. | |
XLReferenceType | The reference type. | |
XLUnderlineStyle | Conditional formatting underline type for the font. |