Contains classes, delegates and enumerations that constitute GemBox.Spreadsheet object model.
Classes
| Class | Description | |
|---|---|---|
 | AbstractRange |
Base class for classes representing one or more excel cells.
|
| AnchorCell |
Represents an anchor cell object used by ExcelPictureCollection in the worksheet.
|
| CellBorder |
Contains settings for a single cell border.
|
| CellBorders |
Collection of cell borders (CellBorder).
|
| CellRange |
Cell range is a rectangular group of worksheet cells.
|
| CellRangeCollection |
A collection of CellRange items.
|
| CellRangeEnumerator |
Enumerator used for iterating cells in a CellRange.
|
| CellStyle |
Contains settings specifying how the cell data will be displayed.
|
| ComHelper |
Contains methods that can be useful for users which are calling GemBox.Spreadsheet component using COM interop.
|
| CreateDataTableOptions |
Represents options creating DataTable and filling it with values from ExcelWorksheet.
|
| CsvLoadOptions |
Represents options for loading from Character Separated Values file format.
|
| CsvSaveOptions |
Represents options for saving to Character Separated Values file format.
|
| DataTableCellToExcelCellConvertingEventArgs |
Arguments for DataTableCellToExcelCellConverting event.
|
| DataValidation |
A single item of data validation defined on ranges of the worksheet.
|
| DataValidationCollection |
A collection of DataValidation items.
Supported in XLSX only.
|
| 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.
|
| DocumentProperties |
Contains a collection of built-in and custom document properties.
|
| 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).
|
| ExcelCellToDataTableCellConvertingEventArgs |
Arguments for ExcelCellToDataTableCellConverting event.
|
| 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 Comment in the worksheet.
|
| 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 in the worksheet.
|
| ExcelPictureCollection |
Collection of the ExcelPicture.
|
| 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.
|
| ExcelRowColumnCollectionBase T |
Generic 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 | Obsolete.
Arguments of ExtractDataDelegate.
|
| ExtractToDataTableOptions |
Represents options for extracting data from ExcelWorksheet to DataTable.
|
| FileFormatLimitations |
Represents file format limitations when saving ExcelFile to some format.
|
| FontSettings |
Contains font related settings which are used when printing a spreadsheet or exporting a spreadsheet to a file format that requires font information.
|
| FreeLimitEventArgs |
Provides data for the FreeLimitReached event.
|
| FreeLimitReachedException |
Exception that occurs when free limit is reached.
|
| HorizontalPageBreak |
Specifies a horizontal position where the new page begins when the worksheet is printed.
|
| HorizontalPageBreakCollection |
Collection of horizontal page breaks (HorizontalPageBreak).
|
| HtmlSaveOptions |
Represents options for saving to Hypertext Markup Language File (HTML) format.
|
| ImageSaveOptions |
Represents a class which stores saving options for image files.
|
| InsertDataTableOptions |
Represents options for inserting data from DataTable to ExcelWorksheet.
|
| IoWarningEventArgs | Obsolete.
Warning event arguments class used by the event which is raised on warning happens in the excel lite library
|
| LengthUnitConverter |
Utility class used for converting values between various LengthUnit measurement units.
|
| LimitEventArgs | Obsolete.
Event parameters used for the ExcelFile.LimitNear and ExcelFile.LimitReached events.
|
| LoadOptions |
Represents a base class for loading options of various file formats.
|
| 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.
|
| OdsLoadOptions |
Represents options for loading from OpenDocument Spreadsheet file format.
|
| OdsSaveOptions |
Represents options for saving to OpenDocument Spreadsheet file format.
|
| PageBreak |
Base class for all page breaks.
|
| PageBreakCollection |
Base class for page break collections.
|
| PageBreakCollection T |
Generic base class for page break collections.
|
| PdfSaveOptions |
Represents options for saving to Portable Document Format (PDF) file.
|
| PrintOptions |
Specifies information about how a spreadsheet is printed.
|
| SaveOptions |
Represents a base class for saving options of various file formats.
|
| SheetHeaderFooter |
Represents sheet header/footer.
|
| SortDescription |
Specifies the column, sorting order and optional custom comparison used in Sort(IEnumerable SortDescription ) method.
|
| SpreadsheetException |
Represents errors that can occur in the GemBox.Spreadsheet component.
|
| SpreadsheetHyperlink |
Hyperlink class.
|
| SpreadsheetHyperlinkCollection |
Collection of hyperlinks (SpreadsheetHyperlink).
|
| SpreadsheetInfo |
Contains static licensing methods 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).
|
| WorksheetPanes |
Represents the worksheet panes.
|
| WorksheetProtection |
Protection settings.
Supported in XLSX only.
|
| XlsLoadOptions |
Represents options for loading from XLS file format (Microsoft Excel Spreadsheet format; Excel 2003 and prior versions) .
|
| XlsSaveOptions |
Represents options for saving to, XLS file format (Microsoft Excel Spreadsheet format; Excel 2003 and prior versions) .
|
| XlsxLoadOptions |
Represent options for loading from XLSX file format (Microsoft Excel Open XML Spreadsheet; Excel 2007 and later).
|
| XlsxSaveOptions |
Represent options for saving to XLSX file format (Microsoft Excel Open XML Spreadsheet; Excel 2007 and later).
|
| XpsSaveOptions |
Represents options for saving to XML Paper Specification file format.
|
Delegates
| Delegate | Description | |
|---|---|---|
 | ExcelWorksheet ExtractDataEventHandler | Obsolete.
Delegate for handling the ExtractData events.
|
| IoWarningEventHandler | Obsolete.
Delegate for handling the notification events.
|
| LimitEventHandler | Obsolete.
Delegate for handling the ExcelFile.LimitNear and ExcelFile.LimitReached events.
|
Enumerations
| Enumeration | Description | |
|---|---|---|
 | BuiltInDocumentProperties |
Enumeration of available built-in document properties.
|
| ColumnTypeResolution |
Defines resolution method that determines DataTable column type.
|
| CsvType |
Formatting type for CSV files.
|
| DataValidationErrorStyle |
The style of data validation error alert.
|
| DataValidationOperator |
The relational operator used in data validation.
|
| DataValidationType |
Specifies the type of data validation used to validate user input.
|
| ExcelPictureFormat |
Picture formats.
|
| ExtractDataError | Obsolete.
Possible errors that can occur while extracting to DataTable.
|
| ExtractDataEventAction |
Possible ways of proceeding after one of the events is fired while extracting to data table.
|
| ExtractDataOptions |
Options specified when extracting data to DataTable.
|
| FillPatternStyle |
Fill pattern styles used for
ExcelFillPattern.PatternStyle.
|
| FreeLimitReachedAction |
Type of action that can be chosen when free limit is reached.
|
| HorizontalAlignmentStyle |
Horizontal alignment styles used for
CellStyle.HorizontalAlignment.
|
| HtmlType |
Defines type of HTML export.
|
| ImageSaveFormat |
An enumeration of supported image file formats when saving the ExcelFile to an image using a ImageSaveOptions.
|
| IndividualBorder |
Different borders that can be set on excel cell. Members of this enumeration can't be combined.
|
| IoOperation | Obsolete.
Possible operations that can fire notification events.
|
| LengthUnit |
Represents the measurement unit for measuring length or distance.
|
| LineStyle |
Line styles used for
CellBorder.LineStyle.
|
| MultipleBorders |
Flags for borders and border groups that can be set on the excel cell.
|
| OdsOptions | Obsolete.
Options specified when loading ODS files.
|
| PanePosition |
Represents the position of the pane.
|
| PanesState |
Represents the state of the pane.
|
| PaperType |
Specifies the paper type.
|
| PositioningMode |
Option that specify the behavior 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.
|
| SelectionType |
Defines the selection which will be saved or printed.
|
| 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 | Obsolete.
Options specified when reading XLSX files.
|
| XlsxType |
OpenXML file type.
|