Python Read Excel File Tutorial

Published On: 27/01/2023 | Category: Python


Hi Dev,

This article goes in detailed on how to extract data from excel using python. I explained simply about how to read excel file in python. This article goes in detailed on how to get data from excel file in python. Here you will learn how to read data from excel file in python.

Here, i will describe you of two example pandas and openpyxl to read and get excel file data in python.

I basically created demo.xlsx file in file put the three id, name and email row with content as like below, we will use same file for both example:

So let's see bellow example:

Example 1: Using Pandas

main.py
# import pandas library as pd
import pandas as pd
   
# get by default 1st sheet of demo excel file
data = pd.read_excel('demo.xlsx')
   
print(data)
Output
   ID             Name              Email
0   1   Bhavesh Sonagra   [email protected]
1   2   Nikhil Thumar     [email protected]
2   3   Piyush Kamani     [email protected]

Example 1: Using openpyxl

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
Bhavesh Sonagra
[email protected]
2
Nikhil Thumar
[email protected]
3
Piyush Kamani
[email protected]

It will help you....