How to get sheet names using openpyxl - Python

The openpyxl library is widely used to handle excel files using Python. Often when dealing with excel files one might have noticed multiple sheets. The sheets are normally mentioned in the bottom left corner of the screen. One can install this library by running the following command.

pip install openpyxl

In this article, we will be seeing how to get the names of these sheets and display them using openpyxl.

The file we will be using here is named Example.xlsx and has the following sheets. 

Python Codde to get sheet names using Openpyxl

First, we need to import the openpyxl library. After this, we will load our excel sheet Example.xlsx. Then by using the function sheetnames we can get a list of names of all the sub sheets that are present in the main sheet.

Output:

['sales_q1', 'sales_q3', 'sales_q4', 'sales_q2', 'sales_monthly']
Active sheet: <Worksheet "sales_q1">
Active sheet: <Worksheet "sales_monthly">