개인적으로 공부한 내용을 정리중입니다.

import openpyxl from openpyxl.styles import PatternFill, colors, Alignment, Font def doExcel(): ex = openpyxl.load_workbook('/Users/gimdonghwan/파이썬강의준비/codingExcel.xlsx') sheet = ex["sheet1"] sheet.append([1, 2, 3, 4, 5]) sheet.append(["애쉬", "블리츠", "미스포츈", "나서스", "리신"]) #배경 색상. patternRed = PatternFill(start_color="ff0000", fill_type="solid") #red patternBlue = PatternFill(start_color=..

import openpyxl def doExcel(): ex = openpyxl.Workbook() #엑셀 생성. ex.create_sheet("sheet1") #테스트 시트 추가. sheet = ex["sheet1"] #시트 선택 sheet['A1'] = "i'm jacy" sheet['B1'] = "hello" sheet.cell(1, 3, 30) sheet.cell(row=1, column=4, value=40) sheet.cell(1, 5, "=SUM(C1:D1)/2") ex.save('/Users/gimdonghwan/파이썬강의준비/codingExcel.xlsx') # Press the green button in the gutter to run the script. if __..