1、導包

---

from openpyxl import PatternFill, Border, Side, Alignment

2、設定顏色樣式

---

# 設定
demo_fill = PatternFill('solid', fgColor='FF7F24')
# 填充，cell為單元格
cell.fill = demo_fill

3、設定單元格對齊方式

---

# 設定
align = Alignment(horizontal='center', vertical='center')
# 填充
cell.alignment = align

4、設定邊框

---

# 設定
side = Side('thin')
demo_border = Border(bottom=side, right=side)
# 填充
cell.border = demo_border

5、設定列寬

---

# 設定第一列列寬為10
worksheet.column_dimensions['A'].width = 10