import osimport openpyxlfrom openpyxl.worksheet.header_footer import _HeaderFooterPartxlsxFiles = (fn for fn in os.listdir('.') if fn.endswith('.xlsx'))for xlsxFile in xlsxFiles: wb = openpyxl.load_workbook(xlsxFile) for ws in wb.worksheets: # 設置首頁與其他頁不同 ws.HeaderFooter.differentFirst = True # 設置奇偶頁不同 ws.HeaderFooter.differentOddEven = True # 設置首頁頁眉頁腳 ws.firstHeader.left = _HeaderFooterPart('第一頁左頁眉', size=24, color='FF0000') ws.firstFooter.center = _HeaderFooterPart('第一頁中頁腳', size=24, color='00FF00') # 設置奇偶頁頁眉頁腳 ws.oddHeader.right = _HeaderFooterPart('奇數頁右頁眉') ws.oddFooter.center = _HeaderFooterPart('奇數頁中頁腳') ws.evenHeader.left = _HeaderFooterPart('偶數頁左頁眉') ws.evenFooter.center = _HeaderFooterPart('偶數頁中頁腳') wb.save('new_'+xlsxFile)