Clever Geek Handbook

Openpyxl - character style

I am trying to port my code from pywin32

to openpyxl

. But I cannot find a way to change the color style to partial characters in a cell. Q pywin32

I can use: Range(Cell).GetCharacters(Start, Length).Font.ColorIndex

to do this. But it looks like there is no such method in openpyxl

?

+3


source to share


1 answer


Simple answer: a cell is the smallest element that you can style. You can get around this limitation by inserting formatting into the text, but it's even more messy than it sounds.



+1


source






More articles:


All Articles