OpenPyXL

import openpyxl as op
wb = op.Workbook()
ws = wb.create_sheet("new_sheet1")  # New Seet
# OR
ws = wb.active  # Activated sheet
wb.save("test.xlsx")

import openpyxl as op
wb = op.load_workbook("test.xlsx")

ws = wb.create_sheet("new_sheet1")

ws = wb.active

ws = wb["sheet3"]

wss = wb.sheetnames

ws = wb.create_sheet("new_sheet1")
wb.remove(ws)

data = ws.cell(row=1, column=2).value

data = ws["B1"].value

rows = ws["A1:C3"]  # A1:C3 범위 저장 (총 9개 Cell)
for row in rows:
    for cell in row:
        print(cell.value)

Worksheet.delete_rows(index, size)
Worksheet.delete_cols(index, size)

import openpyxl

wb = openpyxl.Workbook()
ws = wb.worksheets[0]
img = openpyxl.drawing.image.Image('test.jpg')
img.anchor = 'A1'
img.width = 300
img.height = 300
ws.add_image(img)
wb.save('out.xlsx')

import openpyxl
wb = openpyxl.Workbook()
ws = wb.worksheets[0]
ws['A1'].fill = openpyxl.styles.PatternFill(start_color=hex_color, end_color=hex_color, fill_type="solid")
wb.save('out.xlsx')

from openpyxl import Workbook
from openpyxl.formatting.rule import CellIsRule
from openpyxl.styles import PatternFill

# 새로운 엑셀 파일 생성
workbook = Workbook()
sheet = workbook.active

# 샘플 데이터 추가
data = [
    [1, 2, 3],
    [4, 1, 6],
    [7, 8, 1]
]
for row in data:
    sheet.append(row)

# 조건부 서식을 위한 노란색 Fill 스타일 정의
yellow_fill = PatternFill(start_color="FFFF00", end_color="FFFF00", fill_type="solid")

# 조건부 서식 규칙 생성 (셀 값이 1일 때)
rule = CellIsRule(operator="equal", formula=["1"], stopIfTrue=True, fill=yellow_fill)

# 범위에 조건부 서식 적용 (예: A1:C3)
sheet.conditional_formatting.add("A1:C3", rule)

# 파일 저장
workbook.save("conditional_formatting_example.xlsx")