ChartDataWorkbook

ChartDataWorkbook class

Provides access to embedded Excel workbook

The ChartDataWorkbook type exposes the following members:

Properties

NameDescription
worksheetsGets a collection of worksheets.

Methods

NameDescription
get_cell(worksheet_name, row, column)Gets the cell that can be used for chart series or categories
get_cell(worksheet_index, row, column)Gets the cell that can be used for chart series or categories
get_cell(worksheet_index, cell_name)Gets the cell that can be used for chart series or categories
get_cell(worksheet_index, cell_name, value)Gets the cell that can be used for chart series or categories
get_cell(worksheet_index, row, column, value)Gets the cell that can be used for chart series or categories
get_cell_collection(formula, skip_hidden_cells)Gets the set of cells.
clear(sheet_index)Clear all cells values on sheet
calculate_formulas()Calculates all formulas in the workbook and updates corresponding cells values.

See Also