title: Format an Excel Sheet in Python
body: <p>I am importing data from various web queries into a Jupyter Notebook and cleaning it in there and creating various forecasts etc. </p>
  
  <p>The end output is required in an Excel file. 
  However, the Excel file I create is simply a table of data and not very user-friendly. </p>
  
  <p>One request I have from a user is to have the rows in the excel sheet in one color for weekends and another color for weekdays (the data is all datetime data). </p>
  
  <p>Is there anyway of automatic the formatting of the excel sheet in python so that the whole process of creating the sheet is automated?</p>
  
  <p>eg;
  First row of headers would be <strong>bold</strong>
  All rows representing weekend would be a one color. etc</p>
  
  <p>At present I'm using the xlsxwriter</p>
  
  <pre><code>writer = pd.ExcelWriter('Americas.xlsx', engine='xlsxwriter') 
  df.to_excel(writer, sheet_name='WestFacilities') 
  </code></pre>
  
  <p>Any help much appreciated! </p>