Tuesday, 19 October 2021

Extracting Excel sheet's style and applying it on Pandas DataFrame

I've been looking around, however, it seems that this question was not asked yet.

Is there a way to get Excel's sheet style format and apply it on a Pandas DataFrame, respecing the shape of the DataFrame and replicating completely?

Example:

enter image description here

Thanks!

UPDATE: While going through style documentation I've noticed that there is:

from pandas.io.formats.style import Styler
EasyStyler = Styler.from_custom_template("templates", "myhtml.tpl")
HTML(EasyStyler(df3).render(table_title="Another Title"))

After exporting Excel to HTML I've attempted to perform this, however, was unsuccessful.



from Extracting Excel sheet's style and applying it on Pandas DataFrame

No comments:

Post a Comment