worksheet.page【ページ設定】モジュール

from openpyxl import Workbook
from openpyxl.worksheet.worksheet import Worksheet

# ワークブック作成
WORKBOOK = 'sample.xlsx'
wb = Workbook()
ws = wb.active
ws['B2'] = 'ページ設定'

# 印刷の向き
ws.page_setup.orientation = Worksheet.ORIENTATION_LANDSCAPE
# 拡大/縮小 印刷 (%)
ws.page_setup.scale = 123  # 値のみ
# 次のページ数に合わせて印刷
ws.page_setup.fitToPage = True
ws.page_setup.fitToWidth = 2
ws.page_setup.fitToHeight = 3
# 用紙サイズ
ws.page_setup.paperSize = Worksheet.PAPERSIZE_A3
# 印刷品質
ws.page_setup.horizontalDpi = 1200
ws.page_setup.verticalDpi = 1200
# 先頭ページ番号
ws.page_setup.useFirstPageNumber = True
ws.page_setup.firstPageNumber = 4
# 参考：用紙サイズ・印刷の向き
#ws.set_printer_settings(
#    Worksheet.PAPERSIZE_A3,
#    Worksheet.ORIENTATION_LANDSCAPE
#)

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

from openpyxl import Workbook
from openpyxl.worksheet.worksheet import Worksheet

# ワークブック作成
WORKBOOK = 'sample.xlsx'
wb = Workbook()
ws = wb.active
CM = 1 / 2.54

# 用紙サイズ・印刷の向き
ws.set_printer_settings(
    Worksheet.PAPERSIZE_A4,
    Worksheet.ORIENTATION_PORTRAIT
)

# 余白
ws.page_margins.top = 3 * CM
ws.page_margins.right = 4 * CM
ws.page_margins.bottom = 5 * CM
ws.page_margins.left = 6 * CM
# 余白 (ヘッダー・フッター)
ws.page_margins.header = 1 * CM
ws.page_margins.footer = 2 * CM
# ページ中央 印刷
ws.print_options.horizontalCentered = True
ws.print_options.verticalCentered = True

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

from openpyxl import Workbook
from openpyxl.worksheet.worksheet import Worksheet
from openpyxl.comments import Comment
from openpyxl.utils import get_column_letter

# ワークブック作成
WORKBOOK = 'sample.xlsx'
wb = Workbook()
ws = wb.active

# タイトル
for i in range(2, 10):
    letter = get_column_letter(i)
    ws[f'{letter}1'] = f'TITLE {letter}'
for i in range(2, 61):
    ws[f'A{i}'] = f'TITLE {i}'
# データ
ws['C3'] = 'C-3'
ws['C3'].comment = Comment('コメント', 'AUTHOR')
ws['C4'] = '=1/0'
# 用紙サイズ・印刷の向き
ws.set_printer_settings(
    Worksheet.PAPERSIZE_A5,
    Worksheet.ORIENTATION_PORTRAIT
)
# 次のページ数に合わせて印刷
ws.page_setup.fitToPage = True
ws.page_setup.fitToWidth = 2
ws.page_setup.fitToHeight = 2

# 印刷範囲
ws['I60'] = 'I-60'
ws.print_area = 'A1:I60'
# 印刷タイトル行
ws.print_title_rows = '1:1'
# 印刷タイトル列
ws.print_title_cols = 'A:A'

# 枠線
ws.print_options.gridLines = True
ws.print_options.gridLinesSet = True
# 行列番号
ws.print_options.headings = True

# 白黒印刷
ws.page_setup.blackAndWhite = True
# 簡易印刷
ws.page_setup.draft = False
# コメント印刷
ws.page_setup.cellComments = 'atEnd'
# セルのエラー印刷
ws.page_setup.errors = 'dash'
# ページの方向
ws.page_setup.pageOrder = 'overThenDown'

# ビュー設定
ws.sheet_view.view = 'pageLayout'
ws.sheet_view.zoomScalePageLayoutView = 50
ws.sheet_view.zoomScale = 50

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