ExcelDataWorkbook class

ExcelDataWorkbook class

Represents a workbook that provides access to Excel data for general use.

The ExcelDataWorkbook type exposes the following members:

Constructors

ConstructorDescription
__init__(self, file_path)Initializes a new instance using the specified file path.
__init__(self, stream)Initializes a new instance of the class using the provided stream.

Methods

MethodDescription
get_cell(self, worksheet_index, row, column)Retrieves a cell from the specified worksheet using its index and cell coordinates.
get_cell(self, worksheet_name, row, column)Retrieves a cell from the specified worksheet using its name and cell coordinates.
get_cell(self, worksheet_index, cell_name)Retrieves a cell from the specified worksheet using its index and Excel-style cell name (e.g., “B2”).
get_cell(self, worksheet_name, cell_name)Retrieves a cell from the specified worksheet using Excel-style cell name (e.g., “B2”).
get_cells(self, formula, skip_hidden_cells)Retrieves a collection of cells from the workbook that match the specified formula.
get_charts_from_worksheet(self, worksheet_name)Retrieves a dictionary containing the indexes and names of all charts in the specified worksheet of an Excel workbook.
get_worksheet_names(self)Retrieves the names of all worksheets contained in the Excel workbook.

See Also