from openpyxl import Workbook
from openpyxl.cell.rich_text import CellRichText, TextBlock
from openpyxl.cell.text import InlineFont
from openpyxl.styles import Font
wb = Workbook()
ws = wb.active
# 构造带空格富文本(终极方案)
strikethrough_font = InlineFont(strike=True, color="FFFF00")
font2 = Font(color="FF0000") # 相同样式,不同对象
rich_text = CellRichText(
TextBlock(strikethrough_font, "Hello"),
TextBlock(strikethrough_font, " "), # 空格独立为不同格式块
TextBlock(strikethrough_font, "world")
)
ws["A1"] = rich_text
wb.save("rich_text_test.xlsx")
Python openpyxl的一些坑现在的新冠疫情是个大事,咱们要响应国家号召不出门,在家没事做,于是开始写Python。因为自己每个月都要改报表,所以首先想写一个批量给Excel改格式的小东西。写的过程中开始...