Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

How to Read and Write Excel Files in Python

Introduction
3. Getting a list of worksheets
Summary

Instruction

Good start! To read the names of the particular sheets, we can use the sheetnames property:

print(wb.sheetnames)
>> ["dairy", 'vegetables", "fruits", "sweets"]

As you can see, it contains a list of all the sheet names in that Excel file.

Exercise

We've saved the answer from the previous exercise. Print the names of all the sheets in that xlsx file. Use the sheetnames property.