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....