|
||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
public interface IChartDataWorkbook
Provides access to embedded Excel workbook
Method Summary | |
---|---|
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. |
Method Detail |
---|
IChartCellCollection getCellCollection(java.lang.String formula, boolean skipHiddenCells)
Gets the set of cells.
formula
- Excel formula like "Sheet1!$A$2:$A$5".skipHiddenCells
- If true then method returns collection without hidden cells.IChartDataCell getCell(java.lang.String worksheetName, int row, int column)
Gets the cell that can be used for chart series or categories
worksheetName
- Name of the worksheet.row
- The row.column
- The column.
IChartDataCell getCell(int worksheetIndex, int row, int column)
Gets the cell that can be used for chart series or categories
worksheetIndex
- Index of the worksheet.row
- The row.column
- The column.
IChartDataCell getCell(int worksheetIndex, java.lang.String cellName)
Gets the cell that can be used for chart series or categories
worksheetIndex
- Index of the worksheet.cellName
- Name of the cell.
IChartDataCell getCell(int worksheetIndex, java.lang.String cellName, java.lang.Object value)
Gets the cell that can be used for chart series or categories
worksheetIndex
- Index of the worksheet.cellName
- Name of the cell.value
- The value.
IChartDataCell getCell(int worksheetIndex, int row, int column, java.lang.Object value)
Gets the cell that can be used for chart series or categories
worksheetIndex
- Index of the worksheet.row
- The row.column
- The column.value
- The value.
void clear(int sheetIndex)
Clear all cells values on sheet
sheetIndex
- Index of sheet
|
||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |