GemBox.Spreadsheet component provides easy, elegant and high performance (in terms of both memory and speed) way to create, read and convert native Microsoft Excel files (XLS or CSV format) without Microsoft Excel on client machine.
| Class | Description |
|---|---|
| AbstractRange | Base class for classes representing one or more excel cells. |
| CellBorder | Contains settings for a single cell border. |
| CellBorders | Collection of cell borders (CellBorder). |
| CellRange | Cell range is a rectangular group of worksheet cells. |
| CellRangeEnumerator | Enumerator used for iterating cells in a CellRange. |
| CellStyle | Contains settings specifying how the cell data will be displayed. |
| ExcelCell | Excel cell provides access to a single worksheet cell or to a merged range if the cell is merged. |
| ExcelCellCollection | Collection of excel cells (ExcelCell). |
| ExcelColumn | Excel column contains column options and cell range with column cells. |
| ExcelColumnCollection | Collection of excel columns (ExcelColumn). |
| ExcelColumnRowBase | Base class for the excel column and row classes. |
| ExcelComment | Represents a comment object used by |
| ExcelFile | Excel file contains one or more worksheets (ExcelWorksheet) and workbook related properties and methods. |
| ExcelFillPattern | Contains fill pattern settings. |
| ExcelFont | Contains font related settings. |
| ExcelPicture | Represents a picture object used by |
| ExcelPictureCollection | Collection of the |
| ExcelPrintOptions | Stores MS Excel print and print related options. |
| ExcelRow | Excel row contains row options and cell range with row cells. |
| ExcelRowCollection | Collection of excel rows (ExcelRow). |
| ExcelRowColumnCellCollectionBase | Base class for row, column and cell collections. |
| ExcelRowColumnCollectionBase | Base class for row and column collections. |
| ExcelViewOptions | Stores MS Excel display and view related options. |
| ExcelWorksheet | Excel worksheet is a table with additional properties, identified by a unique name. |
| ExcelWorksheetCollection | Collection of worksheets (ExcelWorksheet). |
| HorizontalPageBreak | Specifies a horizontal position where the new page begins when the worksheet is printed. |
| HorizontalPageBreakCollection | Collection of horizontal page breaks (HorizontalPageBreak). |
| IoWarningEventArgs | Warning event arguments class used by the event which is raised on warning happens in the excel lite library |
| NamedRange | Represents a named range in the worksheet. |
| NamedRangeCollection | Collection of the descriptive names which are used to represent cells, ranges of cells, formulas, or constant values. |
| PageBreak | Base class for all page breaks. |
| PageBreakCollection | Base class for page break collections. |
| SpreadsheetInfo | Contains static licensing methods (GemBox.Spreadsheet Professional only) and diagnostic information about executing GemBox.Spreadsheet assembly. |
| VerticalPageBreak | Specifies a vertical position where the new page begins when the worksheet is printed. |
| VerticalPageBreakCollection | Collection of vertical page breaks (VerticalPageBreak). |
| Delegate | Description |
|---|---|
| IoWarningEventHandler | Delegate for handling the notification events. |
| Enumeration | Description |
|---|---|
| CsvType | Formatting type for CSV files. |
| FillPatternStyle | Fill pattern styles used for ExcelFillPattern.PatternStyle. |
| HorizontalAlignmentStyle | Horizontal alignment styles used for CellStyle.HorizontalAlignment. |
| IndividualBorder | Different borders that can be set on excel cell. Members of this enumeration can't be combined. |
| IoOperation | Possible operations that can fire notification events. |
| LineStyle | Line styles used for CellBorder.LineStyle. |
| MultipleBorders | Flags for borders and border groups that can be set on the excel cell. |
| RangeIndexingMode | Indexing modes used by CellRange. |
| RowColumnResolutionMethod | Defines different methods of CellStyle resolution. |
| ScriptPosition | Script positions used in ExcelFont.ScriptPosition. |
| UnderlineStyle | Underline styles used in ExcelFont.UnderlineStyle. |
| VerticalAlignmentStyle | Vertical alignment styles used for CellStyle.VerticalAlignment. |
| XlsOptions | Options specified when reading XLS files. |