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)
#!/usr/bin/env python # encoding: utf-8 # @author: liusir # @file: read_excel.py # @time: 2020/7/1 9:13 下午 import os import xlrd from common.excel_utils import ExcelUtils # excel_path = os.path.join( os.path.dirname(__file__) , 'data/test_data.xlsx' ) excel_path = os.path.join( os.path.dirname(__file__) , 'data/datashell.xls' ) excelUtils = ExcelUtils(excel_path,"Sheet1") print(excelUtils.get_merged_cell_value(4,0) ) print(excelUtils.get_row_count()) sheet_list = [] for row in range(1,excelUtils.get_row_count()): #s 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) # 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) # row_dict["五"] = excelUtils.get_merged_cell_value(row, 4) sheet_list.append( row_dict ) # # for row in sheet_list: # print( row )
#@author:k #@file:read_excel.py #@time:2020/12/28 15:43 下午 import os import xlrd from common.excel_utils import ExcelUtils excel_path = os.path.join(os.path.dirname(__file__), 'data/test_data.xlsx') excelUtils = ExcelUtils(excel_path, 'Sheet1') # print(excelUtils.get_merged_cell_value(4, 0)) # 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) # for row in sheet_list: # print(row) all_data_list = [] first_row = excelUtils.sheet.row(0) # print(first_row) 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(