Classes
| 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. |
| ShapeCollection | Represents a collection of XLShape objects on an XLSheet. |
| 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. |
| XLComment | Represents a comment associated with a cell. |
| XLCommentCollection | Represents a collection of XLComment objects in a XLSheet. |
| XLCommentShape | Represents a text shape embedded in an 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. |
| XLPictureShape | Represents an Image embedded in an XLSheet. |
| 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. |
| XLShape | Represents a shape embedded in an 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. |
| XLTextShape | Represents a common text shape embedded in an XLSheet. |
Interfaces
| Interface | Description | |
|---|---|---|
 | ICloneable | Supports cloning, which creates a new instance of a class with the same value as an existing instance. |
Enumerations
| 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. |
| ImageScaling | Specifies how images are scaled within spreadsheet cells. |
| 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. |
| XLEscapementType | Conditional formatting escapement type for the font. |
| XLFontScript | The Excel font superscript/subscript style. |
| XLHorizTextAlign | Specifies horizontal text alignment. |
| XLLineStyleEnum | Specifies the line style used for the cell borders. |
| XLPatternEnum | Specifies the pattern used to fill the cell background. |
| XLPictureViewType | Specifies how images should be displayed (color, grayscale, or black and white). |
| XLRangeType | The range type. |
| XLReadingDirection | Specifies the reading direction (East Asian versions of MS Excel). |
| XLReferenceMode | The reference mode. |
| XLReferenceType | The reference type. |
| XLShapeDashedLineStyleEnum | Specifies the dash style of borders drawn around XLShape objects. |
| XLShapeLineStyleEnum | Specifies the style of borders drawn around XLShape objects. |
| XLTextOrientation | Specifies text orientation. |
| XLUnderlineStyle | The Excel font underline style. |
| XLUnderlineType | Conditional formatting underline type for the font. |
| XLVertTextAlign | Specifies vertical text alignment. |
See Also