[]
        
(Showing Draft Content)

C1.Excel

C1.Excel Namespace

Classes

C1XLBook

<p>Represents an Excel workbook containing one or more worksheets.</p>
<p>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 formatting ranges.

XLConditionalFormattingRangeCollection

The collection of conditional formatting ranges.

XLConditionalFormattingRule

Conditional formatting.

XLConditionalFormattingRuleCollection

The collection of conditional formatting ranges.

XLDataValidation

Data validation.

XLDataValidationCollection

The collection of conditional formatting ranges.

XLDataValidationRangeCollection

The collection of conditional formatting ranges.

XLExternalBook

Represents a external workbook.

XLExternalBookCollection

Collection of XLExternalBook objects that represent the individual worksheets in a C1XLBook.

XLExternalSheet

Represents a external workbook.

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.

XLOpaqueShape

Represents a shape that was inserted in the sheet using Excel and is preserved but not fully exposed by the C1XLBook component.

XLPatternFormatting

The pattern formatting.

XLPictureShape

Represents an Image embedded in an XLSheet.

XLPrintSettings

Provides options and settings for printing XLSheet objects.

XLProgressEventArgs

Provides data for the Progress event of a C1XLBook.

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.

Structs

XLExternalData

Represents a external data.

Enums

CalculationMode

Specifies calculation mode for all formulas in the workbook.

CompatibilityMode

Specifies limits to sheet size that correspond to specific versions of Microsoft Excel.

FileFormat

Specifies the file format to use when loading or saving workbooks.

IMEModeType

Specifies the description of the Japanese input rules.

ImageFormat

Specifies how images are scaled within spreadsheet cells.

ImageScaling

Specifies how images are scaled within spreadsheet cells.

ViewLayout

Specifies variant of view layout (preview).

XLAlignHorz

Specifies how to align cell content horizontally within a cell.

XLAlignVert

Specifies how to align cell content vertically within a cell.

XLComparisonOperator

Comparison operator (applicable when cell type formating).

XLConditionalFormattingOperator

Conditional formatting operator (applicable when cell type formatting).

XLConditionalFormattingType

Conditional formatting type.

XLDiagonalFlags

Specifies the type of diagonal line to draw across the cells.

XLErrorStyle

Error style (status).

XLFontScript

The Excel font superscript/subscript style (escapement type).

XLHorizTextAlign

Specifies horizontal text alignment.

XLLineStyle

Specifies the line style used for the cell borders.

XLPattern

Specifies the pattern used to fill the cell background.

XLPictureViewType

Specifies how images should be displayed (color, gray-scale, or black and white).

XLRangeType

The range type.

XLReadingDirection

Specifies the reading direction (East Asian versions of MS Excel).

XLReferenceMode

The Excel reference mode (A1 or R1C1).

XLReferenceType

The reference type.

XLShapeDashedLineStyle

Specifies the dash style of borders drawn around XLShape objects.

XLShapeLineStyle

Specifies the style of borders drawn around XLShape objects.

XLTextOrientation

Specifies text orientation.

XLUnderlineStyle

Conditional formatting underline type for the font.

XLValidationType

Specifies the type of validation test to be performed in conjunction with values.

XLVertTextAlign

Specifies vertical text alignment.

Delegates

XLProgressEventHandler

Represents the method that will handle the Progress event of a C1XLBook.