public class ChartDataWorkbook extends java.lang.Object implements IChartDataWorkbook
Provides access to embedded Excel workbook
Modifier and Type | Method and Description |
---|---|
void |
clear(int sheetIndex)
Clear all cells values on sheet
|
IChartDataCell |
getCell(int worksheetIndex,
int row,
int column)
Gets the cell that can be used for chart series or categories
|
IChartDataCell |
getCell(int worksheetIndex,
int row,
int column,
java.lang.Object value)
Gets the cell that can be used for chart series or categories
|
IChartDataCell |
getCell(int worksheetIndex,
java.lang.String cellName)
Gets the cell that can be used for chart series or categories
|
IChartDataCell |
getCell(int worksheetIndex,
java.lang.String cellName,
java.lang.Object value)
Gets the cell that can be used for chart series or categories
|
IChartDataCell |
getCell(java.lang.String worksheetName,
int row,
int column)
Gets the cell that can be used for chart series or categories
|
IChartCellCollection |
getCellCollection(java.lang.String formula,
boolean skipHiddenCells)
Gets the set of cells.
|
com.aspose.slides.IDOMObject |
getParent_Immediate()
Returns Parent_Immediate object.
|
public final IChartCellCollection getCellCollection(java.lang.String formula, boolean skipHiddenCells)
Gets the set of cells.
getCellCollection
in interface IChartDataWorkbook
formula
- Excel formula like "Sheet1!$A$2:$A$5".skipHiddenCells
- If true then method returns collection without hidden cells.public final IChartDataCell getCell(java.lang.String worksheetName, int row, int column)
Gets the cell that can be used for chart series or categories
getCell
in interface IChartDataWorkbook
worksheetName
- Name of the worksheet.row
- The row.column
- The column.public final IChartDataCell getCell(int worksheetIndex, int row, int column)
Gets the cell that can be used for chart series or categories
getCell
in interface IChartDataWorkbook
worksheetIndex
- Index of the worksheet.row
- The row.column
- The column.public final IChartDataCell getCell(int worksheetIndex, java.lang.String cellName)
Gets the cell that can be used for chart series or categories
getCell
in interface IChartDataWorkbook
worksheetIndex
- Index of the worksheet.cellName
- Name of the cell.public final IChartDataCell getCell(int worksheetIndex, java.lang.String cellName, java.lang.Object value)
Gets the cell that can be used for chart series or categories
getCell
in interface IChartDataWorkbook
worksheetIndex
- Index of the worksheet.cellName
- Name of the cell.value
- The value.public final IChartDataCell getCell(int worksheetIndex, int row, int column, java.lang.Object value)
Gets the cell that can be used for chart series or categories
getCell
in interface IChartDataWorkbook
worksheetIndex
- Index of the worksheet.row
- The row.column
- The column.value
- The value.public final void clear(int sheetIndex)
Clear all cells values on sheet
clear
in interface IChartDataWorkbook
sheetIndex
- Index of sheetpublic final com.aspose.slides.IDOMObject getParent_Immediate()
Returns Parent_Immediate object.
Read-only IDOMObject
.