title: Saving multiple dataframes to multiple excel sheets multiple times?
body: <p>I have a function to save multiple dataframes as multiple tables to single excel workbook sheet:</p>
  
  <pre><code>def multiple_dfs(df_list, sheets, file_name, spaces):
      writer = pd.ExcelWriter(file_name,engine='xlsxwriter')   
      row = 0
      for dataframe in df_list:
          dataframe.to_excel(writer,sheet_name=sheets,startrow=row , startcol=0)   
          row = row + len(dataframe.index) + spaces + 1
      writer.save()
  </code></pre>
  
  <p>If I call this function multiple times to write multiple tables to multiple sheets, I end up with just one workbook and one sheet, the one that was called last:</p>
  
  <pre><code>multiple_dfs(dfs_gfk, 'GFK', 'file_of_tables.xlsx', 1)
  multiple_dfs(dfs_top, 'TOP', 'file_of_tables.xlsx', 1)
  multiple_dfs(dfs_all, 'Total', 'file_of_tables.xlsx', 1)
  </code></pre>
  
  <p>So in the end I only have <code>file_of_tables</code> workbook with only <code>Total</code> sheet. I know it's a simple problem, but somehow I just can not think of any elegant solution to this. Can anyone help?</p>