Question

Create a Python program that opens and reads an excel file (xlsx). Display excel file in legible format. Include the program as a function.

Answer 1

code:

file :

output :

raw_code :

import xlrd #importing module
def open_excel():
location = "data.xlsx" #location of file

#opening workbook
wbook = xlrd.open_workbook(location)
sheet = wbook.sheet_by_index(0)
  
#printing each cell
for i in range(sheet.nrows):
for j in range(sheet.ncols):
print(str(sheet.cell_value(i,j))+'\t',end='')
print('\n')

#calling functoin
open_excel()
  

***do comment for queries and rate me up***