使用openpyxl在Excel表格中插入分页符

45 阅读1分钟

关于使用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")