openpyxl基礎【python】

よく使うコードのメモ

from openpyxl import load_workbook

# Excelファイルを読み込み
wb = load_workbook("test.xlsx")
ws = wb.active

# 列幅を設定
ws.column_dimensions['A'].width = 20
ws.column_dimensions['B'].width = 20
ws.column_dimensions['C'].width = 5
ws.column_dimensions['D'].width = 30
ws.column_dimensions['E'].width = 30
ws.column_dimensions['F'].width = 20
ws.column_dimensions['G'].width = 20
ws.column_dimensions['H'].width = 20
ws.column_dimensions['I'].width = 20
ws.column_dimensions['J'].width = 20

# 保存
wb.save("test.xlsx")