读取excel中的用例

from openpyxlimport load_workbook

class DoExcel:

def __init__(self,file_path,sheet_name):

self.file_path=file_path

self.sheet_name=sheet_name

def do_excel(self):

wb=load_workbook(self.file_path)

sheet=wb[self.sheet_name]

test_data=[]

for iin range(2,sheet.max_row+1):

sub_data={}

sub_data['id']=sheet.cell(i,1).value

sub_data['title'] = sheet.cell(i,2).value

test_data.append(sub_data)

return test_data

if __name__=='__main__':

test_data=DoExcel('cases.xlsx','userRegister').do_excel()

for itemin test_data:

print(item)