title: xlsxwriter formatting is corrupting my excel file
body: <p>Question, i'm trying to apply some formatting on an xlsx file using xlsxwriter but Excel says my exported file is corrupt.</p>
  <p>I believe the issue stems from this line : format1 = workbook.add_format({'font_color': 'red'}) but I do not understand why.</p>
  <p>I have updated MS Excel to the latest version and have tried opening the file on another computer but I keep getting this error: <em>We found a problem with some content in 'export_top200format.xlsx'. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes.</em></p>
  <p>Followed by this error:</p>
  <p><em>Excel was able to open the file by repairing or removing the unreadable content.</em></p>
  <pre><code>import pandas as pd
  import os
  import xlsxwriter
  
  # IMPORTING dfCAtop200_CLEANED
  ca_top200_CLEANED = 'export_top200CLEANEDTEST.xlsx'
  
  # READING 'export_top200CLEANEDTEST.xlsx' FILE
  dfCAtop200_Formatted = pd.read_excel(
      ca_top200_CLEANED)
  
  column_list = dfCAtop200_Formatted.columns
  
  writer = pd.ExcelWriter(
      '/Users/BTS/Documents/python_work/ABC Charts/export_top200FORMATTED.xlsx', engine='xlsxwriter')
  
  dfCAtop200_Formatted.to_excel(writer, index=False)
  
  # to remove source header formatting
  
  for idx, val in enumerate(column_list):
      worksheet.write(0, idx, val)
  
  # workbook stuff
  
  workbook = xlsxwriter.Workbook('export_top200FORMATTED.xlsx')
  worksheet = writer.sheets['Sheet1']
  
  format1 = workbook.add_format({'font_color': 'red'})
  
  worksheet.set_column('B:B', 11, format1)
  
  
  writer.save()
  </code></pre>