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.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.
|
Modifier and Type | Method and Description |
---|---|
ExcelWorksheet |
ExcelWorksheetCollection.add(SheetType type,
String worksheetName)
Adds an empty worksheet to the end of the collection.
|
ExcelWorksheet |
ExcelWorksheetCollection.add(String worksheetName)
Adds an empty worksheet to the end of the collection.
|
ExcelWorksheet |
ExcelWorksheetCollection.addCopy(String destinationWorksheetName,
ExcelWorksheet sourceWorksheet)
Adds a copy of an existing worksheet to the end of the collection.
|
ExcelWorksheet |
ExcelFile.addWorksheet(String worksheetName)
Adds an empty worksheet to the end of the worksheet collection of this workbook.
|
ExcelWorksheet |
ExcelWorksheetCollection.find(String name)
Deprecated.
This method is internal and should not be used.
|
ExcelWorksheet |
ExcelWorksheetCollection.get(int index)
Gets the worksheet with the specified index.
|
ExcelWorksheet |
ExcelWorksheetCollection.get(String name)
Gets the worksheet with the specified name.
|
ExcelWorksheet |
ExcelWorksheetCollection.getActiveWorksheet()
Gets active worksheet.
|
ExcelWorksheet |
ExcelDrawingCollectionImpl.getExcelDrawingCollectionWorksheet()
Deprecated.
This method is internal and should not be used.
|
ExcelWorksheet |
ExcelRowColumnCellCollectionBase.getParent()
Deprecated.
This method is internal and should not be used.
|
ExcelWorksheet |
ExcelCommentCollection.getParent()
Deprecated.
This method is internal and should not be used.
|
ExcelWorksheet |
ExcelColumnRowBase.getParent()
Deprecated.
This method is internal and should not be used.
|
ExcelWorksheet |
AbstractRange.getParent()
Deprecated.
This method is internal and should not be used.
|
ExcelWorksheet |
ProtectedRangeCollection.getWorksheet()
Deprecated.
This method is internal and should not be used.
|
ExcelWorksheet |
ExcelDrawingCollectionImpl.getWorksheet()
Deprecated.
This method is internal and should not be used.
|
ExcelWorksheet |
ExcelDrawing.getWorksheet()
Deprecated.
This method is internal and should not be used.
|
ExcelWorksheet |
ExcelComment.getWorksheet()
Deprecated.
This method is internal and should not be used.
|
ExcelWorksheet |
ExcelCell.getWorksheet()
Gets the parent worksheet.
|
ExcelWorksheet |
AnchorCell.getWorksheet()
Deprecated.
This method is internal and should not be used.
|
ExcelWorksheet |
AbstractRange.getWorksheet()
Deprecated.
This method is internal and should not be used.
|
ExcelWorksheet |
ExcelFile.getWorksheet(int index)
Gets the worksheet from the worksheet collection of this workbook with the specified index.
|
ExcelWorksheet |
ExcelFile.getWorksheet(String name)
Gets the worksheet from the worksheet collection of this workbook with the specified name.
|
ExcelWorksheet |
ExcelWorksheetCollection.insertCopy(int worksheetIndex,
String worksheetName,
ExcelWorksheet sourceWorksheet)
Inserts a copy of an existing worksheet at the specified index.
|
ExcelWorksheet |
ExcelWorksheetCollection.insertCopyInternal(String destinationWorksheetName,
int position,
ExcelWorksheet sourceWorksheet)
Deprecated.
This method is internal and should not be used.
|
ExcelWorksheet |
ExcelWorksheetCollection.insertEmpty(int worksheetIndex,
SheetType type,
String worksheetName)
Inserts empty worksheet at the specified index.
|
ExcelWorksheet |
ExcelWorksheetCollection.insertEmpty(int worksheetIndex,
String worksheetName)
Inserts empty worksheet at the specified index.
|
ExcelWorksheet |
ExcelWorksheetCollection.insertInternal(SheetType type,
String worksheetName,
int position)
Deprecated.
This method is internal and should not be used.
|
Modifier and Type | Method and Description |
---|---|
Iterator<ExcelWorksheet> |
ExcelWorksheetCollection.iterator()
Returns an iterator for the
ExcelWorksheetCollection . |
Modifier and Type | Method and Description |
---|---|
CellRange |
CellRangeCollection.add(ExcelWorksheet worksheet,
String cellReference)
Adds the
CellRange from the specified worksheet to the collection. |
ExcelWorksheet |
ExcelWorksheetCollection.addCopy(String destinationWorksheetName,
ExcelWorksheet sourceWorksheet)
Adds a copy of an existing worksheet to the end of the collection.
|
void |
DefinedNameCollection.clearNames(ExcelWorksheet scope)
Deprecated.
This method is internal and should not be used.
|
ExcelDrawingPosition |
ExcelDrawingPosition.clone(ExcelWorksheet worksheet)
Deprecated.
This method is internal and should not be used.
|
AnchorCell |
AnchorCell.clone(ExcelWorksheet worksheet)
Deprecated.
This method is internal and should not be used.
|
boolean |
ExcelWorksheetCollection.contains(ExcelWorksheet item)
Determines whether an
ExcelWorksheet element is in the ExcelWorksheetCollection . |
void |
CellRange.copyTo(ExcelWorksheet destinationWorksheet,
int absoluteRow,
int absoluteColumn)
Copies this cell range to another worksheet.
|
void |
CellRange.copyTo(ExcelWorksheet destinationWorksheet,
String topLeftCell)
Copies this cell range to another worksheet.
|
static ExcelDrawingPosition |
ExcelDrawingPosition.create(ExcelWorksheet worksheet,
AnchorCell positionFrom,
AnchorCell positionTo)
Deprecated.
This method is internal and should not be used.
|
static ExcelDrawingPosition |
ExcelDrawingPosition.create(ExcelWorksheet worksheet,
AnchorCell positionFrom,
double width,
double height)
Deprecated.
This method is internal and should not be used.
|
static AutoFilter |
AutoFilter.create(ExcelWorksheet destination,
AutoFilter source)
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 ExcelDrawingPosition |
ExcelDrawingPosition.create(ExcelWorksheet worksheet,
double left,
double top,
double width,
double height)
Deprecated.
This method is internal and should not be used.
|
static ExcelRow |
ExcelRow.create(ExcelWorksheet parent,
int index)
Deprecated.
This method is internal and should not be used.
|
static ExcelColumn |
ExcelColumn.create(ExcelWorksheet parent,
int index)
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.
|
static SortState |
SortState.create(ExcelWorksheet destination,
SortState source)
Deprecated.
This method is internal and should not be used.
|
void |
ExcelWorksheetCollection.deleteInternal(ExcelWorksheet ws,
boolean clearWorksheet)
Deprecated.
This method is internal and should not be used.
|
static AnchorCell |
AnchorCell.fromCell(String cell,
ExcelWorksheet worksheet,
boolean topLeft)
Deprecated.
This method is internal and should not be used.
|
int |
DefinedNameCollection.getNameIndex(String name,
ExcelWorksheet scope)
Deprecated.
This method is internal and should not be used.
|
com.gembox.spreadsheet.internal.ExcelDrawingCollection |
ExcelPicture.getParent(ExcelWorksheet worksheet)
Deprecated.
This method is internal and should not be used.
|
abstract com.gembox.spreadsheet.internal.ExcelDrawingCollection |
ExcelDrawing.getParent(ExcelWorksheet worksheet)
Deprecated.
This method is internal and should not be used.
|
int |
ExcelWorksheetCollection.indexOf(ExcelWorksheet ws)
Deprecated.
This method is internal and should not be used.
|
ExcelWorksheet |
ExcelWorksheetCollection.insertCopy(int worksheetIndex,
String worksheetName,
ExcelWorksheet sourceWorksheet)
Inserts a copy of an existing worksheet at the specified index.
|
ExcelWorksheet |
ExcelWorksheetCollection.insertCopyInternal(String destinationWorksheetName,
int position,
ExcelWorksheet sourceWorksheet)
Deprecated.
This method is internal and should not be used.
|
int |
DefinedNameCollection.selectCount(ExcelWorksheet scope)
Deprecated.
This method is internal and should not be used.
|
DefinedName |
DefinedNameCollection.selectName(String name,
ExcelWorksheet scope)
Deprecated.
This method is internal and should not be used.
|
DefinedName |
DefinedNameCollection.selectNameAt(int index,
ExcelWorksheet scope)
Deprecated.
This method is internal and should not be used.
|
DefinedName |
DefinedNameCollection.selectNameExact(String name,
ExcelWorksheet scope)
Deprecated.
This method is internal and should not be used.
|
Iterable<DefinedName> |
DefinedNameCollection.selectNames(ExcelWorksheet scope)
Deprecated.
This method is internal and should not be used.
|
void |
ExcelWorksheetCollection.setActiveWorksheet(ExcelWorksheet value)
Gets active worksheet.
|
void |
ProtectedRangeCollection.setWorksheet(ExcelWorksheet worksheet)
Deprecated.
This method is internal and should not be used.
|
void |
ExcelDrawingCollectionImpl.setWorksheet(ExcelWorksheet value)
Deprecated.
This method is internal and should not be used.
|
Constructor and Description |
---|
DataValidation(ExcelWorksheet worksheet,
Iterable<String> cellReferences)
Initializes a new instance of the
DataValidation class with specified worksheet and cell references on which this data validation will be applied. |
DataValidation(ExcelWorksheet worksheet,
String... cellReferences)
Initializes a new instance of the
DataValidation class with specified worksheet and cell references on which this data validation will be applied. |
ExcelDrawingCollectionImpl(ExcelWorksheet worksheet)
Deprecated.
This method is internal and should not be used.
|
Modifier and Type | Method and Description |
---|---|
static ExcelChartCollection |
ExcelChartCollection.create(ExcelWorksheet worksheet)
Deprecated.
This method is internal and should not be used.
|
static ExcelChartCollection |
ExcelChartCollection.create(ExcelWorksheet worksheet,
ExcelChartCollection source)
Deprecated.
This method is internal and should not be used.
|
com.gembox.spreadsheet.internal.ExcelDrawingCollection |
ExcelChart.getParent(ExcelWorksheet worksheet)
Deprecated.
This method is internal and should not be used.
|
Modifier and Type | Method and Description |
---|---|
ExcelWorksheet |
ConditionalFormatRuleCollection.getSheet()
Deprecated.
This method is internal and should not be used.
|
Modifier and Type | Method and Description |
---|---|
static ConditionalFormatRuleCollection |
ConditionalFormatRuleCollection.create(ExcelWorksheet sheet)
Deprecated.
This method is internal and should not be used.
|
static ConditionalFormatRuleCollection |
ConditionalFormatRuleCollection.create(ExcelWorksheet sheet,
ConditionalFormatRuleCollection source)
Deprecated.
This method is internal and should not be used.
|
void |
ConditionalFormatRuleCollection.setSheet(ExcelWorksheet value)
Deprecated.
This method is internal and should not be used.
|
Modifier and Type | Method and Description |
---|---|
ExcelWorksheet |
PivotTableCollection.getWorksheet()
Deprecated.
This method is internal and should not be used.
|
Modifier and Type | Method and Description |
---|---|
static PivotTableCollection |
PivotTableCollection.create(ExcelWorksheet worksheet)
Deprecated.
This method is internal and should not be used.
|
static PivotTableCollection |
PivotTableCollection.create(ExcelWorksheet worksheet,
PivotTableCollection sourceCollection)
Deprecated.
This method is internal and should not be used.
|
Modifier and Type | Method and Description |
---|---|
static TableCollection |
TableCollection.create(ExcelWorksheet worksheet)
Deprecated.
This method is internal and should not be used.
|
static TableCollection |
TableCollection.create(ExcelWorksheet worksheet,
TableCollection sourceCollection)
Deprecated.
This method is internal and should not be used.
|
static Table |
Table.create(Table source,
ExcelWorksheet worksheet)
Deprecated.
This method is internal and should not be used.
|
© GemBox Ltd. — All rights reserved.