1 def get_excel_content(excel_path): 2 contents = [] 3 if self.log_path.endswith('xls'): 4 workbook = xlrd.open_workbook(excel_path, formatting_info=True) 5 sheet = workbook.sheet_by_index(0) 6 start_row = 0 7 for cell in sheet.merged_cells: 8 row, row_range, col, col_range = cell 9 if row != start_row: 10 # print() 11 start_row = row 12 at_1st_col = True 13 else: 14 at_1st_col = False 15 if at_1st_col or start_row == 0: 16 content = [item for item in sheet.row_values(row) if (item and item != '/' or item == 0)] 17 if content: 18 # print(content, end=" ") 19 contents.append(content) 20 return contents