title: Excel export with Flask server and xlsxwriter
body: <p>So I've been using XLSXWriter in the past to export an excel file containing one tab filled with two pandas dataframes. In the past I've only been exporting the file to a local path on the user's computer but I'm doing the transition to a web interface.</p>
  
  <p>My desired output is to have the same excel file as the code below, but created in memory and sent to the user for him/her to download through the web interface. I've been seeing a lot of Django and StringIO but I'm looking for something that could work with Flask and I could not find anything that actually worked. </p>
  
  <p>Is anybody familiar with this problem?</p>
  
  <p>Thanks in advance!</p>
  
  <pre><code>xlsx_path = "C:\test.xlsx"
  writer = pd.ExcelWriter(xlsx_path, engine='xlsxwriter')
  
  df_1.to_excel(writer,startrow = 0, merge_cells = False, sheet_name = "Sheet_1")
  df_2.to_excel(writer,startrow = len(df_1) + 4, merge_cells = False , sheet_name = "Sheet_1")                             
  
  workbook = writer.book
  worksheet = writer.sheets["Sheet_1"]
  format = workbook.add_format()
  format.set_bg_color('#eeeeee')
  worksheet.set_column(0,9,28)
  
  writer.close()
  </code></pre>