关于使用openpyxl在Excel表格中插入分页符,网上很多示范都是错误的。下面是参考stack overflow和openpyxl官方文档的示例,能够正确运行,效果是在表格的第20行插入行级分页符。
from openpyxl.worksheet.pagebreak import RowBreak
from openpyxl.worksheet.pagebreak import Break
from openpyxl import load_workbook
wb = load_workbook("pagination.xlsx")
ws = wb.active
row_break = RowBreak()
row_break.append(Break(id=20))
ws.row_breaks = row_break
wb.save("pagination.xlsx")