2.5 sheet的名称、颜色设定

一、sheet的名称设置

from openpyxl import load_workbook
file = load_workbook(filepath)
# 选定sheet，并且设置sheet名称
sheet = file.worksheets[0]
sheet.title = '第一张表单'
file.save(filepath)

二、sheet的颜色设置

from openpyxl import load_workbook
file = load_workbook(filepath)
# 选定sheet，并且设置sheet颜色
sheet = file['Sheet1']
sheet.sheet_properties.tabColor = "1072BA" # 右边这个东西是颜色代码
wb.save(filepath)