Python - change header color of dataframe and save it to excel file

Question

I have a dataframe df where i want to change the header background color, apply borders and save it excel file in .xlsx extension.

I have tried styleframe, some functionalities in openpyxl and tried to write udf s, But nothing seemed to work.

Why don't you include in the question what you tried. It's okay if its broken. — Mohammad Yusuf
– Mohammad Yusuf, Commented Dec 27, 2016 at 6:35
Do you use Windows? If so, you can have Python interface with COM for full access to Excel object library. — Parfait
– Parfait, Commented Dec 27, 2016 at 9:11

AsafSH · Accepted Answer · 2022-06-10 11:15:19Z

3

Here is the solution using StyleFrame package that you mentioned.

import pandas as pd
from styleframe import StyleFrame, Styler, utils

df = pd.DataFrame({'a': [1, 2, 3], 'b': [1, 2, 3]})
sf = StyleFrame(df)

sf.apply_headers_style(styler_obj=Styler(bold=True,
                                         bg_color=utils.colors.green,
                                         border_type=utils.borders.medium))

sf.to_excel('output.xlsx').save()

I would recommend you to make sure that you have the lastest version of StyleFrame installed.

pip install -U styleframe

edited Jun 10, 2022 at 11:15

answered Jun 9, 2017 at 16:50

AsafSH

6956 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

jahmia Over a year ago

Actually, it depends on pandas lower to 1.2.0, which is out of date

Volpym Over a year ago

I do not know if it's a different version. but for latest versions the import doesn't work. should be changed to "from styleframe import StyleFrame, Styler, utils"

Collectives™ on Stack Overflow

Python - change header color of dataframe and save it to excel file

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related