使用openpyxl进行读写操作

import openpyxl

excelDir = "./接口测试用例-v1.3.xlsm"
excelDirObj = "./接口测试用例-v1.3 - result.xlsm"
# ------------读取对象--------------
#实例化一个workbook对象
workbook = openpyxl.load_workbook(excelDir)
#获取工作表
worksheet = workbook["新增客户20个"]
# ------------写入对象--------------
workbookObj = openpyxl.load_workbook(excelDirObj,keep_vba=True)
worksheetObj = workbookObj["新增客户20个"]

#获取最大行
# print(worksheet.max_row)
#获取最大列
# print(worksheet.max_column)
#获取某一列的值
# for one in worksheet["A"]:
#     print(one.value)
#遍历每行每列
# for row in worksheet.rows:
#     for cell in row:
#         print(cell.value, end=",")
#     print()
testName = []
testReason = []
for one in worksheet["B"]:
    testName.append(one.value)

for one in worksheet["C"]:
    testReason.append(one.value)

# print(testReason,testName)
del testName[0], testReason[0]
for i in range(0,len(testName)):
    worksheetObj.cell(i+1,1,testName[i])

for i in range(0,len(testName)):
    worksheetObj.cell(i+1,2,testReason[i])

workbookObj.save("接口测试用例-v1.3 -resultObj.xlsm")