C1.Excel Namespace | ComponentOne Excel for .NET

C1.Excel Namespace

In This Topic

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.
	Strings	Static class containing UI strings used by the project.
	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 C1XLBook.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.

Delegates

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

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.
	ImageFormat	Specifies how images are scaled within spreadsheet cells.
	ImageScaling	Specifies how images are scaled within spreadsheet cells.
	IMEModeType	Specifies the description of the Japanese input rules.
	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 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.
	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.

Reference

C1.Excel Assembly