title: Rename worksheets' names from an .xls file
body: <p>I am creating an .xls file by converting two .csv files and joining them by following code:</p>
  
  <pre><code>import pandas as pd
  import xlwt
  from pandas 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,index = False)
      writer.save()
  
  save_xls((df,df1), "path/test.xls")
  </code></pre>
  
  <p>Of course I am creating dataframes df and df1 by reading two CSVs. And in path I am getting the joined .xls single file with two sheets (windows).</p>
  
  <p>But the worksheets names are <code>sheet0</code> and <code>sheet1</code> like this. My requirement is how to rename those sheets to <code>name1</code> and <code>name2</code>.</p>
  
  <p>i have tried passing a name tuple to it but throws error.</p>
  
  <pre><code>name = 'event','segment'
  
  df.to_excel(writer,name,index = False)  #inside function block
  
  #AttributeError: 'tuple' object has no attribute 'decode'
  </code></pre>
  
  <p>also tried to split the name tuple inside to_excel line:</p>
  
  <pre><code>df.to_excel(writer,name.split(","),index = False)
  
  #AttributeError: 'tuple' object has no attribute 'split'
  </code></pre>
  
  <p>So is there a way to rename those worksheets' names?</p>