import xlrd
from common.excel_utils import ExcelUtils
current_value = os.path.dirname(__file__)
excel_path = os.path.join(current_value, 'data/testl_data.xlsx')
excelUtils = ExcelUtils(excel_path, "Sheet1")
# print(excelUtils.get_merged_cell_value(8,0))
#自己
# sheet_list = []
# for row in range(1,excelUtils.get_row_count()):
# dict = {}
# for col in range(0,excelUtils.get_col_count()):
# # value = excelUtils.get_merged_cell_value(row,col)
# dict[excelUtils.get_merged_cell_value(0,col)] = excelUtils.get_merged_cell_value(row,col)
# sheet_list.append(dict)
#老师办法
all_data_list = []
first_row = excelUtils.sheet.row(0)
for row in range(1, excelUtils.get_row_count()):
row_dict = {}
for col in range(0, excelUtils.get_col_count()):
row_dict[first_row[col].value] = excelUtils.get_merged_cell_value(
row, col)
all_data_list.append(row_dict)
print('------------------------------')
for row in all_data_list:
print(row)
# **********************普通方法获取表格数据
# print(excelUtils.get_row_count())
# sheet_list = []
# for row in range(1, excelUtils.get_row_count()): # 表头不算在内
# row_dict = {} # 创建空字典 来存放没行数据
# row_dict['事件'] = excelUtils.get_merged_cell_value(row, 0)
# row_dict['步骤序号'] = excelUtils.get_merged_cell_value(row, 1)
# row_dict['步骤操作'] = excelUtils.get_merged_cell_value(row, 2)
# row_dict['完成情况'] = excelUtils.get_merged_cell_value(row, 3)
# sheet_list.append(row_dict)
#
# # print(sheet_list)
# # 利用循环输出某列的单元格内容
# for row in sheet_list:
# print(row)
# **********************改造方法：使用遍历方式获取(字典 列表)
all_data_list = []
first_row = excelUtils.sheet.row(0)
# print(first_row[1].value)
for row in range(1, excelUtils.get_row_count()): # 行循环
row_dict = {}
for col in range(1, excelUtils.get_col_count()): # 列循环
row_dict[first_row[col].value] = excelUtils.get_merged_cell_value(
row, col) # 将单元格值赋值给每行字典键值对值
all_data_list.append(row_dict)
for row in all_data_list:
print(row)