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.pivottables |
Contains types that constitute model of Pivot Tables.
|
com.gembox.spreadsheet.tables |
Contains types that constitute model of Tables.
|
Modifier and Type | Method and Description |
---|---|
static ExcelCell |
ExcelCell.create(ExcelRow row,
int columnIndex)
Deprecated.
This method is internal and should not be used.
|
ExcelCell |
ExcelCellCollection.get(int index)
Gets the cell with the specified index.
|
ExcelCell |
CellRange.get(int contextIndex)
Gets excel cell at the specified index.
|
ExcelCell |
CellRange.get(int relativeRow,
int relativeColumn)
Gets excel cell at the specified relative position.
|
ExcelCell |
CellRange.get(String contextName)
Gets excel cell with the specified full or partial name.
|
ExcelCell |
ExcelRow.getCell(int contextIndex)
Gets excel cell at the specified index from this row.
|
ExcelCell |
ExcelColumn.getCell(int contextIndex)
Gets excel cell at the specified index from this column.
|
ExcelCell |
ExcelWorksheet.getCell(int rowIndex,
int columnIndex)
Gets excel cell at the specified position from this worksheet.
|
ExcelCell |
ExcelWorksheet.getCell(String contextName)
Gets excel cell with the specified full name from this worksheet.
|
ExcelCell |
ExcelRow.getCell(String contextName)
Gets excel cell with the specified partial name from this row.
|
ExcelCell |
ExcelColumn.getCell(String contextName)
Gets excel cell with the specified partial name from this column.
|
ExcelCell |
ExcelCellCollection.getLastCellWithValue()
Deprecated.
This method is internal and should not be used.
|
ExcelCell |
ExcelCell.getNeighbor(IndividualBorder side)
Deprecated.
This method is internal and should not be used.
|
static ExcelCell |
ExcelRowColumnCollectionBase.getReferenceCollectionFirstCell(com.gembox.spreadsheet.internal.excelreference.ExcelReferenceCollection excelReferences)
Deprecated.
This method is internal and should not be used.
|
ExcelCell |
CellRangeIterator.next()
Advances the iterator to the next element of the cell range.
|
Modifier and Type | Method and Description |
---|---|
Iterable<ExcelCell> |
CellRange.getAllocatedCells()
Deprecated.
This method is internal and should not be used.
|
Iterable<ExcelCell> |
ExcelWorksheet.getCells(String reference)
Deprecated.
This method is internal and should not be used.
|
Comparator<ExcelCell> |
SortLevel.getComparator()
Gets the comparison method that compares two
ExcelCell s. |
Predicate<ExcelCell> |
FilterColumn.getMatch()
Gets the method that defines a set of criteria and determines whether the specified
ExcelCell meets those criteria. |
Iterator<ExcelCell> |
ExcelCellCollection.iterator() |
Iterator<ExcelCell> |
CellRange.iterator()
Returns an iterator for the
CellRange (all cells). |
Modifier and Type | Method and Description |
---|---|
PivotTable |
ExcelWorksheet.addPivotTable(PivotCache pivotCache,
String tableName,
ExcelCell topLeftCell)
Adds a new
PivotTable to the PivotTableCollection of this worksheet. |
int |
SortLevel.compare(ExcelCell x,
ExcelCell y)
Deprecated.
This method is internal and should not be used.
|
void |
ExcelCellCollection.insert(int index,
int count,
ExcelCell sourceCell,
boolean copyFormatOnly)
Deprecated.
This method is internal and should not be used.
|
boolean |
ValuesFilter.isMatch(ExcelCell cell)
Deprecated.
This method is internal and should not be used.
|
boolean |
Top10Filter.isMatch(ExcelCell cell)
Deprecated.
This method is internal and should not be used.
|
boolean |
FilterColumn.isMatch(ExcelCell cell)
Deprecated.
This method is internal and should not be used.
|
abstract boolean |
Filter.isMatch(ExcelCell cell)
Deprecated.
This method is internal and should not be used.
|
boolean |
DynamicFilter.isMatch(ExcelCell cell)
Deprecated.
This method is internal and should not be used.
|
boolean |
CustomFilter.isMatch(ExcelCell cell)
Deprecated.
This method is internal and should not be used.
|
Modifier and Type | Method and Description |
---|---|
SortState |
SortState.by(int columnRowIndex,
Comparator<ExcelCell> comparator)
Adds a
SortLevel applied to a column (or a row, if SortState.isLeftToRight() is true ) with the specified index (relative to the range ) and with the specified comparison method to sort by. |
AutoFilter |
AutoFilter.byPredicate(int columnIndex,
Predicate<ExcelCell> match)
Sets a custom filter method to a column with the specified index (relative to the
Range ). |
void |
SortLevel.setComparator(Comparator<ExcelCell> value)
Sets the comparison method that compares two
ExcelCell s. |
void |
FilterColumn.setMatch(Predicate<ExcelCell> match)
Sets the method that defines a set of criteria and determines whether the specified
ExcelCell meets those criteria. |
AutoFilter |
AutoFilter.sortBy(int columnIndex,
Comparator<ExcelCell> comparison)
|
Constructor and Description |
---|
AnchorCell(ExcelCell cell,
boolean topLeft)
Initializes a new instance of the
AnchorCell class. |
Modifier and Type | Method and Description |
---|---|
void |
SpreadsheetParserException.setCell(ExcelCell cell)
Deprecated.
This method is internal and should not be used.
|
Modifier and Type | Method and Description |
---|---|
ExcelCell |
PivotTable.getTopLeftCell()
Gets the location of this
PivotTable in the worksheet. |
Modifier and Type | Method and Description |
---|---|
PivotTable |
PivotTableCollection.add(PivotCache pivotCache,
String tableName,
ExcelCell topLeftCell)
Adds a new
PivotTable to the collection. |
void |
PivotTable.setTopLeftCell(ExcelCell value)
Deprecated.
This method is internal and should not be used.
|
Modifier and Type | Method and Description |
---|---|
ExcelCell |
TableColumn.getTotalCell()
Deprecated.
This method is internal and should not be used.
|
© GemBox Ltd. — All rights reserved.