Classes

  Class Description
Public class 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.
Public class XLBorderFormatting
The border formatting.
Public class XLCell
Represents individual cells in an XLSheet and provides properties for getting and setting the cell Value, Style, and Hyperlink.
Public class XLCellRange
Represents a range of XLCell objects in an XLSheet.
Public class XLCellRangeCollection
Represents a collection of XLCellRange objects on an XLSheet.
Public class XLColumn
Represents a column in a worksheet. This class provides properties for setting the column's width, style, and visibility.
Public class XLColumnCollection
Represents a collection of XLColumn objects that represent the individual columns in each XLSheet.
Public class XLConditionalFormatting
Conditional formatting.
Public class XLConditionalFormattingCollection
The collection of conditional formattin ranges.
Public class XLConditionalFormattingRangeCollection
The collection of conditional formatting ranges.
Public class XLConditionalFormattingRule
Conditional formatting.
Public class XLConditionalFormattingRuleCollection
The collection of conditional formattin ranges.
Public class XLFont
XLFont
Public class XLFontFormatting
The font formatting.
Public class XLNamedRange
Represents a named range of XLCell objects on one or several worksheets.
Public class XLNamedRangeCollection
Represents a collection of XLNamedRange objects.
Public class XLPatternFormatting
The pattern formatting.
Public class XLPrintSettings
Provides options and settings for printing XLSheet objects.
Public class XLRange
The simple cell range.
Public class XLRow
Represents a row in a worksheet, provides properties for setting the row's height, style, and visibility.
Public class XLRowCollection
Represents a collection of XLRow objects that represent the individual rows in each XLSheet.
Public class XLSheet
Represents individual worksheets in an Excel workbook (C1XLBook).
Public class XLSheetCollection
Collection of XLSheet objects that represent the individual worksheets in a C1XLBook.
Public class XLStyle
Contains style elements used to define the appearance of the cells.

Interfaces

  Interface Description
Public interface ICloneable
Supports cloning, which creates a new instance of a class with the same value as an existing instance.

Enumerations

  Enumeration Description
Public enumeration CalculationMode
Specifies calculation mode for all formulas in the workbook.
Public enumeration CompatibilityMode
Specifies limits to sheet size that correspond to specific versions of Microsoft Excel.
Public enumeration ConsolidationFunction
Specifies consolidation function for sheet subtotals.
Public enumeration FileFormat
Specifies the file format to use when loading or saving workbooks.
Public enumeration XLAlignHorzEnum
Specifies how to align cell content horizontally within a cell.
Public enumeration XLAlignVertEnum
Specifies how to align cell content vertically within a cell.
Public enumeration XLConditionalFormattingOperator
Conditional formatting operator (applicable when cell type formating).
Public enumeration XLConditionalFormattingType
Conditional formatting type.
Public enumeration XLDiagonalFlags
Specifies the type of diagonal line to draw across the cells.
Public enumeration XLEscapementType
Conditional formatting escapement type for the font.
Public enumeration XLFontScript
The Excel font superscript/subscript style.
Public enumeration XLLineStyleEnum
Specifies the line style used for the cell borders.
Public enumeration XLPatternEnum
Specifies the pattern used to fill the cell background.
Public enumeration XLRangeType
The range type.
Public enumeration XLReadingDirection
Specifies the reading direction (East Asian versions of MS Excel).
Public enumeration XLReferenceMode
The reference mode.
Public enumeration XLReferenceType
The reference type.
Public enumeration XLUnderlineStyle
The Excel font underline style.
Public enumeration XLUnderlineType
Conditional formatting underline type for the font.