title: How to format a dataframe while writing to Excel
body: <p>I am trying to format a dataframe while writing to excel.</p>
  
  <p><strong>For Xlsxwriter:</strong> As we cant format the headers. I copy the header to first row and try to change the format of the first row(I set <code>header=False</code> when writing to excel). I need to format specific parts of my header. Like first 3 heading are bold, the next three are red etc. Is there any way to set specific header formats? Now I am able to do either for the full row or full column. I am ready to loop through the rows and cols but for that I think I need to use <code>.write</code>, the issue here is that for <code>.write</code> I need to insert a value too, but the value is already available from Dataframe.</p>
  
  <p>How can I target to format specific cells like A1, A2, A3 for formatting it differently.</p>