import xlrd
loc=(“your own excel path with double slash at drive name like C:\”)
wb = xlrd.open_workbook(loc)
sheet = wb.sheet_by_index(0)
print (“The value of Row 0 and Column 0 is”, sheet.cell_value(0, 0))
print(“No of Rows in the current sheet is”,sheet.nrows)
print(“No of Columns in the current sheet is”,sheet.ncols)
print(“Extracting all columns name in the current sheet”)
for i in range(sheet.ncols):
    print(sheet.cell_value(0, i))
print(“Extracting first column in the current sheet”)
for i in range(sheet.nrows):
    print(sheet.cell_value(i, 0))
print(“Extracting rowwise content in the current sheet”)
for i in range(sheet.nrows):
    print(sheet.row_values(i))

Source link

Python program for reading an excel file

Leave a Reply

Your email address will not be published. Required fields are marked *