python 学习笔记20 批量修改页眉页脚

需求：修改指定目录下所有文件的页眉页脚，或者往里面添加内容。

1. 这里做了word的实现和excel的实现，如下：

需要先安装 pip3 install pywin32，另外页眉页脚格式设置可以参考：

word：

浅谈Word.Application，关于js操作word文档的使用_new word.application-CSDN博客

excel：

Python操作Excel教程（图文教程，超详细）Python xlwings模块详解，_xlwings教程-CSDN博客

import os
import xlwings as xw
import win32com.client as win32
import pythoncom#将需要替换页眉页脚的文档放到path下
path = r'C:\Users\d\Desktop\pdf改名脚本\22\2022年\test'
#原始页眉页脚内容
old_name = u'999'
#新页眉页脚内容
new_name = u'888'
#替换失败记录日志
err_log = path + u'\\head修改出错列表.txt'
def log(text):with open( err_log,"a+" ) as f:f.write(text)f.write('\n')def change_headerfooter(path):''' 更改文件的页眉页脚 '''pythoncom.CoInitialize()word = win32.Dispatch('Word.Application')#print(dir(word))word.Visible = 0word.DisplayAlerts = 0exapp = xw.App(visible=False, add_book=False)# excel = win32.Dispatch('Excel.Application')# excel.Visible = 0# excel.DisplayAlerts = 0for parent, dirnames, filenames in os.walk(path):for fn in filenames:filedir = os.path.join(parent, fn)#获取需替换目录下的docx结尾的文档名称if fn.endswith('.docx') or fn.endswith('.doc'):print(filedir)try:doc = word.Documents.Open( filedir )a = word.ActiveDocument.Sectionsn = 0for i in range( len(a) ):#获取当前页眉head = word.ActiveDocument.Sections[i].Headers[0]old_head = str(head)#获取当前页脚foot = word.ActiveDocument.Sections[i].Footers[0]old_foot = str(foot)#print( old_head )#if old_name in old_head:if 1:#old_name存在页眉中时，进行进行替换#用于替换页眉#new_head = old_head.replace( old_name, new_name )#用于补充页眉#new_head = old_head + new_name#print( new_head )word.ActiveDocument.Sections[i].Headers[0].Range.Find.ClearFormatting()word.ActiveDocument.Sections[i].Headers[0].Range.Find.Replacement.ClearFormatting()#页眉重置word.ActiveDocument.Sections[i].Headers[0].Range.Delete()#设置字体大小word.ActiveDocument.Sections[i].Headers[0].Range.Font.Size=20#设置对齐方式，0-左；1-中；2-右word.ActiveDocument.Sections[i].Headers[0].Range.ParagraphFormat.Alignment = 0word.ActiveDocument.Sections[i].Headers[0].Range.InsertAfter(new_name)#替换旧页眉#word.ActiveDocument.Sections[i].Headers[0].Range.Find.Execute( old_head, False, False, False, False, False, False, 1, False, new_name, 2 )#if old_name in old_foot:if 1:##old_name存在页脚中时，进行进行替换#new_foot = old_foot.replace( old_name, new_name )#new_foot = old_foot + new_nameword.ActiveDocument.Sections[i].Footers[0].Range.Find.ClearFormatting()word.ActiveDocument.Sections[i].Footers[0].Range.Find.Replacement.ClearFormatting()#页脚重置word.ActiveDocument.Sections[i].Footers[0].Range.Delete()word.ActiveDocument.Sections[i].Footers[0].Range.InsertAfter(new_name)#替换旧页脚#word.ActiveDocument.Sections[i].Footers[0].Range.Find.Execute( old_foot, False, False, False, False, False, False, 1, False, new_name, 2 )n = n+1doc.Close()except Exception as e:print(e)log(str(filedir))if fn.endswith('.xlsx') or fn.endswith('.xls'):print(filedir)try:ex = exapp.books.open(filedir)#print(dir(ex.sheets))sheet = ex.sheetsprint(sheet[0].name)if 'test' == sheet[0].name:print(sheet.name)else:#如果第一个sheet不是test则加一个test的sheetsheet.add('test',before=sheet[0].name)ex.save()ex.close()except Exception as e:log(str(filedir))word.Quit()exapp.quit()change_headerfooter(path)

补充一下：excel没有用pywin32去读写因为莫名其妙就是卡进程，无法对excel读写，可能和缓存的excel有关，如要编辑3.xlsx，则会卡一个~3.xlsx的进程无法结束。就换成了xlwings去读写。