Python Openpyxl Read Excel File Example

Hi Dev,

In this example, I will show you python read excel file openpyxl. We will look at an example of python read xls file openpyxl. step by step explain how to read excel file in python using openpyxl. I explained simply about python openpyxl read excel file.

In this example, we will read excel file using python openpyxl module. we will use load_workbook() function to read excel file date using python openpyxl. so let's see a simple example.

You can use these examples with python3 (Python 3) version.

If you haven't install openpyxl in your system then you can install using the below command:

pip install openpyxl

Example 1:

I simply created data.xlsx file with content as like below, we will use same file for both example:

demo.xlsx

main.py

import openpyxl
  
# Define variable to load the dataframe
dataframe = openpyxl.load_workbook("demo.xlsx")
   
# Define variable to read sheet
data = dataframe.active
   
# Display Row Data
for row in range(0, data.max_row):
    for col in data.iter_cols(1, data.max_column):
        print(col[row].value)

Output:

ID
Name
Email
1
Hardik Savani
hardik@gmail.com
2
Vimal Kashiyani
vimal@gmail.com
3
Harshad Pathak
harshad@gmail.com

Example 2: Read Excel file with Multiple Sheets

I simply created data.xlsx file with SheetOne and SheetTwo as like below, we will use same file for both example:

demo.xlsx: SheetOne

demo.xlsx: SheetTwo

main.py

import openpyxl
   
# Define variable to load the dataframe
dataframe = openpyxl.load_workbook("demo.xlsx")
  
# Read SheetOne
sheetOne = dataframe['SheetOne']
   
# Iterate the loop to read the cell values
for row in range(0, sheetOne.max_row):
    for col in sheetOne.iter_cols(1, sheetOne.max_column):
        print(col[row].value)
   
# Read SheetTwo
sheetTwo = dataframe['SheetTwo']
   
# Iterate the loop to read the cell values
for row in range(0, sheetTwo.max_row):
    for col in sheetTwo.iter_cols(1, sheetTwo.max_column):
        print(col[row].value)

Output:

ID
Name
Email
1
Hardik Savani
hardik@gmail.com
2
Vimal Kashiyani
vimal@gmail.com
3
Harshad Pathak
harshad@gmail.com
      
ID
Name
1
Hardik
2
Vimal
3
Harshad

I hope it can help you...