worksheet.pagebreak【改ページ】モジュール

from openpyxl import Workbook
from openpyxl.worksheet.worksheet import Worksheet
from openpyxl.worksheet.pagebreak import Break

# ワークブック作成
WORKBOOK = 'sample.xlsx'
wb = Workbook()
ws = wb.active
ws['L30'] = 'Data'
ws.print_area = 'A1:L30'

# 用紙設定
ws.set_printer_settings(
    Worksheet.PAPERSIZE_A3,
    Worksheet.ORIENTATION_LANDSCAPE,
)

# 改ページ (行) 個別指定
row_break = Break(5)
ws.row_breaks.append(row_break)
row_break = Break(15)
ws.row_breaks.append(row_break)
print(ws.row_breaks)
# 出力：
# <openpyxl.worksheet.pagebreak.RowBreak object>
# Parameters:
# count=2, manualBreakCount=2, brk=[<openpyxl.worksheet.pagebreak.Break object>
# Parameters:
# id=5, min=0, max=16383, man=True, pt=None, <openpyxl.worksheet.pagebreak.Break object>
# Parameters:
# id=15, min=0, max=16383, man=True, pt=None]

# 改ページ (列) 一括指定
ws.col_breaks.brk = [Break(3), Break(9)]
print(ws.col_breaks)
# 出力：
# <openpyxl.worksheet.pagebreak.ColBreak object>
# Parameters:
# count=2, manualBreakCount=2, brk=[<openpyxl.worksheet.pagebreak.Break object>
# Parameters:
# id=3, min=0, max=16383, man=True, pt=None, <openpyxl.worksheet.pagebreak.Break object>
# Parameters:
# id=9, min=0, max=16383, man=True, pt=None]

# ビュー設定
ws.sheet_view.view = 'pageBreakPreview'
ws.sheet_view.zoomScaleSheetLayoutView = 75
ws.sheet_view.zoomScale = 75

# ワークブック保存
wb.save(WORKBOOK)

from openpyxl import Workbook
from openpyxl.worksheet.worksheet import Worksheet
from openpyxl.worksheet.pagebreak import Break

# ワークブック作成
WORKBOOK = 'sample.xlsx'
wb = Workbook()
ws = wb.active
ws['L40'] = 'Data'
ws.print_area = 'A1:L40'

# 用紙設定
ws.set_printer_settings(
    Worksheet.PAPERSIZE_A3,
    Worksheet.ORIENTATION_PORTRAIT,
)

# 改ページ (行)
ws.row_breaks.brk = [Break(i) for i in range(5, 41, 5)]
print(ws.row_breaks.count, bool(ws.row_breaks), len(ws.row_breaks))
# 出力：8 True 8
# 改ページ (行) 個別解除
ws['B10'] = '改ページ 解除'
del_break = 10
for row_break in ws.row_breaks.brk:
    if row_break.id == del_break:
        ws.row_breaks.brk.remove(row_break)
        break;
print(ws.row_breaks.count, bool(ws.row_breaks), len(ws.row_breaks))
# 出力：7 True 7

# 改ページ (列)
ws.col_breaks.brk = [Break(i) for i in range(3, 13, 3)]
print(ws.col_breaks.count, bool(ws.col_breaks), len(ws.col_breaks))
# 出力：4 True 4
# 改ページ (列) すべて解除
ws.col_breaks.brk = []
print(ws.col_breaks.count, bool(ws.col_breaks), len(ws.col_breaks))
# 出力：0 False 0

# ビュー設定
ws.sheet_view.view = 'pageBreakPreview'
ws.sheet_view.zoomScaleSheetLayoutView = 75
ws.sheet_view.zoomScale = 75

# ワークブック保存
wb.save(WORKBOOK)