【業務自動化】Chapter1-5｜データを新規シートへ自動で振り分け

import pathlib
from openpyxl import Workbook
from openpyxl.styles import Font, PatternFill, Border, Side, Alignment
from openpyxl.styles.colors import Color


def create_chapter1_4_workbook():
    file_path = pathlib.Path(__file__).parent / "workbooks"
    file_path.mkdir(exist_ok=True)

    save_path = file_path / "Chapter1-4.xlsx"

    workbook = Workbook()
    sheet = workbook.active
    sheet.title = "Sheet1"

    # 元ファイルに合わせた設定
    sheet.sheet_format.defaultRowHeight = 18.75
    sheet.sheet_format.defaultColWidth = 9
    sheet.column_dimensions["B"].width = 11.625
    sheet.column_dimensions["D"].width = 11.375

    # データ
    rows = [
        ["名前", "性別", "年齢", "年齢区分"],
        ["吉田 彩花", "女", 45, "成人"],
        ["小林 翔太", "男", 21, "成人"],
        ["長谷川 清", "男", 80, "シニア"],
        ["山田 大輔", "男", 40, "成人"],
        ["佐藤 陽翔", "男", 1, "未成年"],
        ["渡辺 亮", "男", 50, "成人"],
        ["伊藤 陽菜", "女", 12, "未成年"],
        ["木村 智子", "女", 75, "シニア"],
        ["鈴木 結衣", "女", 3, "未成年"],
        ["松本 健太", "男", 30, "成人"],
        ["石井 誠", "男", 70, "シニア"],
        ["中村 莉子", "女", 18, "未成年"],
        ["高橋 悠真", "男", 6, "未成年"],
        ["田中 美月", "女", 9, "未成年"],
        ["岡田 隆", "男", 60, "成人"],
        ["藤田 美穂", "女", 55, "成人"],
        ["山本 大和", "男", 15, "未成年"],
        ["村上 幸子", "女", 65, "シニア"],
        ["佐々木 真由", "女", 35, "成人"],
        ["加藤 愛美", "女", 25, "成人"],
    ]

    # スタイル
    base_font = Font(name="游ゴシック", size=11)
    header_fill = PatternFill(
        patternType="solid",
        fgColor=Color(theme=5, tint=0.4)
    )
    thin = Side(style="thin", color=Color(auto=1))

    header_border = Border(left=thin, right=thin, top=thin, bottom=thin)
    first_row_border_bd = Border(left=thin, right=thin, bottom=thin)
    first_row_border_c = Border(left=thin, bottom=thin)
    body_border_bd = Border(left=thin, right=thin, top=thin, bottom=thin)
    body_border_c = Border(left=thin, top=thin, bottom=thin)
    body_border_e = Border(left=thin, right=thin, top=thin, bottom=thin)

    header_alignment = Alignment(vertical="center")
    body_alignment = Alignment(vertical="center", wrap_text=True)
    empty_alignment = Alignment(vertical="center")

    start_row = 2
    start_col = 2  # B列

    for row_index, row_values in enumerate(rows, start=start_row):
        for col_index, value in enumerate(row_values, start=start_col):
            cell = sheet.cell(row=row_index, column=col_index, value=value)
            cell.font = base_font

            if row_index == 2:
                cell.fill = header_fill
                cell.border = header_border
                cell.alignment = header_alignment
            else:
                if col_index in (2, 4):  # B列、D列
                    cell.border = first_row_border_bd if row_index == 3 else body_border_bd
                    cell.alignment = body_alignment
                elif col_index == 3:  # C列
                    cell.border = first_row_border_c if row_index == 3 else body_border_c
                    cell.alignment = body_alignment
                elif col_index == 5:  # E列
                    cell.border = body_border_e
                    cell.alignment = empty_alignment

    workbook.save(save_path)
    print(f"{save_path} を作成しました。")


if __name__ == "__main__":
    create_chapter1_4_workbook()

業務自動化学習/			  # 学習フォルダ
 ├── Chap1/				 # チャプター１の保存フォルダ
 │   ├── Chap1-5/		# チャプター1-5の保存フォルダ
 │   │   ├── Chapter1-5.py
 │   │   ├── make_workbook1-4.py # ☆ここに保存
 │   │   └── workbooks/
 │   │　      ├── Chapter1-4.xlsx 
 │   │　      └── Chapter1-5.xlsx