Showing posts with label excel. Show all posts
Showing posts with label excel. Show all posts

Python program for reading an excel file

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))