ComponentOne Excel for .NET
C1.Excel Assembly / C1.Excel Namespace
Inheritance Hierarchy
In This Topic
    C1.Excel Namespace
    In This Topic
    Classes
     ClassDescription
    ClassC1XLBook

    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.

    ClassShapeCollection Represents a collection of XLShape objects on an XLSheet.
    ClassXLBorderFormatting The border formatting.
    ClassXLCell Represents individual cells in an XLSheet and provides properties for getting and setting the cell Value, Style, and Hyperlink.
    ClassXLCellRange Represents a range of XLCell objects in an XLSheet.
    ClassXLCellRangeCollection Represents a collection of XLCellRange objects on an XLSheet.
    ClassXLColumn Represents a column in a worksheet. This class provides properties for setting the column's width, style, and visibility.
    ClassXLColumnCollection Represents a collection of XLColumn objects that represent the individual columns in each XLSheet.
    ClassXLComment Represents a comment associated with a cell.
    ClassXLCommentCollection Represents a collection of XLComment objects in a XLSheet.
    ClassXLCommentShape Represents a text shape embedded in an XLSheet.
    ClassXLConditionalFormatting Conditional formatting.
    ClassXLConditionalFormattingCollection The collection of conditional formatting ranges.
    ClassXLConditionalFormattingRangeCollection The collection of conditional formatting ranges.
    ClassXLConditionalFormattingRule Conditional formatting.
    ClassXLConditionalFormattingRuleCollection The collection of conditional formatting ranges.
    ClassXLDataValidation Data validation.
    ClassXLDataValidationCollection The collection of conditional formatting ranges.
    ClassXLDataValidationRangeCollection The collection of conditional formatting ranges.
    ClassXLFont XLFont
    ClassXLFontFormatting The font formatting.
    ClassXLNamedRange Represents a named range of XLCell objects on one or several worksheets.
    ClassXLNamedRangeCollection Represents a collection of XLNamedRange objects.
    ClassXLOpaqueShape Represents a shape that was inserted in the sheet using Excel and is preserved but not fully exposed by the C1XLBook component.
    ClassXLPatternFormatting The pattern formatting.
    ClassXLPictureShape Represents an Image embedded in an XLSheet.
    ClassXLPrintSettings Provides options and settings for printing XLSheet objects.
    ClassXLProgressEventArgs Provides data for the C1XLBook.Progress event of a C1XLBook.
    ClassXLRange The simple cell range.
    ClassXLRow Represents a row in a worksheet, provides properties for setting the row's height, style, and visibility.
    ClassXLRowCollection Represents a collection of XLRow objects that represent the individual rows in each XLSheet.
    ClassXLShape Represents a shape embedded in an XLSheet.
    ClassXLSheet Represents individual worksheets in an Excel workbook (C1XLBook).
    ClassXLSheetCollection Collection of XLSheet objects that represent the individual worksheets in a C1XLBook.
    ClassXLStyle Contains style elements used to define the appearance of the cells.
    ClassXLTextShape Represents a common text shape embedded in an XLSheet.
    Delegates
     DelegateDescription
    DelegateXLProgressEventHandler Represents the method that will handle the C1XLBook.Progress event of a C1XLBook.
    Enumerations
     EnumerationDescription
    EnumerationCalculationMode Specifies calculation mode for all formulas in the workbook.
    EnumerationCompatibilityMode Specifies limits to sheet size that correspond to specific versions of Microsoft Excel.
    EnumerationConsolidationFunction Specifies consolidation function for sheet subtotals.
    EnumerationFileFormat Specifies the file format to use when loading or saving workbooks.
    EnumerationImageFormat Specifies how images are scaled within spreadsheet cells.
    EnumerationImageScaling Specifies how images are scaled within spreadsheet cells.
    EnumerationIMEModeType Specifies the description of the Japanese input rules.
    EnumerationViewLayout Specifies variant of view layout (preview).
    EnumerationXLAlignHorz Specifies how to align cell content horizontally within a cell.
    EnumerationXLAlignVert Specifies how to align cell content vertically within a cell.
    EnumerationXLComparisonOperator Comparison operator (applicable when cell type formating).
    EnumerationXLConditionalFormattingOperator Conditional formatting operator (applicable when cell type formating).
    EnumerationXLConditionalFormattingType Conditional formatting type.
    EnumerationXLDiagonalFlags Specifies the type of diagonal line to draw across the cells.
    EnumerationXLErrorStyle Error style (status).
    EnumerationXLFontScript The Excel font superscript/subscript style (escapement type).
    EnumerationXLHorizTextAlign Specifies horizontal text alignment.
    EnumerationXLLineStyle Specifies the line style used for the cell borders.
    EnumerationXLPattern Specifies the pattern used to fill the cell background.
    EnumerationXLPictureViewType Specifies how images should be displayed (color, gray-scale, or black and white).
    EnumerationXLRangeType The range type.
    EnumerationXLReadingDirection Specifies the reading direction (East Asian versions of MS Excel).
    EnumerationXLReferenceMode The Excel reference mode (A1 or R1C1).
    EnumerationXLReferenceType The reference type.
    EnumerationXLShapeDashedLineStyle Specifies the dash style of borders drawn around XLShape objects.
    EnumerationXLShapeLineStyle Specifies the style of borders drawn around XLShape objects.
    EnumerationXLTextOrientation Specifies text orientation.
    EnumerationXLUnderlineStyle Conditional formatting underline type for the font.
    EnumerationXLValidationType Specifies the type of validation test to be performed in conjunction with values.
    EnumerationXLVertTextAlign Specifies vertical text alignment.
    See Also

    Reference

    C1.Excel Assembly