Get startedGet started for free

pd.ExcelFile() function

It's rare that you'll have a spreadsheet with just one tab. In this chapter, we'll use multi-tabbed workbook, theater_report.xlsx that will give us some more details on our movie sales. Before we learn about what's in it, we've got to get it into Python.

The pandas package has already been loaded for you as pd to help you with this task.

This exercise is part of the course

Python for Spreadsheet Users

View Course

Exercise instructions

  • Use your new ExcelFile() function to read in theater_report.xlsx and assign the result to theater_report.
  • Print the workbook object.

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

# Read in the whole workbook


# Print the workbook
print(____)
Edit and Run Code