openpyxl二次封装

from openpyxl import load_workbook
import os

class Openpy:
    def __init__(self,filename,sheetname):
        self.wk = load_workbook(filename)
        self.sh = self.wk[sheetname]
    def read_title(self):
        title = []
        for lineone in list(self.sh.rows)[0]:
            title.append(lineone.value)
        return title
    def alldates(self):
        title = self.read_title()
        alldates= []
        for item in list(self.sh.rows)[1:]:
            new_dic = {}
            for index in range(len(item)):
                new_dic[title[index]] = item[index].value
            alldates.append(new_dic)
        return alldates

filename = os.path.join(os.path.dirname(os.path.abspath(__file__)),"logincases.xlsx")
open = Openpy(filename,"login")

print(open.alldates())