Xceed.Workbooks.NET Namespace

This is the base assembly used by Xceed Workbooks for .NET.

Classes

	Class	Description
	Alignment	An alignment represents the horizontal and vertical alignment used to align the content of a Cell. Alignment is available through these properties: Cell.Style, Row.Style or Column.Style.
	Annotation	Base class that contains the basic components for Notes & Comments.
	AnnotationCollection	Represents a collection of all the Notes and ThreadCommentCollections in the Worksheet.
	AutoFilter	An AutoFilter represents the object controlling the filtering process in a Table. It offers properties to display the filtering buttons and customize the filtering process on TableColumns.
	Border	Defines the content of a specific border.
	BorderCollection	Defines the collection of Borders for a Style.
	Cell	A cell represents a rectangle in a Worksheet. Each cell is the intersection of a Row and a Column. It can be accessed by using an address (a combination of a letter and a number, like A1, B2, C3…, where the letter is the Column Id and the number is the Row Id) or by coordinates (by specifying the Row Id first & then the Column Id, for example, 0,0; 2,3; 5;5...). Note that indexes for rows & columns always start at 0.
	CellCollection	Represents a collection of Cell.
	CellHelper	Offers some static functions for converting data.
	CellRange	Represents a rectangular range of Cells. The top-left and bottom-right Cells delimit the range.
	ColorHelper	Contains many methods that will help convert Colors between Color, int, string and ThemeColor.
	Column	Represents a column in a Worksheet.
	ColumnCellCollection	This collection represents the collection of Cell for a specific column.
	ColumnCollection	Represents a collection of Column in a worksheet.
	ColumnRange	Defines a ColumnRange, which is a range of consecutives Columns. It derives from LinearRange.
	Comment	This class represents a single Comment in a ThreadCommentCollection.
	CSVImportOptions	Specifies the properties of the import options for a CSV document or stream when importing data in a Worksheet through the Worksheet.ImportData method.
	DataTableImportOptions	Specifies the properties of the import options for DataTables when importing data in a Worksheet through the Worksheet.ImportData method.
	DrawingClientData	This class is used to enable or disable the selection and printing of the elements within the worksheet when it is protected.
	Fill	Contains the properties related to filling a Cell, Row, Column or range with a Color and a pattern.
	Font	The Font object representing the possible properties that a font can have.
	FormattedText	Represents a text that is formatted in a specific way.
	FormattedTextList	Represents a list of FormattedText objects.
	Hyperlink	Encapsulates the object that represents an hyperlink.
	HyperlinkCollection	Represents a collection of Hyperlinks in a Worksheet.
	ImportOptions	Specifies the import options' properties when importing data in a Worksheet through the Worksheet.ImportData method.
	Licenser	Represents the class used to register all classes defined in the Xceed.Workbooks.NET assembly.
	LinearRange<T>	Abstract class defining a LinearRange, which is a range of consecutives WorksheetElements.
	LinearWorksheetElement	Contains the common elements for the Column and Row classes.
	MergedCellCollection	Represents a collection of all the Cells that need to be merged.
	Note	Represents a Note, which is made of multiple blocks of FormattedText that are added one after the other.
	NoteProtection	Contains the Protection properties of a Note.
	Person	Represents the person who interacted with an object that requires identification.
	Picture	This class represents a picture element in the PictureCollection of the Worksheet.
	PictureCollection	This class will contain all the pictures in the worksheet. It will also allow the user to add new pictures and manipulate them.
	PictureLocks	Allows the user to remove the authorization to modify certain properties of the picture in MS Excel. All values are false by default.
	Position	Manages the values of properties that are unit dependent, like AbsoluteAnchor, TopLeftOffsets and BottomRightOffsets.
	Protection	Represents the possible properties of a Protection.
	ProtectionBase	Contains the base data for a Protection.
	RangeBase<T>	Contains the base data for a range.
	Row	Represents a row in a Worksheet.
	RowCellCollection	This collection represents the collection of Cell for a specific row.
	RowCollection	Represents a collection of Row in a worksheet.
	RowRange	Defines a range of consecutives Rows.
	SheetView	A single sheet view from a Worksheet. Currently, only one SheetView per Worksheet is supported.
	Style	Represents the style that is used to display either a Cell, Cells from a Column or Cells from a Row.
	StyleBase<T>	A generic base class for styled objects like Style, Fill, Font and Alignment.
	StyledRange<T>	Contains the base data for a range.
	StyledWorksheetElement	Abstract class that contains a Style property for worksheet elements.
	Table	A Table represents a range of cells in a Worksheet. To be considered a Table, these cells should be independent from the other cells in the Worksheet and grouped to form a rectangular arrangement of rows and columns. Built-in styles can be used to unify these grouped cells visually. The Table’s header row can display filtering options for each column. A total row can also be added. Each cell of this row will display a formula calculation based on the data in that column (SUM, AVERAGE, COUNT…).
	TableCollection	Represents a collection of Table in a Worksheet.
	TableColumn	Represents a column from a Table in a Worksheet.
	TableColumnCollection	Represents a collection of TableColumn in a Table.
	Theme	Contains the properties and methods of a Theme object.
	ThemeColor	Represents a Theme's Color.
	ThreadCommentCollection	Contains a collection of the various threads of Comments that can be found in the Worksheet.
	UserObjectImportOptions	Specifies the properties of the import options for user objects when importing data in a Worksheet through the Worksheet.ImportData method.
	Workbook	Represents the root document containing the Worksheet(s).
	WorkbookElement	This is the base class for all single elements in a Workbook.
	WorkbookProtection	Represents the Protection used on a Workbook.
	WorkbookThemeColor	Gets the ThemeColor associated with the Workbook's Theme.
	WorkbookThemeColors	The collection of ThemeColors associated to the current Theme used by the Workbook.
	WorkbookView	Each WorkbookView opens a new window when the document is opened. This allows the user to focus on an important element of the document by displaying it in a different window.
	Worksheet	Represents a single worksheet from a Workbook.
	WorksheetCollection	Represents a collection of Worksheet in a Workbook.
	WorksheetElement	This is the base class for all single elements in a Worksheet.
	WorksheetProtection	Contains the actions that can be carried out on a Worksheet when it is protected.
	WorksheetRange	Corresponds to a group of continuous Worksheets in a WorksheetCollection.

Interfaces

	Interface	Description
	IRangeBase<T>	Offers the base properties for a range.
	IReadonlyAlignment	Interface exposing the properties and methods of a read-only Alignment object.
	IReadonlyBorder	Interface exposing the properties and methods of a read-only Border object.
	IReadonlyFill	Interface exposing the properties and methods of a read-only Fill object.
	IReadonlyFont	Interface exposing the properties and methods of a read-only Font object.
	IReadonlyProtection	Interface exposing the properties and methods of a read-only Protection object.
	IReadonlyStyle	Interface exposing the properties and methods of a read-only Style object.
	IReadonlyThemeColor	Represents the available properties of a read-only ThemeColor object.
	IReadonlyWorkbookProtection	Contains, in their read-only version, the actions that can be carried out on a Workbook when it is protected.
	IReadonlyWorksheetProtection	Contains, in their read-only version, the actions that can be carried out on a Worksheet when it is protected.

Enumerations

	Enumeration	Description
	Anchor	Determines how a Picture is anchored in a Worksheet.
	AnnotationType	Determines the Annotation's type.
	BorderType	Defines the Border's type.
	BuiltinStyleType	Represents the different types of built-in Cell Styles offered by MS Excel.
	ClearOptions	Contains the options that determine what will be cleared when one of the Clear methods is used on a Row, Column, Worksheet or Range.
	DataType	Determines the type of data entered in a Cell.
	DeleteRangeShiftType	Determines how Cells are shifted after a CellRange is deleted.
	FillPattern	Represents the possible values for a pattern style when a Fill object is used to fill a Cell, Row, Column or range.
	HorizontalAlignment	Specifies the types of horizontal alignments possible for a cell.
	HyperlinkType	Defines the hyperlink's type.
	InsertRangeShiftType	Determines how Cells are shifted after inserting a CellRange.
	LineStyle	Defines the style of a Border.
	PictureFormat	Represents the available picture format.
	TableStyle	Specifies the built-in style used on a Table. The available styles are the same as the ones found in MS Excel.
	TextDirectionAlignment	Determines how the text will flow.
	ThemeColorType	The available types for the ThemeColor class.
	TotalRowFunction	This enum can be used to set the TableColumn.TotalRowFunction property. It will be used to apply a built-in formula in a TableColumn’s total row.
	TwoCellAnchorBehavior	Affects the behavior of a TwoCellAnchor Picture when adding and deleting Rows and Columns.
	UnderlineType	Defines the possible type of underline.
	Units	Determines what type of units are used for measurements.
	VerticalAlignment	Specifies the types of vertical alignments possible for a cell.
	WorksheetViewType	Determines which View mode is used by a SheetView.
	WorksheetVisibility	Determines how the Worksheet is displayed.

Reference

Xceed.Workbooks.NET Assembly