37,720
社区成员
发帖
与我相关
我的任务
分享
from openpyxl import load_workbook
from openpyxl.workbook.defined_name import DefinedName
from openpyxl.utils import absolute_coordinate, quote_sheetname
xl_file = "d:/test.xlsx"
xl_savefile = "d:/test_save.xlsx"
if __name__ == '__main__':
wb = load_workbook(xl_file)
ws = wb.active
# 把sheet1 里的A2 设定为rpt_date
dname = DefinedName(name='rpt_date')
dname.value = "Sheet1!$A$2"
wb.defined_names.append(dname)
wb.save(xl_savefile)
wb.close()