python通过openpyxl模块读取写入excel操作

不废话，上代码

from openpyxl import load_workbook
from openpyxl import workbook

class Doexcel:
    def __init__(self,file_name,sheet_name):
        try:
            # self.file_name = file_name
            # self.sheet_name = sheet_name
            self.workbook = load_workbook(file_name)
            self.sheet = self.workbook[sheet_name]
            self.max_row = self.sheet.max_row
            self.max_column = self.sheet.max_column
        except Exception as e:
            print("文件有误:{}".format(e))
            raise

    def get_excel(self):
    """读取值操作"""
        # max_row = self.sheet.max_row
        # max_column = self.sheet.max_column
        ex = []
        for r in range(1,self.max_row+1):
            commit = self.sheet.cell(r,2).value
            artifact = self.sheet.cell(r,1).value
            # print(artifact+':'+commit)
            tuple_artifact_commit = (artifact,commit)
            # print(tuple_artifact_commit)
            ex.append(tuple_artifact_commit)
        print(ex)
        self.workbook.close()
        return ex

    def write_excel(self,value1,branch,file_name):
    """写入值操作"""
        for r in range(1,self.max_row+1):
            self.sheet.cell(r,4).value = value1
            self.sheet.cell(r,5).value = branch
            self.workbook.save(file_name)
            self.workbook.close()

其实主要逻辑就是先加载excel文件，然后确定内容所在的sheet，最后通过（行标，列标）确定所在的空格值，读取数据是这样，写入数据也是这样，找到空格，然后写入对应值