[]
        
(Showing Draft Content)

C1.WPF.Excel

C1.WPF.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.

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.

Interfaces

ICloneable

Supports cloning, which creates a new instance of a class with the same value as an existing instance.

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.

ConsolidationFunction

Specifies consolidation function for sheet subtotals.

FileFormat

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

IMEModeType

Specifies the description of the Japanese input rules.

ImageScaling

Specifies how images are scaled within spreadsheet cells.

ViewLayout

Specifies variant of view layout (preview).

XLAlignHorzEnum

Specifies how to align cell content horizontally within a cell.

XLAlignVertEnum

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 formating).

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.

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, 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.

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

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.