Python-Excel-04-单元格上个底色

import os
import win32com
from win32com.client import constants as c  # 旨在直接使用VBA常数

current_address = os.path.abspath('.')excel_address = os.path.join(current_address, "示例.xlsx")
print(current_address)
xl_app = win32com.client.gencache.EnsureDispatch("Excel.Application")  # 若想引用常数的话使用此法调用Excel
xl_app.Visible = False  # 是否显示Excel文件

wb = xl_app.Workbooks.Open(excel_address)
sht = wb.Worksheets(1)
sht.Name = "示例"

max_col = sht.Cells(1, sht.Columns.Count).End(c.xlToLeft).Column

for j in range(1, max_col+1):
   print(j)
   cells_value = sht.Cells(1, j).Value    
    if cells_value > 5:
       sht.Cells(1, j).Interior.Pattern = c.xlSolid
       sht.Cells(1, j).Interior.PatternColorIndex = c.xlAutomatic
       sht.Cells(1, j).Interior.Color = 255
       sht.Cells(1, j).Interior.TintAndShade = 0
       sht.Cells(1, j).Interior.PatternTintAndShade = 0

wb.Save()
wb.Close()