python读excel字体颜色_python操作excel之设置字体颜色及格式

xlwings如何设置字体、颜色等属性

# coding: utf-8

import xlwings asxw

app=xw.App(visible=False,add_book=False)

filepath= '../data/test.xlsx'wb=app.books.open(filepath)

sht= wb.sheets('Sheet1')

font_name= sht.range('A1').api.Font.Name # 获取字体名称

font_size= sht.range('A1').api.Font.Size # 获取字体大小

bold= sht.range('A1').api.Font.Bold # 获取是否加粗，True--加粗，False--未加粗

color= sht.range('A1').api.Font.Color # 获取字体颜色

print(font_name)

print(font_size)

print(bold)

print(color)

wb.save()

wb.close()

app.quit()

# coding: utf-8import xlwingsasxw

app=xw.App(visible=False,add_book=False)

filepath= '../data/test.xlsx'wb=app.books.open(filepath)

sht= wb.sheets('Sheet1')

font_name= sht.range('A1').api.Font.