ChartDataWorkbook
ChartDataWorkbook class
Provides access to embedded Excel workbook
Name | Description |
---|
calculateFormulas() | Calculates all formulas in the workbook and updates corresponding cells values. |
Error
Error | Condition |
---|
CellUnsupportedDataException | Cell data is not supported. |
clear
Name | Description |
---|
clear(int) | Clear all cells values on sheet |
Parameters:
Name | Type | Description |
---|
sheetIndex | int | Index of sheet |
getCell
Name | Description |
---|
getCell(String, int, int) | Gets the cell that can be used for chart series or categories |
Parameters:
Name | Type | Description |
---|
worksheetName | String | Name of the worksheet. |
row | int | The row. |
column | int | The column. |
Returns:
ChartDataCell
getCell
Name | Description |
---|
getCell(int, int, int) | Gets the cell that can be used for chart series or categories |
Parameters:
Name | Type | Description |
---|
worksheetIndex | int | Index of the worksheet. |
row | int | The row. |
column | int | The column. |
Returns:
ChartDataCell
getCell
Name | Description |
---|
getCell(int, String) | Gets the cell that can be used for chart series or categories |
Parameters:
Name | Type | Description |
---|
worksheetIndex | int | Index of the worksheet. |
cellName | String | Name of the cell. |
Returns:
ChartDataCell
getCell
Name | Description |
---|
getCell(int, String, Object) | Gets the cell that can be used for chart series or categories |
Parameters:
Name | Type | Description |
---|
worksheetIndex | int | Index of the worksheet. |
cellName | String | Name of the cell. |
value | Object | The value. |
Returns:
ChartDataCell
getCell
Name | Description |
---|
getCell(int, int, int, Object) | Gets the cell that can be used for chart series or categories |
Parameters:
Name | Type | Description |
---|
worksheetIndex | int | Index of the worksheet. |
row | int | The row. |
column | int | The column. |
value | Object | The value. |
Returns:
ChartDataCell
getCellCollection
Name | Description |
---|
getCellCollection(String, boolean) | Gets the set of cells. |
Parameters:
Name | Type | Description |
---|
formula | String | Excel formula like “Sheet1!$A$2:$A$5”. |
skipHiddenCells | boolean | If true then method returns collection without hidden cells. |
Returns:
ChartCellCollection
getWorksheets
Name | Description |
---|
getWorksheets() | Gets a collection of worksheets. |
Returns:
ChartDataWorksheetCollection