See: Description
Interface | Description |
---|---|
FreeLimitReachedListener |
Represents a listener for the free limit reached event in
SpreadsheetInfo |
Class | 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.
|
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. |
CsvLoadOptions |
Represents options for loading from Character Separated Values file format.
|
CsvSaveOptions |
Represents options for saving to Character Separated Values file format.
|
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.
|
DataValidationCollection |
A collection of
DataValidation items. |
DateTimeGroup |
Represents a group of
LocalDateTime s. |
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").
|
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<T extends ExcelDrawing> |
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).
|
ExcelPicture |
Represents a picture in the worksheet.
|
ExcelPictureCollection |
Represents a collection of
picture s in the worksheet. |
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<T extends ExcelColumnRowBase> |
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. |
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.
|
FixedWidthColumn |
Class that represents column in Fixed-Width Text format.
|
FixedWidthLoadOptions |
Represents options for loading from Fixed-Width Text file format.
|
FixedWidthSaveOptions |
Represents options for saving to Fixed-Width Text file format.
|
FormattedCharacterRange |
Represents a range of characters within the cell or comment text.
|
FreeLimitEventArgs |
Provides data for the free limit reached event.
|
HeaderFooter |
Represents worksheet's header or footer.
|
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. |
HorizontalPageBreak |
Specifies a horizontal position where the new page begins when the worksheet is printed.
|
HorizontalPageBreakCollection |
Collection of horizontal page breaks (
HorizontalPageBreak ). |
HtmlExportPosition |
Data that describes the current position in the exporter methods.
|
HtmlLoadOptions |
Represents options for loading from HyperText Markup Language File (HTML) format.
|
HtmlSaveOptions |
Represents options for saving to HyperText Markup Language File (HTML) format.
|
IgnoredError |
Represents a single ignored error for a range of cells.
|
IgnoredErrorCollection |
Represents a collection of an ignored errors in the worksheet.
|
LengthUnitConverter |
Utility class used for converting values between various
LengthUnit measurement units. |
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<T extends PageBreak> |
Base class for page break collections.
|
ProtectedRange |
Represents a range of cells to be protected.
|
ProtectedRangeCollection |
Represents a collection of all protected ranges on the
ExcelWorksheet . |
RowColumn |
Tuple representing row and column index
|
SaveOptions |
Represents a base class for saving options of various file formats.
|
SheetHeaderFooter |
Represents sheet header/footer.
|
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.
|
SpreadsheetHyperlink |
Hyperlink class.
|
SpreadsheetHyperlinkCollection |
Collection of hyperlinks (
SpreadsheetHyperlink ). |
SpreadsheetIcon |
Represents a spreadsheet icon.
|
SpreadsheetInfo |
Contains static licensing methods and diagnostic information about executing GemBox.Spreadsheet assembly.
|
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).
|
ValuesFilter |
Represents a filter that filters by a list of values.
|
VerticalPageBreak |
Specifies a vertical position where the new page begins when the worksheet is printed.
|
VerticalPageBreakCollection |
Collection of vertical page breaks (
VerticalPageBreak ). |
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).
|
Enum | Description |
---|---|
BuiltInCellStyleName |
Represents a built-in style name.
|
BuiltInDocumentProperties |
Enumeration of available built-in document properties.
|
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.
|
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.
|
DateTimeGroupLevel |
Represents a level of a
DateTimeGroup . |
DynamicFilterType |
Represents a dynamic filter type.
|
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.
|
ExcelPictureFormat |
Picture formats.
|
FillPatternStyle |
Represents the style of fill pattern being used for a cell format.
|
FilterOperator |
Operator enumerations for filtering.
|
FilterType |
Represents a filter type.
|
FreeLimitReachedAction |
Type of action that can be chosen when free limit is reached.
|
GradientShadingStyle |
Represents a shading style and variant of a gradient fill effect.
|
HeaderFooterFieldType |
Represents types of
HeaderFooterSection predefined fields. |
HorizontalAlignmentStyle |
Represents available horizontal alignment options used in
CellStyle horizontal alignment member. |
HtmlType |
Defines type of HTML export.
|
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.
|
MultipleBorders |
Represents multiple border types of a cell.
|
NumberType |
Specifies numeric type
|
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. |
RangeIndexingMode |
Indexing modes used by
CellRange . |
RemoveShiftDirection |
Represents the possible cell remove shift directions.
|
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.
|
SheetType |
Specifies the sheet type.
|
SheetVisibility |
Script positions used in
ExcelWorksheet visibility . |
SpreadsheetIconStyle |
Represents an enumeration of visually distinct icon sets.
|
UnderlineStyle |
Represents the different types of possible underline formatting used in
ExcelFont.getUnderlineStyle() member. |
VerticalAlignmentStyle |
Represents available vertical alignment options used in
CellStyle.setVerticalAlignment(com.gembox.spreadsheet.VerticalAlignmentStyle) member. |
ViewType |
Specifies the view type.
|
XlsxType |
OpenXML file type.
|
Exception | Description |
---|---|
FreeLimitReachedException |
Exception that occurs when free limit is reached.
|
SpreadsheetException |
Represents errors that can occur in the GemBox.Spreadsheet component.
|
© GemBox d.o.o. — All rights reserved.