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.
pip install xlrd
Now we can read the data in xlsx file by importing xlrd in python.
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.
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.
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.
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.