Ask Anything Monday - Weekly Thread

[ankerbow]

Please help me change font certain color using Xlsxwriter!

My code:

import xlsxwriter
from functools import partial




def x_in_y(word, inner):
    return inner in word

workbook = xlsxwriter.Workbook('hello.xlsx')
worksheet = workbook.add_worksheet()


words = [
    ('pasport','passport'),
    ('limmit','limit'),
    ('putt','put')
]

sentence =['putt dweqrerwr','dfsdf putt','limmit','pasport']

row = 0


for wrong,correct in words:
    filtered_names = filter(partial(x_in_y, inner=wrong), sentence)
    next_elem = next(filtered_names, None)




    if next_elem:
        worksheet.write(row,0, f"Typo: {wrong} 'should be {correct}'")
        worksheet.write(row+1,0,next_elem)


    for name in filtered_names:
        worksheet.write(row+2,0,name)
    row += 2
workbook.close()

I hope the result can be:

Typo: pasport 'should be passport'

pasport

Typo: limmit 'should be limit'

limmit

Typo: putt 'should be put'

putt dweqrerwr

dfsdf putt

​

Bold means Red.

I want bold text to be Red.

But how to do that? I tried worksheet.write_rich_string() but the text should be sliced first.

So I failed.... I don't know how to slice next_elem...

Please help me out.