title: Save list of DataFrames to multisheet Excel spreadsheet
body: <p>How can I export a list of DataFrames into one Excel spreadsheet?<br>
  The docs for <a href="http://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.to_excel.html"><code>to_excel</code></a> state:</p>
  
  <blockquote>
    <p>Notes<br>
    If passing an existing ExcelWriter object, then the sheet will be added
    to the existing workbook.  This can be used to save different
    DataFrames to one workbook</p>
    
    <p><code>writer = ExcelWriter('output.xlsx')</code><br>
    <code>df1.to_excel(writer, 'sheet1')</code><br>
    <code>df2.to_excel(writer, 'sheet2')</code><br>
    <code>writer.save()</code></p>
  </blockquote>
  
  <p>Following this, I thought I could write a function which saves a list of DataFrames to one spreadsheet as follows:</p>
  
  <pre><code>from openpyxl.writer.excel import ExcelWriter
  def save_xls(list_dfs, xls_path):
      writer = ExcelWriter(xls_path)
      for n, df in enumerate(list_dfs):
          df.to_excel(writer,'sheet%s' % n)
      writer.save()
  </code></pre>
  
  <p>However (with a list of two small DataFrames, each of which can save <code>to_excel</code> individually), an exception is raised <em>(Edit: traceback removed)</em>:</p>
  
  <pre><code>AttributeError: 'str' object has no attribute 'worksheets'
  </code></pre>
  
  <p>Presumably I am not calling <a href="http://www.nullege.com/codes/search?cq=openpyxl.writer.excel.ExcelWriter"><code>ExcelWriter</code></a> correctly, how should I be in order to do this?</p>