python修改excel背景色_Python Pandas DataFrame和Excel：添加单元格背景色

Currently I save my dataframe like this

writer = ExcelWriter('test.xlsx')

test_df.to_excel(writer,'Sheet1')

writer.save()

And resulted excel file looks like this

cus 1 abc 2 jbd 3 lkl ...

1 col v v v v v ...

2 v v col v v v ...

3 v v v v col v ...

What I need is that, when cus value == header value, that cell should have a green background. In example above, all cells with value 'col' should be set green background. How can I do this?

解决方案styled = (df.style

.applymap(lambda v: 'background-color: %s' % 'green' if v=='col' else ''))

styled.to_excel('d:/temp/styled.xlsx', engine='openpyxl')

Result: