不废话,上代码
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,最后通过(行标,列标)确定所在的空格值,读取数据是这样,写入数据也是这样,找到空格,然后写入对应值