Contains classes, delegates and enumerations that constitute GemBox.Spreadsheet object model.
Base class for classes representing one or more excel cells.
Represents an anchor cell object used in ExcelDrawingPosition type to specify from which cell and to which cell drawing (picture, chart, etc.) spans.
Represents filter settings and provides filter functionality.
Represents the color and line style for the single border of a cell.
Represents a single set of cell border formats (left, right, top, bottom and diagonal).
Cell range is a rectangular group of worksheet cells.
A collection of CellRange items.
Enumerator used for iterating cells in a CellRange.
Represents cell formatting.
Represents a collection of workbook (master) Styles.
Contains methods that can be useful for users which are calling GemBox.Spreadsheet component using COM interop.
Represents a custom content type property.
Represents the options used when copying a cell range.
Represents options creating DataTable and filling it with values from ExcelWorksheet.
Represents options for loading from Character Separated Values file format.
Represents options for saving to Character Separated Values file format.
Represents a filter that specifies one or two conditions (operators and values) and whether the two conditions are joined by 'and' or 'or'.
Arguments for DataTableCellToExcelCellConverting event.
A single item of data validation defined on ranges of the worksheet.
A collection of DataValidation items. Supported in XLSX only.
Defined name class describes defined name that is not directly related with one cell range.
Collection of defined names that are not directly related with one cell range.
Represents a class that stores details for signing a workbook with a digital signature.
Contains a collection of built-in and custom document properties.
Represents a dynamic filter criteria that can change, either with the data itself (e.g., "above average") or with the current system date (e.g., show values for "today").
Excel cell provides access to a single worksheet cell or to a merged range if the cell is merged.
Collection of excel cells (ExcelCell).
Arguments for ExcelCellToDataTableCellConverting event.
Excel column contains column options and cell range with column cells.
Collection of excel columns (ExcelColumn).
Base class for the excel column and row classes.
Represents a comment object used by Comment in the worksheet.
Collection of comments (ExcelComment).
Represents a base class for all drawings (pictures, charts, etc.) in the worksheet.
Represents a collection of ExcelDrawing (pictures, charts, etc.) in the worksheet.
Represents a set of non-visual properties which shall be applied to the parent ExcelDrawing.
Represents a class which holds information about position and size of the ExcelDrawing (picture, chart, etc.) in the worksheet.
Represents a read-only embedded object in the worksheet.
Represents a read-only collection of ExcelEmbeddedObjects in the worksheet.
Excel file contains one or more worksheets (ExcelWorksheet) and workbook related properties and methods.
Represents a workbook page.
Provides functionality to paginate the workbook content.
Represents a collection of application-specific ExcelFile instances.
Represents cell fill (background) formatting which can be either pattern or gradient.
Represents a typeface (for example, Calibri), along with its attributes (size, font style, underlining, color, and effects).
Represents a picture in the worksheet.
Represents a collection of ExcelPictures in the worksheet.
Stores MS Excel print and print related options.
Excel row contains row options and cell range with row cells.
Collection of excel rows (ExcelRow).
Base class for row, column and cell collections.
Base class for row and column collections.
Generic base class for row and column collections.
Represents a drawing that has a specific shape / geometry.
Represents a collection of ExcelShapes in the worksheet.
Stores MS Excel display and view related options.
Excel worksheet is a table with additional properties, identified by a unique name.
Collection of worksheets (ExcelWorksheet).
Represents options for extracting data from ExcelWorksheet to DataTable.
Represents file format limitations when saving ExcelFile to some format.
Represents a base class for filters contained in AutoFilter.
Represents filter and sort settings for a single filter column.
Represents a collection of filter columns.
Class that represents column in Fixed-Width Text format.
Represents options for loading from Fixed-Width Text file format.
Represents options for saving to Fixed-Width Text file format.
Contains font related settings which are used when printing a spreadsheet or exporting a spreadsheet to a file format that requires font information.
Represents a range of characters within the cell or comment text.
Represents a formatted drawing (picture, chart, etc.) which can be exported to PDF, XPS, image or be printed.
Provides data for the FreeLimitReached event.
Exception that occurs when free limit is reached.
Represents worksheet's header or footer.
Represents header/footer which should be shown on a specific worksheet page (first page, even pages and all other pages).
Represents HeaderFooter section.
Specifies a horizontal position where the new page begins when the worksheet is printed.
Collection of horizontal page breaks (HorizontalPageBreak).
Represents options for loading from HyperText Markup Language File (HTML) format.
Represents options for saving to HyperText Markup Language File (HTML) format.
Represents a single ignored error for a range of cells.
Represents a collection of an ignored errors in the worksheet.
Represents a class which stores saving options for image files.
Represents options for inserting data from DataTable to ExcelWorksheet.
Utility class used for converting values between various LengthUnit measurement units.
Represents a base class for loading options of various file formats.
Represents a named range in the worksheet.
Collection of the descriptive names which are used to represent cells, ranges of cells, formulas, or constant values.
Utility class that can be used to create a number format for NumberFormat.
Represents options for loading from OpenDocument Spreadsheet file format.
Represents options for saving to OpenDocument Spreadsheet file format.
Provides data for events that track the progress of an operation, such as loading and saving of a workbook.
Base class for all page breaks.
Base class for page break collections.
Generic base class for page break collections.
Represents options used to specify which part of the workbook to paginate.
Represents a class that stores details for signing a workbook saved to a Portable Document Format (PDF) with a digital signature.
Represents options for saving to Portable Document Format (PDF) file.
Specifies information about how a spreadsheet is printed.
Represents a range of cells to be protected.
Represents a collection of all protected ranges on the ExcelWorksheet.
Represents a base class for saving options of various file formats.
Represents sheet header/footer.
Represents sort settings for a single sort level.
Represents a collection of sort levels.
Represents sort settings and provides sort functionality.
Represents errors that can occur in the GemBox.Spreadsheet component.
Collection of hyperlinks (SpreadsheetHyperlink).
Contains static licensing methods and diagnostic information about executing GemBox.Spreadsheet assembly.
Represents a workbook (master) style which can be shared by multiple cells.
Represents a filter that filters by a top N (percent or number of items).
Represents a filter that filters by a list of values.
Specifies a vertical position where the new page begins when the worksheet is printed.
Collection of vertical page breaks (VerticalPageBreak).
Protection settings. Supported in XLSX only.
Represents the worksheet panes.
Protection settings. Supported in XLSX, XLSB and XLS only.
Represent options for loading from XLSB file format (Microsoft Excel Binary File Format).
Represent options for saving to XLSB file format (Microsoft Excel Binary File Format).
Represents options for loading from XLS file format (Microsoft Excel Spreadsheet format; Excel 2003 and prior versions) .
Represents options for saving to, XLS file format (Microsoft Excel Spreadsheet format; Excel 2003 and prior versions) .
Represents a class that stores details for signing a workbook saved to XLSX file with a digital signature.
Represent options for loading from XLSX file format (Microsoft Excel Open XML Spreadsheet; Strict Open XML Spreadsheet; Excel 2007 and later).
Represent options for saving to XLSX file format (Microsoft Excel Open XML Spreadsheet; Excel 2007 and later).
Represents options for loading from XML file format (XML Spreadsheet 2003, also called SpreadsheetML).
Represents options for saving to XML Paper Specification file format.
Represents a group of DateTimes.
Each DateTime instance that has the same date/time components (year, month, day, hour, minute, second) as this DateTime up to Level belongs to this group.
Instance of DateTimeGroup can be inserted into Values collection to enable filtering DateTime values.
Represents a spreadsheet color.
Represents a spreadsheet icon.
Represents a built-in style name.
Enumeration of available built-in document properties.
Represents the possible cell value types.
Specifies the clear options.
Represents a color name of colors available in MS Excel user interface.
Defines resolution method that determines DataType.
Represents a subtotal function.
Represents types of data to copy from a cell range.
Possible conditions for when values in a CSV file should be quoted.
Formatting type for CSV files.
The style of data validation error alert.
The relational operator used in data validation.
Specifies the type of data validation used to validate user input.
Represents a level of a DateTimeGroup.
Represents a dynamic filter type.
Represents an enumeration of possible sources of various objects (such as pictures, audio and other files) that can be either embedded, linked or both.
Possible ways of proceeding after one of the events is fired while extracting to data table.
Options specified when extracting data to DataTable.
Represents the style of fill pattern being used for a cell format.
Currently supported only in XLSX, XLSB and XLS. For all other formats it defaults to either None or Solid.
Operator enumerations for filtering.
Represents a filter type.
Represents a formula type.
Type of action that can be chosen when free limit is reached.
Represents a shading style and variant of a gradient fill effect.
Gradient fill is currently supported in XLSX, XLSB and partially in rendering formats (PDF, XPS and image formats).
Represents types of HeaderFooterSection predefined fields.
Represents available horizontal alignment options used in HorizontalAlignment member.
Defines type of HTML export.
Represents an ignored error conditions.
An enumeration of supported image file formats when saving the ExcelFile to an image using a ImageSaveOptions.
Represents single border type of a cell.
Represents the possible cell insert shift directions.
Represents the measurement unit for measuring length or distance.
Represents the line style of a border in a cell.
Represents a mode of streamlined loading of an ExcelFile.
Represents multiple border types of a cell.
Represents the position of the pane.
Represents the state of the pane.
Specifies the paper type.
Represents levels of conformance for PDF documents.
Defines operations that are allowed to a user on an encrypted PDF document.
An enumeration of supported pixel formats when saving an ExcelFile to an image using an ImageSaveOptions.
Option that specify the moving and sizing behavior of the ExcelDrawing (picture, chart, etc.) in the worksheet.
Indexing modes used by CellRange.
Represents the possible cell remove shift directions.
Defines the possible settings for vertical alignment of a text and is used in ScriptPosition member to get superscript or subscript text without altering the font size.
Defines the selection which will be saved or printed.
Specifies the sheet type.
Script positions used in Visibility.
Represents an enumeration of visually distinct icon sets.
Represents available reading order options used in TextDirection member.
An enumeration of supported compression schemes for Tagged Image File Format (TIFF) when saving an ExcelFile to an image using an ImageSaveOptions.
Represents the different types of possible underline formatting used in UnderlineStyle member.
Represents available vertical alignment options used in VerticalAlignment member.
Specifies the view type.
OpenXML file type.