如何用python操作excel达到同一单元格设置不同颜色字体

mfkamwc

这里大佬多,拜求各位大佬,万分感谢!
问题:如何用python操作excel达到同一单元格设置不同颜色字体如下图所示:

gzq830510

https://blog.csdn.net/qingyou193301/article/details/113104163
网上随手搜的……没验证

旧的xls格式可以用上面的xlwt，新的xlsx格式可以用XlsxWriter

[Python] 纯文本查看 复制代码

#借助xlsxwriter库（xlsx）或xlwt库（xls）
import xlsxwriter

workbook = xlsxwriter.Workbook('rich_strings.xlsx')
worksheet = workbook.add_worksheet()
yellow = workbook.add_format({'color': '#ffeb9c'})
blue = workbook.add_format({'color': 'blue'})
text_wrap = workbook.add_format({'text_wrap': True})
string_parts = [ 'This is ', yellow, '黄', ' and this is ', blue, '蓝']
string_parts.append(text_wrap)
worksheet.write_rich_string('A1', *string_parts)
workbook.close()

vip060

切割片,如何？

juli321

[Python] 纯文本查看 复制代码

from xlsxwriter.workbook import Workbook
workbook = Workbook(r'test.xlsx') # 创建xlsx
worksheet = workbook.add_worksheet('A') # 添加sheet
red = workbook.add_format({'color':'red'}) # 颜色对象
worksheet.write(0, 0, 'sentences') # 0，0表示row，column，sentences表示要写入的字符串
test_list = ["我爱", "中国", "天安门"]
test_list.insert(1, red) # 将颜色对象放入需要设置颜色的词语前面
print(test_list)
worksheet.write_rich_string(1, 0, *test_list) # 写入工作簿
workbook.close() # 记得关闭

mfkamwc

gzq830510 发表于 2022-9-16 08:48
https://blog.csdn.net/qingyou193301/article/details/113104163
网上随手搜的……没验证

厉害,果然这里大佬多,我没用过这个库,格式全用的openpyxl,头整痛了也没整出来,万分感谢 !

mfkamwc

juli321 发表于 2022-9-16 13:06
[mw_shl_code=python,true]from xlsxwriter.workbook import Workbook
workbook = Workbook(r'test.xlsx') ...

谢谢大佬!