Package | Description |
---|---|
com.gembox.spreadsheet |
Contains classes and enums that constitute GemBox.Spreadsheet object model.
|
com.gembox.spreadsheet.calculationengine |
Contains types used to calculate cells formula.
|
com.gembox.spreadsheet.charts |
Contains types used to display series of numeric data in a graphical format.
|
com.gembox.spreadsheet.conditionalformatting |
Contains types used to format cells conditionally based on their values.
|
com.gembox.spreadsheet.pivottables |
Contains types that constitute model of Pivot Tables.
|
com.gembox.spreadsheet.tables |
Contains types that constitute model of Tables.
|
Class and Description |
---|
AbstractRange
Base class for classes representing one or more excel cells.
|
AnchorCell
Represents an anchor cell object used in
ExcelDrawingPosition type to specify from which cell and to which cell drawing (picture, chart, etc.) spans. |
AutoFilter
Represents filter settings and provides filter functionality.
|
BuiltInCellStyleName
Represents a built-in style name.
|
BuiltInDocumentProperties
Enumeration of available built-in document properties.
|
CellBorder
Represents the color and line style for the single border of a cell.
|
CellBorders
Represents a single set of cell border formats (left, right, top, bottom and diagonal).
|
CellRange
Cell range is a rectangular group of worksheet cells.
|
CellRangeCollection
A collection of
CellRange items. |
CellRangeIterator
Iterator used for iterating cells in a
CellRange . |
CellStyle
Represents cell formatting.
|
CellStyleCollection
Represents a collection of workbook (master)
Style s. |
CellValueType
Represents the possible cell value types.
|
ClearOptions
Specifies the clear options.
|
ColorName
Represents a color name of colors available in MS Excel user interface.
|
CsvLoadOptions
Represents options for loading from Character Separated Values file format.
|
CsvSaveOptions
Represents options for saving to Character Separated Values file format.
|
CsvType
Formatting type for CSV files.
|
CustomFilter
Represents a filter that specifies one or two conditions (operators and values) and whether the two conditions are joined by 'and' or 'or'.
|
DataValidation
A single item of data validation defined on ranges of the worksheet.
|
DataValidation.DataValidationImeMode
Deprecated.
This method is internal and should not be used.
|
DataValidationCollection
A collection of
DataValidation items. |
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.
|
DateTimeGroup
Represents a group of
LocalDateTime s. |
DateTimeGroupLevel
Represents a level of a
DateTimeGroup . |
DefinedName
Defined name class describes defined name that is not directly related with one cell range.
|
DefinedNameCollection
Collection of defined names that are not directly related with one cell range.
|
DocumentProperties
Contains a collection of built-in and custom document properties.
|
DynamicFilter
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").
|
DynamicFilterType
Represents a dynamic filter type.
|
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
ExcelCell.setComment(com.gembox.spreadsheet.ExcelComment) in the worksheet. |
ExcelCommentCollection
Collection of comments (
ExcelComment ). |
ExcelDrawing
Represents a base class for all drawings (pictures, charts, etc.) in the worksheet.
|
ExcelDrawingCollectionImpl
Represents a collection of
drawings (pictures, charts, etc.) in the worksheet. |
ExcelDrawingMetadata
Represents a set of non-visual properties which shall be applied to the parent
ExcelDrawing . |
ExcelDrawingPosition
Represents a class which holds information about position and size of the
ExcelDrawing (picture, chart, etc.) in the worksheet. |
ExcelEmbeddedObject
Represents a read-only embedded object in the worksheet.
|
ExcelEmbeddedObjectCollection
Represents a read-only collection of
|
ExcelFile
Excel file contains one or more worksheets (
ExcelWorksheet )
and workbook related properties and methods. |
ExcelFillPattern
Represents cell fill (background) formatting which can be either pattern or gradient.
|
ExcelFont
Represents a typeface (for example, Calibri), along with its attributes (size, font style, underlining, color, and effects).
|
ExcelObjectSourceType
Represents an enumeration of possible sources of various objects (such as pictures, audio and other files) that can be either embedded, linked or both.
|
ExcelPicture
Represents a picture in the worksheet.
|
ExcelPictureCollection
Represents a collection of
picture s in the worksheet. |
ExcelPictureFormat
Picture formats.
|
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.
|
ExcelRowColumnCollectionBaseGeneric
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 ). |
FileFormatLimitations
Represents file format limitations when saving
ExcelFile to some format. |
FillPatternStyle
Represents the style of fill pattern being used for a cell format.
|
Filter
Represents a base class for filters contained in
AutoFilter . |
FilterColumn
Represents filter and sort settings for a single filter column.
|
FilterColumnCollection
Represents a collection of filter columns.
|
FilterOperator
Operator enumerations for filtering.
|
FilterType
Represents a filter type.
|
FixedWidthColumn
Class that represents column in Fixed-Width Text format.
|
FormattedCharacterRange
Represents a range of characters within the cell or comment text.
|
FreeLimitEventArgs
Provides data for the free limit reached event.
|
FreeLimitReachedAction
Type of action that can be chosen when free limit is reached.
|
FreeLimitReachedListener
Represents a listener for the free limit reached event in
SpreadsheetInfo |
GradientShadingStyle
Represents a shading style and variant of a gradient fill effect.
|
HeaderFooter
Represents worksheet's header or footer.
|
HeaderFooterFieldType
Represents types of
HeaderFooterSection predefined fields. |
HeaderFooterPage
Represents header/footer which should be shown on a specific worksheet page (first page, even pages and all other pages).
|
HeaderFooterSection
Represents
header or footer section. |
HorizontalAlignmentStyle
Represents available horizontal alignment options used in
CellStyle horizontal alignment member. |
HorizontalPageBreak
Specifies a horizontal position where the new page begins when the worksheet is printed.
|
HorizontalPageBreakCollection
Collection of horizontal page breaks (
HorizontalPageBreak ). |
HtmlLoadOptions
Represents options for loading from HyperText Markup Language File (HTML) format.
|
HtmlSaveOptions
Represents options for saving to HyperText Markup Language File (HTML) format.
|
HtmlType
Defines type of HTML export.
|
IgnoredError
Represents a single ignored error for a range of cells.
|
IgnoredErrorCollection
Represents a collection of an ignored errors in the worksheet.
|
IgnoredErrorTypes
Represents an ignored error conditions.
|
IndividualBorder
Represents single border type of a cell.
|
InsertShiftDirection
Represents the possible cell add shift directions.
|
LengthUnit
Represents the measurement unit for measuring length or distance.
|
LineStyle
Represents the line style of a border in a cell.
|
LoadOptions
Represents a base class for loading options of various file formats.
|
MultipleBorders
Represents multiple border types of a cell.
|
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.
|
NumberType
Specifies numeric type
|
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.
|
PanePosition
Represents the position of the pane.
|
PanesState
Represents the state of the pane.
|
PaperType
Specifies the paper type.
|
PositioningMode
Option that specify the moving and sizing behavior of the
ExcelDrawing (picture, chart, etc.) in the worksheet. |
ProtectedRange
Represents a range of cells to be protected.
|
ProtectedRangeCollection
Represents a collection of all protected ranges on the
ExcelWorksheet . |
RangeIndexingMode
Indexing modes used by
CellRange . |
RemoveShiftDirection
Represents the possible cell remove shift directions.
|
RowColumn
Tuple representing row and column index
|
SaveOptions
Represents a base class for saving options of various file formats.
|
ScriptPosition
Defines the possible settings for vertical alignment of a text and is used in
ExcelFont.getScriptPosition() member to get superscript or subscript text without altering the font size. |
SelectionType
Defines the selection which will be saved or printed.
|
SheetHeaderFooter
Represents sheet header/footer.
|
SheetType
Specifies the sheet type.
|
SheetVisibility
Script positions used in
ExcelWorksheet visibility . |
SortLevel
Represents sort settings for a single sort level.
|
SortLevelCollection
Represents a collection of sort levels.
|
SortState
Represents sort settings and provides sort functionality.
|
SpreadsheetColor
Represents a spreadsheet color.
|
SpreadsheetException
Represents errors that can occur in the GemBox.Spreadsheet component.
|
SpreadsheetHyperlink
Hyperlink class.
|
SpreadsheetHyperlinkCollection
Collection of hyperlinks (
SpreadsheetHyperlink ). |
SpreadsheetIcon
Represents a spreadsheet icon.
|
SpreadsheetIconStyle
Represents an enumeration of visually distinct icon sets.
|
Style
Represents a workbook (master) style which can be shared by multiple cells.
|
Top10Filter
Represents a filter that filters by a top N (percent or number of items).
|
UnderlineStyle
Represents the different types of possible underline formatting used in
ExcelFont.getUnderlineStyle() member. |
ValuesFilter
Represents a filter that filters by a list of values.
|
VerticalAlignmentStyle
Represents available vertical alignment options used in
CellStyle.setVerticalAlignment(com.gembox.spreadsheet.VerticalAlignmentStyle) member. |
VerticalPageBreak
Specifies a vertical position where the new page begins when the worksheet is printed.
|
VerticalPageBreakCollection
Collection of vertical page breaks (
VerticalPageBreak ). |
ViewType
Specifies the view type.
|
WorkbookProtection
Protection settings.
|
WorksheetPanes
Represents the worksheet panes.
|
WorksheetProtection
Protection settings.
|
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).
|
XlsxType
OpenXML file type.
|
Class and Description |
---|
ExcelCell
Excel cell provides access to a single worksheet cell or to a merged range if the cell is merged.
|
SpreadsheetException
Represents errors that can occur in the GemBox.Spreadsheet component.
|
Class and Description |
---|
AnchorCell
Represents an anchor cell object used in
ExcelDrawingPosition type to specify from which cell and to which cell drawing (picture, chart, etc.) spans. |
CellRange
Cell range is a rectangular group of worksheet cells.
|
ExcelDrawing
Represents a base class for all drawings (pictures, charts, etc.) in the worksheet.
|
ExcelDrawingCollectionImpl
Represents a collection of
drawings (pictures, charts, etc.) in the worksheet. |
ExcelWorksheet
Excel worksheet is a table with additional properties, identified by a unique name.
|
LengthUnit
Represents the measurement unit for measuring length or distance.
|
Class and Description |
---|
CellStyle
Represents cell formatting.
|
ExcelWorksheet
Excel worksheet is a table with additional properties, identified by a unique name.
|
SpreadsheetColor
Represents a spreadsheet color.
|
SpreadsheetIcon
Represents a spreadsheet icon.
|
SpreadsheetIconStyle
Represents an enumeration of visually distinct icon sets.
|
Class and Description |
---|
AbstractRange
Base class for classes representing one or more excel cells.
|
AutoFilter
Represents filter settings and provides filter functionality.
|
CustomFilter
Represents a filter that specifies one or two conditions (operators and values) and whether the two conditions are joined by 'and' or 'or'.
|
DynamicFilter
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").
|
DynamicFilterType
Represents a dynamic filter type.
|
ExcelCell
Excel cell provides access to a single worksheet cell or to a merged range if the cell is merged.
|
ExcelFile
Excel file contains one or more worksheets (
ExcelWorksheet )
and workbook related properties and methods. |
ExcelWorksheet
Excel worksheet is a table with additional properties, identified by a unique name.
|
Filter
Represents a base class for filters contained in
AutoFilter . |
FilterOperator
Operator enumerations for filtering.
|
Top10Filter
Represents a filter that filters by a top N (percent or number of items).
|
ValuesFilter
Represents a filter that filters by a list of values.
|
Class and Description |
---|
AutoFilter
Represents filter settings and provides filter functionality.
|
CellRange
Cell range is a rectangular group of worksheet cells.
|
ExcelCell
Excel cell provides access to a single worksheet cell or to a merged range if the cell is merged.
|
ExcelWorksheet
Excel worksheet is a table with additional properties, identified by a unique name.
|
RemoveShiftDirection
Represents the possible cell remove shift directions.
|
SortState
Represents sort settings and provides sort functionality.
|
© GemBox d.o.o. — All rights reserved.