xlrd module is used to extract data from a spreadsheet. xlrd has explicitly removed support for reading xlsx sheets.
To read an excel file in python , we will use xlrd module to retrieve information from a spreadsheet. The command need to be installed is xlrd module . xlrd module is used to extract data from a spreadsheet.
import xlrd location = “C:\\Users\\ \\Documents\\demo.xlsx”
wb = xlrd.open_workbook(location)
sheet = wb.sheet_by_index(0)
To write to an excel file in Python, we can use xlsx module and we can perform multiple operations on the spreadsheet, also we can modify the data on python. The command need to be installed is xlsxwriter modul .
Using xlrd module anyone can retrieve information from spreadsheet