I am using python xlrd http://scienceoss.com/read-excel-files-from-python/ to read data from an excel sheet
My question is if i read a row with first cell as "Employee name" in the excel sheet
And there is another row named whose first cell is "Employee name"
How can we read the last column starting with the last row which has "Employee name" in the first cell.Ignoring the previous
wb = xlrd.open_workbook(file,encoding_override="cp1252")
wb.sheet_names()
sh = wb.sheet_by_index(0)
num_of_rows = sh.nrows
num_of_cols = sh.ncols
valid_xl_format = 0
invalid_xl_format = 0
if(num_of_rows != 0):
for i in range(num_of_rows):
questions_dict = {}
for j in range(num_of_cols):
xl_data=sh.cell(i,j).value
if ((xl_data == "Employee name")):
# Regardless of how many "Employee name" found in rows first cell,Read only the last "Employee name"