def excelToDictLs(sheet):
c_count=sheet.max_column
excelDictList=[]
titleList = []
for i in range(0,c_count):
contextList=[]
for cell in list(sheet.rows)[i]:
if i<1:
titleList.append(cell.value)
else:
contextList.append(cell.value)
if i>0:
dict={}
for j in range(0,len(titleList)):
dict[titleList[j]]=contextList[j]
excelDictList.append(dict)