def xlrd_sheet_to_list_of_dict(sheet: Sheet) -> List[Dict]:
"""Convert an xlrd sheet into a list of dicts."""
keys = [sheet.cell(0, col_index).value for col_index in range(sheet.ncols)]
dict_list = []
for row_index in range(1, sheet.nrows):
d = {keys[col_index]: sheet.cell(row_index, col_index).value
for col_index in range(sheet.ncols)}
dict_list.append(d)
return dict_list
def process_table(self, row_index:int, sheet:Sheet):
self.current_table_name = sheet.cell(row_index, 0).value
self.current_table = Table(self.schema, self.current_table_name, [], [])
def read_student_info(sheet: Sheet, file_name: str) -> dict:
student_id = file_name.replace('student_', '').replace('.xlsx', '')
student_name = sheet.cell(0, 4).value
student_score = round(sheet.cell(15, 4).value, 1)
print('[read_student_info]\t' + student_id + ' : ' + student_name + ' : ' + str(student_score))
return {'id': student_id, 'name': student_name, 'score': student_score}
def process_schema(self, row_index:int, sheet:Sheet):
self.schema = sheet.cell(row_index, 0).value
