color text using StyleFrame in python

Asked Feb 24 '20 at 09:04

Active Feb 24 '20 at 09:04

Viewed 324 times

I want to have a yellow background in some certain rows and in those rows I want some text to be red. Here is an example :

So far I am able to achieve yellow background in some certain rows using :

 from StyleFrame import StyleFrame, Styler

 bgStyle = Styler(bg_color='yellow')
 sf = StyleFrame(df)
 sf.apply_style_by_indexes(rowsTocolor, styler_obj=bgStyle, overwrite_default_style=False)

But I cant find a way to color a particular text red in that yellow background row.

So my question is, is it possible to achieve this using StyleFrame? If yes, then how? if not, then which other library should i use?

asked Feb 24 '20 at 09:04

Anudocs

Do you mean that you want cell B1 to contain 'b 35 45 68', and only '45' should be red? – DeepSpace Feb 24 '20 at 09:51
yes. But this is just an example. Basically, I want to color string of a cell partially. – Anudocs Feb 24 '20 at 10:11
I've done some digging around and it does not look like openpyxl (which styleframe uses) supports that – DeepSpace Feb 24 '20 at 10:47
After my research till now, i also didn't find any library which supports that. – Anudocs Feb 24 '20 at 10:55
So is it safe to assume that it is not possible to do? – Anudocs Feb 24 '20 at 10:55

color text using StyleFrame in python

0 Answers0