How to highlight header in excel using styles in python?

Question

I have a dataframe which looks like this.

ID	Name	Sales	Sales2
111	SAM	xxx	xxx
123	JON	xxx	xxx

I want to produce an excel like this.

I tried using set tables but it is not working

styles = [{ 'props': ('background-color: green') }]
fd_final_highlight = fd_final.style.set_table_styles(styles)   
Weekly_excel= pd.ExcelWriter('C:/Users/xxx.....xlsx', engine='xlsxwriter')

fd_final_highlight.to_excel(Weekly_excel, sheet_name='Master', index=0) 

Weekly_excel.save()

Answer 1

Possible solution is following:

import pandas as pd


data = {"col1": [1, 2, 3], "col2": [1, 2, 3]}
df = pd.DataFrame.from_dict(data)

writer = pd.ExcelWriter('C:/Users/xxx.....xlsx', engine='xlsxwriter')
df.to_excel(writer, sheet_name='Master', startrow=1, header=False, index=False)

workbook = writer.book
worksheet = writer.sheets['Master']

# Set a header format
header_format = workbook.add_format({'bold': True, 'fg_color': 'green'})

for col_num, value in enumerate(df.columns.values):
    worksheet.write(0, col_num, value, header_format)

writer.save()