import openpyxl as px
from openpyxl.styles import Border, Side
book = px.Workbook()
book.save('sample.xlsx')
wb = px.load_workbook('sample.xlsx')
ws = wb['Sheet']
## 背景色を変更_範囲指定
for rows in ws['A5':'D5']:
for cell in rows:
cell.fill = px.styles.PatternFill(patternType='solid',fgColor='D1FE7B',bgColor='D1FE7B')
wb.save('sample.xlsx')
print('セルの背景色変更完了')
import openpyxl as px
from openpyxl.styles import Border, Side
book = px.Workbook()
book.save('sample.xlsx')
wb = px.load_workbook('sample.xlsx')
ws = wb['Sheet']
side1 = Side(style = 'thick', color='000000')
for rows in ws['A1':'D5']:
for cell in rows:
cell.border = Border(left = side1, right = side1, top = side1, bottom = side1)
#セルの結合
ws.merge_cells('A2:D4')
## 背景色を変更_範囲指定
for rows in ws['A5':'D5']:
for cell in rows:
cell.fill = px.styles.PatternFill(patternType='solid',fgColor='D1FE7B',bgColor='D1FE7B')
wb.save('sample.xlsx')
print('罫線の記載完了')
コメント