ChartDataWorkbook class

ChartDataWorkbook class

Provides access to embedded Excel workbook

The ChartDataWorkbook type exposes the following members:

Properties

PropertyDescription
worksheetsGets a collection of worksheets.

Methods

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

See Also