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, CSV or XLSX format) without Microsoft Excel on client machine. In addition you can export worksheet or a part of a worksheet to HTML. For quick start look at samples folder in your installation folder. Main class below is ExcelFile, which represents in-memory representation of XLS/XLSX/CSV/HTML file and has various Load and Save methods.
| Class | Description |
|---|---|
| AbstractRange | Base class for classes representing one or more excel cells. |
| AnchorCell | Represents a anchor cell object used by |
| 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. |
| DefaultHtmlExporter | Default methods for exporting to HTML. |
| DefinedName | Defined name class describes defined name that is not directly related with one cell range. Supported in XLSX only. |
| DefinedNameCollection | Collection of defined names that are not directly related with one cell range. Supported in XLSX only. |
| 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). |
| ExtractDataDelegateEventArgs | Arguments of ExtractDataDelegate. |
| HorizontalPageBreak | Specifies a horizontal position where the new page begins when the worksheet is printed. |
| HorizontalPageBreakCollection | Collection of horizontal page breaks (HorizontalPageBreak). |
| HtmlExporterOptions | Options and methods that define HTML export behavior. |
| HtmlExportPosition | Data that describes the current position in the exporter methods. |
| IoWarningEventArgs | Warning event arguments class used by the event which is raised on warning happens in the excel lite library |
| LimitEventArgs | Event parameters used for the ExcelFile.LimitNear and ExcelFile.LimitReached events. (Free version only) |
| 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. |
| SheetHeaderFooter | Represents sheet header/footer. |
| SpreadsheetException | Represents errors that can occur in the GemBox.Spreadsheet component. |
| SpreadsheetHyperlink | Hyperlink class. |
| SpreadsheetHyperlinkCollection | Collection of hyperlinks (SpreadsheetHyperlink). |
| 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 |
|---|---|
| ExcelWorksheet.ExtractDataEventHandler | Delegate for handling the ExtractData events. |
| HtmlExporterOptions.CellStyleToHtmlDelegate | Delegate for handling export of cell style to string. |
| HtmlExporterOptions.CellToHtmlDelegate | Delegate for handling cell export. |
| HtmlExporterOptions.CellValueToHtmlDelegate | Delegate for handling export of cell value to string. |
| HtmlExporterOptions.ColumnLettersToHtmlDelegate | Delegate for handling export of header row. |
| HtmlExporterOptions.ColumnLetterToHtmlDelegate | Delegate for handling export of cell that represent column letter. |
| HtmlExporterOptions.PageToHtmlDelegate | Delegate for handling export of the whole HTML page. |
| HtmlExporterOptions.RowNumberToHtmlDelegate | Delegate for handling export of cell that represent row number. |
| HtmlExporterOptions.RowToHtmlDelegate | Delegate for handling export of specified excel row. |
| HtmlExporterOptions.TableToHtmlDelegate | Delegate for handling export of table for specified range. |
| IoWarningEventHandler | Delegate for handling the notification events. |
| LimitEventHandler | Delegate for handling the ExcelFile.LimitNear and ExcelFile.LimitReached events. (Free version only) |
| Enumeration | Description |
|---|---|
| CsvType | Formatting type for CSV files. |
| ExcelPictureFormat | Picture formats. |
| ExtractDataError | Possible errors that can occur while extracting to DataTable. |
| ExtractDataEventAction | Possible ways of dealing with error after the event has been handled. |
| ExtractDataOptions | Options specified when extracting data to DataTable. |
| 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. |
| PositioningMode | Option that specify the behaviour of the picture in the worksheet. |
| RangeIndexingMode | Indexing modes used by CellRange. |
| RowColumnResolutionMethod | Defines different methods of CellStyle resolution. |
| ScriptPosition | Script positions used in ExcelFont.ScriptPosition. |
| SheetVisibility | Script positions used in ExcelWorksheet.Visibility. |
| UnderlineStyle | Underline styles used in ExcelFont.UnderlineStyle. |
| VerticalAlignmentStyle | Vertical alignment styles used for CellStyle.VerticalAlignment. |
| XlsOptions | Options specified when reading XLS files. |
| XlsxOptions | Options specified when reading XLSX files. |