pandas.ExcelFile.book

property ExcelFile.book

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']