1、复制文件:
https://blog.csdn.net/Jerry_1126/article/details/86602517
import shutil
def _cp(src,target):
shutil.copyfile(src, target)
if __name__ == '__main__':
src = '.\data\手工账模板-批量手工账test.xlsx'
target = '.\data\手工账模板-批量手工账test-cp.xlsx'
_cp(src,target)
2、操作excel
https://www.cnblogs.com/programmer-tlh/p/10461353.html
https://zhuanlan.zhihu.com/p/61059318
from openpyxl import load_workbook
def _deal_excel(filepath,row,column,value):
wb = load_workbook(filepath)
ws = wb.active
ws.cell(row=row, column=column).value = value
wb.save(filepath)