GemBox.Spreadsheet component provides easy and high performance way to create, read and convert XLS, CSV, XLSX, HTML or ODS files. For quick start look at SampleExplorer. Main class below is ExcelFile, which represents in-memory representation of XLS/XLSX/CSV/HTML/ODS file and has various Load and Save methods.

Classes

  ClassDescription
Public classAbstractRange
Base class for classes representing one or more excel cells.
Public classAnchorCell
Represents a anchor cell object used by ExcelPictureCollection in the worksheet.
Public classCellBorder
Contains settings for a single cell border.
Public classCellBorders
Collection of cell borders (CellBorder).
Public classCellRange
Cell range is a rectangular group of worksheet cells.
Public classCellRangeCollection
A collection of CellRange items.
Public classCellRangeEnumerator
Enumerator used for iterating cells in a CellRange.
Public classCellStyle
Contains settings specifying how the cell data will be displayed.
Public classComHelper
Contains methods that can be useful for users which are calling GemBox.Spreadsheet component using COM interop.
Public classDataValidation
A single item of data validation defined on a ranges of the worksheet.
Public classDataValidationCollection
A collection of DataValidation items. Supported in XLSX only.
Public classDefaultHtmlExporter
Default methods for exporting to HTML.
Public classDefinedName
Defined name class describes defined name that is not directly related with one cell range. Supported in XLSX only.
Public classDefinedNameCollection
Collection of defined names that are not directly related with one cell range. Supported in XLSX only.
Public classDocumentProperties
Contains a collection of built-in and custom document properties.
Public classExcelCell
Excel cell provides access to a single worksheet cell or to a merged range if the cell is merged.
Public classExcelCellCollection
Collection of excel cells (ExcelCell).
Public classExcelColumn
Excel column contains column options and cell range with column cells.
Public classExcelColumnCollection
Collection of excel columns (ExcelColumn).
Public classExcelColumnRowBase
Base class for the excel column and row classes.
Public classExcelComment
Represents a comment object used by Comment in the worksheet.
Public classExcelFile
Excel file contains one or more worksheets (ExcelWorksheet) and workbook related properties and methods.
Public classExcelFillPattern
Contains fill pattern settings.
Public classExcelFont
Contains font related settings.
Public classExcelPicture
Represents a picture object used by ExcelPictureCollection in the worksheet.
Public classExcelPictureCollection
Collection of the ExcelPicture.
Public classExcelPrintOptions
Stores MS Excel print and print related options.
Public classExcelRow
Excel row contains row options and cell range with row cells.
Public classExcelRowCollection
Collection of excel rows (ExcelRow).
Public classExcelRowColumnCellCollectionBase
Base class for row, column and cell collections.
Public classExcelRowColumnCollectionBase
Base class for row and column collections.
Public classExcelRowColumnCollectionBase<(Of <(<'T>)>)>
Generic base class for row and column collections.
Public classExcelViewOptions
Stores MS Excel display and view related options.
Public classExcelWorksheet
Excel worksheet is a table with additional properties, identified by a unique name.
Public classExcelWorksheetCollection
Collection of worksheets (ExcelWorksheet).
Public classExtractDataDelegateEventArgs
Arguments of ExtractDataDelegate.
Public classHorizontalPageBreak
Specifies a horizontal position where the new page begins when the worksheet is printed.
Public classHorizontalPageBreakCollection
Collection of horizontal page breaks (HorizontalPageBreak).
Public classHtmlExporterOptions
Options and methods that define HTML export behavior.
Public classHtmlExportPosition
Data that describes the current position in the exporter methods.
Public classIoWarningEventArgs
Warning event arguments class used by the event which is raised on warning happens in the excel lite library
Public classLimitEventArgs
Event parameters used for the ExcelFile.LimitNear and ExcelFile.LimitReached events. (Free version only)
Public classNamedRange
Represents a named range in the worksheet.
Public classNamedRangeCollection
Collection of the descriptive names which are used to represent cells, ranges of cells, formulas, or constant values.
Public classPageBreak
Base class for all page breaks.
Public classPageBreakCollection
Base class for page break collections.
Public classPageBreakCollection<(Of <(<'T>)>)>
Generic base class for page break collections.
Public classSheetHeaderFooter
Represents sheet header/footer.
Public classSortDescription
Specifies the column, sorting order and optional custom comparison used in Sort(IEnumerable<(Of <<'(SortDescription>)>>)) method.
Public classSpreadsheetException
Represents errors that can occur in the GemBox.Spreadsheet component.
Public classSpreadsheetHyperlink
Hyperlink class.
Public classSpreadsheetHyperlinkCollection
Collection of hyperlinks (SpreadsheetHyperlink).
Public classSpreadsheetInfo
Contains static licensing methods (GemBox.Spreadsheet Professional only) and diagnostic information about executing GemBox.Spreadsheet assembly.
Public classVerticalPageBreak
Specifies a vertical position where the new page begins when the worksheet is printed.
Public classVerticalPageBreakCollection
Collection of vertical page breaks (VerticalPageBreak).
Public classWorksheetPanes
Represents the worksheet panes.
Public classWorksheetProtection
Protection settings. Supported in XLSX only.
Public classXlsxSaveOptions
Save options.

Delegates

  DelegateDescription
Public delegateExcelWorksheet..::..ExtractDataEventHandler
Delegate for handling the ExtractData events.
Public delegateHtmlExporterOptions..::..CellStyleToHtmlDelegate
Delegate for handling export of cell style to string.
Public delegateHtmlExporterOptions..::..CellToHtmlDelegate
Delegate for handling cell export.
Public delegateHtmlExporterOptions..::..CellValueToHtmlDelegate
Delegate for handling export of cell value to string.
Public delegateHtmlExporterOptions..::..ColumnLettersToHtmlDelegate
Delegate for handling export of header row.
Public delegateHtmlExporterOptions..::..ColumnLetterToHtmlDelegate
Delegate for handling export of cell that represent column letter.
Public delegateHtmlExporterOptions..::..PageToHtmlDelegate
Delegate for handling export of the whole HTML page.
Public delegateHtmlExporterOptions..::..RowNumberToHtmlDelegate
Delegate for handling export of cell that represent row number.
Public delegateHtmlExporterOptions..::..RowToHtmlDelegate
Delegate for handling export of specified excel row.
Public delegateHtmlExporterOptions..::..TableToHtmlDelegate
Delegate for handling export of table for specified range.
Public delegateIoWarningEventHandler
Delegate for handling the notification events.
Public delegateLimitEventHandler
Delegate for handling the ExcelFile.LimitNear and ExcelFile.LimitReached events. (Free version only)

Enumerations

  EnumerationDescription
Public enumerationBuiltInDocumentProperties
Enumeration of available built-in document properties.
Public enumerationColumnTypeResolution
Defines resolution method that determines DataTable column type.
Public enumerationCsvType
Formatting type for CSV files.
Public enumerationDataValidationErrorStyle
The style of data validation error alert.
Public enumerationDataValidationOperator
The relational operator used in data validation.
Public enumerationDataValidationType
Specifies the type of data validation used to validate user input.
Public enumerationExcelPictureFormat
Picture formats.
Public enumerationExtractDataError
Possible errors that can occur while extracting to DataTable.
Public enumerationExtractDataEventAction
Possible ways of dealing with error after the event has been handled.
Public enumerationExtractDataOptions
Options specified when extracting data to DataTable.
Public enumerationFillPatternStyle
Fill pattern styles used for ExcelFillPattern.PatternStyle.
Public enumerationHorizontalAlignmentStyle
Horizontal alignment styles used for CellStyle.HorizontalAlignment.
Public enumerationIndividualBorder
Different borders that can be set on excel cell. Members of this enumeration can't be combined.
Public enumerationIoOperation
Possible operations that can fire notification events.
Public enumerationLineStyle
Line styles used for CellBorder.LineStyle.
Public enumerationMultipleBorders
Flags for borders and border groups that can be set on the excel cell.
Public enumerationOdsOptions
Options specified when loading ODS files.
Public enumerationPanePosition
Represents the position of the pane.
Public enumerationPanesState
Represents the state of the pane.
Public enumerationPositioningMode
Option that specify the behaviour of the picture in the worksheet.
Public enumerationRangeIndexingMode
Indexing modes used by CellRange.
Public enumerationRowColumnResolutionMethod
Defines different methods of CellStyle resolution.
Public enumerationScriptPosition
Script positions used in ExcelFont.ScriptPosition.
Public enumerationSheetVisibility
Script positions used in ExcelWorksheet.Visibility.
Public enumerationUnderlineStyle
Underline styles used in ExcelFont.UnderlineStyle.
Public enumerationVerticalAlignmentStyle
Vertical alignment styles used for CellStyle.VerticalAlignment.
Public enumerationXlsOptions
Options specified when reading XLS files.
Public enumerationXlsxOptions
Options specified when reading XLSX files.
Public enumerationXlsxType
OpenXML file type.