how to add the background color to excel sheet by python

databicky
Contributor II

‎01-17-2023 03:32 AM

i just want to add color to excel sheet by python to specific cells, and i done that, but i need to exclude the header column, then if i tried the same method to other sheet it doesn't worked.​

​

but that bg color addition is reflected in one sheet but the same method of code is not able to use to other sheet

​

i​ just want to add color based on cell address.

0 Kudos

Hubert-Dudek
Databricks MVP

‎01-17-2023 04:00 AM


My blog: https://databrickster.medium.com/

View solution in original post

0 Kudos

databicky
Contributor II
In response to Hubert-Dudek

‎01-17-2023 08:38 AM

from the pandas df i added the below color, but based on the same method i am not able to add bg in other sheets. it is not reflecting those things

​

And how can we extend the width size of the particular column in excel by python?​

0 Kudos

Hubert-Dudek
Databricks MVP
In response to databicky

‎01-17-2023 09:02 AM

Separate dataframe for every sheet:

with pd.ExcelWriter('output.xlsx') as writer:  
 
     df1.to_excel(writer, sheet_name='Sheet_name_1')
     df2.to_excel(writer, sheet_name='Sheet_name_2')

For width, but I never used that:

df.style.set_properties(subset=['column'], **{'width': '300px'})


My blog: https://databrickster.medium.com/
0 Kudos