ExcelDataWorkbook class
Contents
[
Hide
]ExcelDataWorkbook class
Represents a workbook that provides access to Excel data for general use.
The ExcelDataWorkbook type exposes the following members:
Constructors
| Constructor | Description |
|---|---|
__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
| Method | Description |
|---|---|
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
- module
aspose.slides.excel - library
Aspose.Slides