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(