
用的 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") 设置好后 &[ 不会直接显示,只会显示 时间] ,然后点自定义页脚,显示里边的内容没问题,然后点确定就正常了 