用的 ms office excel2019
from openpyxl import Workbook, load_workbook
wb = load_workbook('D:/Code/python/200330-SH3-A3-02R30.xlsx')
ws = wb.active
ws.oddFooter.right.text = "2020/03/31 &[时间]"
wb.save("D:/Code/python/new200330-SH3-A3-02R30.xlsx")
设置好后 &[ 不会直接显示,只会显示 时间] ,然后点自定义页脚,显示里边的内容没问题,然后点确定就正常了