インストールは下記
$ pip install --user openpyxl
下記で新しいexcelファイルを作る
from openpyxl import Workbook wb = Workbook()
ws = wb.active
ws["A1"] = "hoge" wb.save("test.xlsx")
B2セルに枠線を付け、背景色を付け、C列と3行目の幅を変える例は下記
from openpyxl import Workbook
from openpyxl.styles import PatternFill, Border, Side, Alignment, Protection, Font
wb = Workbook()
ws = wb.active
ws["B2"] = "foo"
style=Side(border_style="thin", color="000000")
border = Border(top=style, left=style, right=style, bottom=style)
ws["B2"].border=border
fill=PatternFill("solid", fgColor="DDDDDD")
ws["B2"].fill=fill
ws.column_dimensions["C"].width = 20
ws.row_dimensions[3].height = 40
wb.save("test.xlsx")
