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 function returns collection without hidden cells. |
Returns:
ChartCellCollection
getWorksheets
| Name | Description |
|---|
| getWorksheets () | Gets a collection of worksheets. |
Returns:
ChartDataWorksheetCollection