Package | Description |
---|---|
com.gembox.spreadsheet |
Contains classes and enums that constitute GemBox.Spreadsheet object model.
|
com.gembox.spreadsheet.charts |
Contains types used to display series of numeric data in a graphical format.
|
com.gembox.spreadsheet.tables |
Contains types that constitute model of Tables.
|
Modifier and Type | Method and Description |
---|---|
CellRange |
CellRangeCollection.add(ExcelWorksheet worksheet,
String cellReference)
Adds the
CellRange from the specified worksheet to the collection. |
CellRange |
CellRange.clipOutsideIncompleteMergedRanges()
Deprecated.
This method is internal and should not be used.
|
CellRange |
CellRange.clipOutsideIncompleteMergedRanges(com.gembox.internal.core.OutObject<Boolean> hasAnyIncompleteMergedRange)
Deprecated.
This method is internal and should not be used.
|
static CellRange |
CellRange.create(ExcelWorksheet parent,
CellRange sourceRange)
Deprecated.
This method is internal and should not be used.
|
static CellRange |
CellRange.create(ExcelWorksheet parent,
int firstRow,
int firstColumn,
int lastRow,
int lastColumn)
Deprecated.
This method is internal and should not be used.
|
CellRange |
ExcelWorksheet.getCells()
Gets all the cells in the sheet.
|
CellRange |
ExcelColumnRowBase.getCells()
Gets cell range with column / row cells.
|
CellRange |
ExcelCell.getCurrentRegion()
Selects a worksheet region to which the cell belongs to.
|
CellRange |
CellRange.getCurrentRegion()
Selects a worksheet region to which the cell range belongs to.
|
CellRange |
ExcelCell.getMergedRange()
Returns associated merged range if the cell is merged; otherwise,
null . |
CellRange |
CellRangeIterator.getParent()
Parent
CellRange . |
CellRange |
SortState.getRange()
Gets the range to sort.
|
CellRange |
NamedRange.getRange()
Gets the named cell range.
|
CellRange |
HtmlExportPosition.getRange()
Gets the cell range that is exporting to HTML.
|
CellRange |
AutoFilter.getRange()
Gets the range to filter.
|
CellRange |
CellRange.getRelativeSubrange(int relativeRow,
int relativeColumn,
int width,
int height,
boolean switchRowColumn)
Deprecated.
This method is internal and should not be used.
|
CellRange |
ExcelWorksheet.getRenderingCellRange()
Deprecated.
This method is internal and should not be used.
|
CellRange |
CellRange.getSubrange(String reference)
Returns new cell range using A1 style notation.
|
CellRange |
CellRange.getSubrange(String firstCell,
String lastCell)
Returns new cell range using start and end position.
|
CellRange |
CellRange.getSubrangeAbsolute(int firstAbsoluteRow,
int firstAbsoluteColumn,
int lastAbsoluteRow,
int lastAbsoluteColumn)
Returns new cell range using absolute indexing.
|
CellRange |
CellRange.getSubrangeRelative(int relativeRow,
int relativeColumn,
int width,
int height)
Returns new cell range using relative indexing.
|
CellRange |
ExcelWorksheet.getUsedCellRange(boolean ignoreCellsWithoutValue)
Calculates cell range that is used in the worksheet.
|
CellRange |
DefinedName.getValueAsRange()
Deprecated.
This method is internal and should not be used.
|
CellRange |
CellRange.intersectWith(CellRange other)
Deprecated.
This method is internal and should not be used.
|
CellRange |
CellRangeCollection.set(int index,
CellRange item) |
CellRange |
ExcelCell.toRange()
Deprecated.
This method is internal and should not be used.
|
CellRange |
CellRange.toRange()
Deprecated.
This method is internal and should not be used.
|
abstract CellRange |
AbstractRange.toRange()
Deprecated.
This method is internal and should not be used.
|
Modifier and Type | Method and Description |
---|---|
boolean |
CellRangeCollection.add(CellRange item) |
void |
CellRangeCollection.add(int index,
CellRange item) |
void |
NamedRangeCollection.add(String name,
CellRange range)
Adds a new named range.
|
void |
NamedRangeCollection.add(String name,
CellRange range,
boolean globalName)
Adds a new named range.
|
void |
ExcelWorksheet.addNamedRange(String name,
CellRange range)
Adds a new named range to this worksheet.
|
void |
ExcelWorksheet.addNamedRange(String name,
CellRange range,
boolean globalName)
Adds a new named range to this worksheet.
|
Table |
ExcelWorksheet.addTable(String name,
CellRange range,
boolean hasHeaders)
Adds a new
Table to the table collection of this worksheet. |
boolean |
CellRange.contains(CellRange other)
Deprecated.
This method is internal and should not be used.
|
void |
CellRange.copyConditionalFormatRules(CellRange sourceRange)
Deprecated.
This method is internal and should not be used.
|
void |
CellRange.copyConditionalFormatRules(CellRange sourceRange,
int expandRowCount)
Deprecated.
This method is internal and should not be used.
|
void |
CellRange.copyConditionalFormatRules(CellRange sourceRange,
int expandRowCount,
int expandColumnCount)
Deprecated.
This method is internal and should not be used.
|
void |
CellRange.copyDataValidations(CellRange sourceRange)
Deprecated.
This method is internal and should not be used.
|
void |
CellRange.copyDataValidations(CellRange sourceRange,
int expandRowCount)
Deprecated.
This method is internal and should not be used.
|
void |
CellRange.copyDataValidations(CellRange sourceRange,
int expandRowCount,
int expandColumnCount)
Deprecated.
This method is internal and should not be used.
|
static AutoFilter |
AutoFilter.create(CellRange range)
Deprecated.
This method is internal and should not be used.
|
static SortState |
SortState.create(CellRange range,
boolean allowLeftToRight)
Deprecated.
This method is internal and should not be used.
|
static CellRange |
CellRange.create(ExcelWorksheet parent,
CellRange sourceRange)
Deprecated.
This method is internal and should not be used.
|
CellRange |
CellRange.intersectWith(CellRange other)
Deprecated.
This method is internal and should not be used.
|
boolean |
CellRange.overlaps(CellRange range)
Checks if this cell range overlaps with another cell range.
|
CellRange |
CellRangeCollection.set(int index,
CellRange item) |
void |
NamedRangeCollection.setFilterRange(CellRange range)
Deprecated.
This method is internal and should not be used.
|
void |
NamedRangeCollection.setPrintArea(CellRange... ranges)
Sets multi-range print area.
|
void |
NamedRangeCollection.setPrintArea(CellRange range)
Sets print area.
|
void |
NamedRange.setRange(CellRange value)
Sets the named cell range.
|
void |
DefinedName.setValueFromRange(CellRange range)
Deprecated.
This method is internal and should not be used.
|
Modifier and Type | Method and Description |
---|---|
boolean |
CellRangeCollection.addAll(Collection<? extends CellRange> c) |
boolean |
CellRangeCollection.addAll(int index,
Collection<? extends CellRange> c) |
void |
NamedRangeCollection.setPrintArea(Iterable<CellRange> ranges)
Sets multi-range print area.
|
Constructor and Description |
---|
DataValidation(CellRange... cellRanges)
Initializes a new instance of the
DataValidation class with specified cell ranges on which this data validation will be applied. |
HtmlExportPosition(CellRange range,
ExcelRow sheetRow,
ExcelColumn sheetColumn,
int htmlRowIndex,
int htmlColumnIndex)
Creates new HTML export position.
|
Constructor and Description |
---|
DataValidation(Iterable<CellRange> cellRanges)
Initializes a new instance of the
DataValidation class with specified cell ranges on which this data validation will be applied. |
Modifier and Type | Method and Description |
---|---|
void |
ExcelChart.selectData(CellRange range)
Selects the data for the chart.
|
void |
ExcelChart.selectData(CellRange range,
boolean switchRowColumn)
Selects the data for the chart.
|
void |
ExcelChart.selectData(CellRange range,
boolean switchRowColumn,
boolean excludeCategoryLabels)
Selects the data for the chart.
|
void |
ExcelChart.selectData(CellRange range,
boolean switchRowColumn,
boolean excludeCategoryLabels,
boolean excludeSeriesNames)
Selects the data for the chart.
|
Modifier and Type | Method and Description |
---|---|
CellRange |
TableColumn.getDataRange()
Gets the column data range.
|
CellRange |
Table.getDataRange()
Gets the table data range.
|
CellRange |
Table.getFilterRange()
Deprecated.
This method is internal and should not be used.
|
CellRange |
Table.getFilterRange(CellRange selectedRange)
Deprecated.
This method is internal and should not be used.
|
CellRange |
TableColumn.getRange()
Gets the column range.
|
CellRange |
Table.getRange()
Gets the table range.
|
Modifier and Type | Method and Description |
---|---|
Table |
TableCollection.add(String name,
CellRange range,
boolean hasHeaders)
Adds a new
Table to the collection. |
static Table |
Table.create(String name,
CellRange range)
Deprecated.
This method is internal and should not be used.
|
CellRange |
Table.getFilterRange(CellRange selectedRange)
Deprecated.
This method is internal and should not be used.
|
© GemBox Ltd. — All rights reserved.