ChartDataWorkbook

ChartDataWorkbook class

Provides access to embedded Excel workbook

calculateFormulas

NameDescription
calculateFormulas ()Calculates all formulas in the workbook and updates corresponding cells values.

Error

ErrorCondition
CellUnsupportedDataExceptionCell data is not supported.

clear

NameDescription
clear (int)Clear all cells values on sheet

Parameters:

NameTypeDescription
sheetIndexintIndex of sheet

getCell

NameDescription
getCell (String, int, int)Gets the cell that can be used for chart series or categories

Parameters:

NameTypeDescription
worksheetNameStringName of the worksheet.
rowintThe row.
columnintThe column.

Returns: ChartDataCell


getCell

NameDescription
getCell (int, int, int)Gets the cell that can be used for chart series or categories

Parameters:

NameTypeDescription
worksheetIndexintIndex of the worksheet.
rowintThe row.
columnintThe column.

Returns: ChartDataCell


getCell

NameDescription
getCell (int, String)Gets the cell that can be used for chart series or categories

Parameters:

NameTypeDescription
worksheetIndexintIndex of the worksheet.
cellNameStringName of the cell.

Returns: ChartDataCell


getCell

NameDescription
getCell (int, String, Object)Gets the cell that can be used for chart series or categories

Parameters:

NameTypeDescription
worksheetIndexintIndex of the worksheet.
cellNameStringName of the cell.
valueObjectThe value.

Returns: ChartDataCell


getCell

NameDescription
getCell (int, int, int, Object)Gets the cell that can be used for chart series or categories

Parameters:

NameTypeDescription
worksheetIndexintIndex of the worksheet.
rowintThe row.
columnintThe column.
valueObjectThe value.

Returns: ChartDataCell


getCellCollection

NameDescription
getCellCollection (String, boolean)Gets the set of cells.

Parameters:

NameTypeDescription
formulaStringExcel formula like “Sheet1!$A$2:$A$5”.
skipHiddenCellsbooleanIf true then function returns collection without hidden cells.

Returns: ChartCellCollection


getWorksheets

NameDescription
getWorksheets ()Gets a collection of worksheets.

Returns: ChartDataWorksheetCollection