pandas.ExcelFile.book — pandas 3.0.0.dev0+2204.g51763f94fe documentation (original) (raw)

property ExcelFile.book[source]#

Gets the Excel workbook.

Workbook is the top-level container for all document information.

Returns:

Excel Workbook

The workbook object of the type defined by the engine being used.

See also

read_excel

Read an Excel file into a pandas DataFrame.

Examples

file = pd.ExcelFile("myfile.xlsx") file.book <openpyxl.workbook.workbook.Workbook object at 0x11eb5ad70> file.book.path '/xl/workbook.xml' file.book.active <openpyxl.worksheet._read_only.ReadOnlyWorksheet object at 0x11eb5b370> file.book.sheetnames ['Sheet1', 'Sheet2']