python excel 数据驱动

from openpyxl import load_workbook
import openpyxl.workbook
import os
class Case:
    def __init__(self):
        self.case_id=None
        self.request_type = None
        self.url = None
        self.param = None
        self.is_delete = None
        self.is_run = None
        self.url_id = None
        self.description = None
        self.expect_data = None
        self.analysis = None
    def __str__(self):
        return  (" self.case_id={},  self.request_type={}, self.url={},  self.param = {},self.is_delete={},self.is_run={}, self.url_id={}, self.description={}, self.response_data={},  self.analysis={}"
              .format(self.case_id, self.request_type,self.url,self.param,self.param,self.is_delete,self.is_run,self.url_id, self.description,self.expect_data,self.analysis))

class ReadExcel:
    def read_excel(self, file_name, sheet_name=None):
        wb = load_workbook(file_name)
        sheet = wb[sheet_name]
        case_list = []
        max_row= sheet.max_row
        max_column=sheet.max_column
        for row in range(2,max_row):
            case=Case()
            case.case_id=sheet.cell(row=row,column=1).value
            case.request_type = sheet.cell(row=row, column=2).value
            case.url = sheet.cell(row=row, column=3).value
            case.param = sheet.cell(row=row, column=4).value
            case.is_delete= sheet.cell(row=row, column=5).value
            case.is_run = sheet.cell(row=row, column=6).value
            case.url_id = sheet.cell(row=row, column=7).value
            case.description = sheet.cell(row=row, column=8).value
            case.expect_data = sheet.cell(row=row, column=9).value
            case.analysis = sheet.cell(row=row, column=10).value
            case_list.append(case)
        return case_list
if __name__ == '__main__':
   list= ReadExcel().read_excel("test.xlsx","home_school")
   print(list[0])