python自动化办公（第9课）批量调整Excel中字体、样式

python自动化办公（第9课）批量调整Excel中字体、样式

- 修改字体样式

• Font(name=“字体名”,size=字体大小,bold=是否加粗,italic=是否斜体,color=字体颜色)

from openpyxl.styles import Font
from openpyxl import load_workbook
workbook = load_workbook(filename="新建表.xlsx")
sheet = workbook.active
cell = sheet["A1"]
font = Font(name="隶书",size=12,bold=True,italic=True,color="59A869")
cell.font = font
workbook.save(filename="新建表.xlsx")

• 注意styles后面有s
• 注意Font首字母大写
  

- 获取表格中字体的样式

workbook = load_workbook(filename="新建表.xlsx")
sheet = workbook.active
cell = sheet["A1"]
font = cell.font
print(font.name,font.size,font.bold,font.italic)

隶书 12.0 True True

- 设置对齐样式

• Alignment(horizontal=水平对齐,vertical=垂直对齐,text_rotation=旋转角度,wrap_text=是否自动换行)

from openpyxl.styles import Alignment
from openpyxl import load_workbook
workbook = load_workbook(filename="新建表.xlsx")
sheet = workbook.active
cell = sheet["A1"]
alignment = Alignment(horizontal="center",vertical="center",text_rotation=45,wrap_text=True)
cell.alignment = alignment
workbook.save(filename="新建表.xlsx")

• 水平对齐:“distributed”,“justify”,“center”,“left”,“fill”,“centerContinuous”,“right”,“general”
• 垂直对齐:“bottom”,“distributed”,“justify”,“center”,“top”
  

- 设置边框样式

• Side(style=边线样式,color=边线颜色)
• Border(left=左边线样式,right=右边线样式,top=上边线样式,bottom=下边线样式)

from openpyxl.styles import Side,Border
from openpyxl import load_workbook
workbook = load_workbook(filename="新建表.xlsx"