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

>>> file.book.path
'/xl/workbook.xml'
>>> file.book.active

>>> file.book.sheetnames
['Sheet1', 'Sheet2']