title: Format Excel Column header for better visibility and Color
body: <p>I have gone through many posts but did not found the exact way to do the below. 
  Sorry for attaching screenshot(Just for better visibility) as well , I will write it also.
  Basically it looks like -</p>
  
  <pre><code>Name_of_the_Man Address_of_Man  City
  Jordan           NC             LMN
  </code></pre>
  
  <p>Input csv looks like</p>
  
  <p><a href="https://i.stack.imgur.com/9vh2m.png" rel="noreferrer"><img src="https://i.stack.imgur.com/9vh2m.png" alt="Available csv"></a></p>
  
  <p>Output Needed
  <a href="https://i.stack.imgur.com/6y7JD.png" rel="noreferrer"><img src="https://i.stack.imgur.com/6y7JD.png" alt="Need this"></a></p>
  
  <p>I have this code with me that picks the csv and attach as sheet in excel.</p>
  
  <pre><code>writer = pd.ExcelWriter('final.xlsx'), engine='xlsxwriter')
  for f in glob.glob(os.path.join(Path, "*.csv")):
           df = pd.read_csv(f)
           df.to_excel(writer, sheet_name=os.path.basename(f))
  writer.save()
  </code></pre>
  
  <p>I want my csv file - having good space in between and color for the column header.I have went through this link <a href="https://stackoverflow.com/questions/41339701/python-change-header-color-of-dataframe-and-save-it-to-excel-file">Python - change header color of dataframe and save it to excel file</a> but it's not serving the purpose - It is coloring the sheet itself apart from column.</p>
  
  <p>Update:
  Got the answer below . Also wondering if that can be possible just a thought
  <a href="https://i.stack.imgur.com/YaMyi.png" rel="noreferrer"><img src="https://i.stack.imgur.com/YaMyi.png" alt="enter image description here"></a></p>