unittest读取Excel文件

首先能添加openpyxl库

def read_excel():
workbook = openpyxl.load_workbook(‘excel.xlsx’)
sheet = workbook[‘Sheet1’]
list = []
for row in range (2,sheet.max_row+1):
tem = []
for col in range(1,sheet.max_column+1):
tem.append(sheet.cell(row,col).value)
list.append(tem)
return list