python关于openpyxl的二次开发

from openpyxl import load_workbook

class Excel_util:

    def __init__(self,path):

        self.path=path

        # 加载输入路径的文件

        self.wb=load_workbook(self.path)

    #获取excel的sheet页

    def get_sheetname(self):

        return self.wb.sheetnames

    #输入指定sheetname

    def __call__(self, name):

        return self.wb[name]

    #读取excel内容，name是sheet页的名字，start和end是行或者列的起始

    def read_excel(self,name,start,end=None):

        """

        :param name = sheetname

        cell_range: util column(A-C) eg: start="A" end="C"

        util row (1-3) eg: start=1 end=3

        :return:

        """

        #把start和end都设为大写

        start=str(start).upper()

        if not end:

            end=start

        end = str(end).upper()

        sheet = self.__call__(name)[start:end]

        try:

            return [[cell.value for cell in _] for _ in sheet ]

        except:

            return [cell.value for cell in sheet]

    #单个单元格写入数据

    def write_cell_data(self,name,cellname,data):

        cell=self.__call__(name)[cellname]

        cell.value=data

        self.wb.save(self.path)

    #最后一行追加插入数据，需要list

    def append_row_data(self,name,data: list):

        self.__call__(name).append(data)

        self.wb.save(self.path)

# data="测试"

# data1=["ceshi"]

# a=Excel_util("D:\zhijing_work\测试数据\测试文件\yetangjian.xlsx").read_excel("Sheet1",1,3)

# print(a)

# b=Excel_util("D:\zhijing_work\测试数据\测试文件\yetangjian.xlsx")

# b.write_cell_data("Sheet1","B5",data)

# b.append_row_data("Sheet1",data1)