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__Initializes a new instance using the specified file path.
__init__Initializes a new instance of the class using the provided stream.

Methods

MethodDescription
get_cellRetrieves a cell from the specified worksheet using its index and cell coordinates.
get_cellRetrieves a cell from the specified worksheet using its name and cell coordinates.
get_cellRetrieves a cell from the specified worksheet using its index and Excel-style cell name (e.g., “B2”).
get_cellRetrieves a cell from the specified worksheet using Excel-style cell name (e.g., “B2”).
get_cellsRetrieves a collection of cells from the workbook that match the specified formula.
get_charts_from_worksheetRetrieves a dictionary containing the indexes and names of all charts in the specified worksheet of an Excel workbook.
get_worksheet_namesRetrieves the names of all worksheets contained in the Excel workbook.

See Also