How to read xlsx file in python?

XLSX file popularly known as Excel file is a spreadsheet which makes us easy to store data in a tabular form. Now the question is that how can we read data from the excel file while writing a python program?

Firstly, we have to install xlrd module.

syntax:-

pip install xlrd

Now we can read the data in xlsx file by importing xlrd in python.

syntax:-

import xlrd
location_of_file=("path of file")
a=xlrd.open(location_of_file)
print(a)

In this way we can read xlsx file by importing xlrd.

We can also print data of a particular row or column.

syntax:-

import xlrd 
location_of_file=("path of file")
a=xlrd.open(location_of_file)
sheet_name.column_value(0,0)
print(sheet_name.column_value(0,0))

We have one more method to read xlsx file without xlrd.

We can import pandas and read an xlsx file.

syntax:-

import pandas as pd
data=pd.read_excel("file.xlsx", file_name='Sheet1')
print(data)

We can also read a data of a particular column or row by using pandas module.

syntax:-

import pandas as pd
data=pd.read_excel('location_of_file')
d=pd.dataframe(data, column['column_name'])
print(d)

We can also retrieve data of rows by calling their name as we did in columns.

This is all about reading data from a xlsx file in python.