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
# 構(gòu)造帶空格富文本(終極方案)
strikethrough_font = InlineFont(strike=True, color="FFFF00")
font2 = Font(color="FF0000") # 相同樣式,不同對象
rich_text = CellRichText(
TextBlock(strikethrough_font, "Hello"),
TextBlock(strikethrough_font, " "), # 空格獨(dú)立為不同格式塊
TextBlock(strikethrough_font, "world")
)
ws["A1"] = rich_text
wb.save("rich_text_test.xlsx")
Python openpyxl的一些坑現(xiàn)在的新冠疫情是個大事,咱們要響應(yīng)國家號召不出門,在家沒事做,于是開始寫Python。因?yàn)樽约好總€月都要改報(bào)表,所以首先想寫一個批量給Excel改格式的小東西。寫的過程中開始...