Skip to main content
`Ctrl`+`K`

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