| 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. |
| DataValidation | Represents the data validation process used to validate the content of a Cell. |
| DataValidationCollection | The collection of DataValidations found in the Worksheet. |
| DataValidationError | Gets or sets an error message. |
| DataValidationMessage | Represents the message that the user will see when entering data in a Cell. |
| DrawingClientData | This class is used to enable or disable the selection and printing of the elements within the worksheet when it is protected. |
| ExcelRangeBuilder | This class represents a builder used to build ranges in a Worksheet. |
| 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. |
| Margins | Represents the Worksheet's margins. |
| 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. |
| PageLayout | Defines the options related to the Worksheet's page & printing layouts. |
| 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. |
Xceed Workbooks for .NET v2.0 Documentation
Xceed.Workbooks.NET Namespace
