title: Merge csv files to excel in Python
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/5705588/python-creating-excel-workbook-and-dumping-csv-files-as-worksheets">python: creating excel workbook and dumping csv files as worksheets</a>  </p>
  </blockquote>
  
  
  
  <p>How would you automate the task of taking several CSV files and placing them in a single excel (XLS\XLSX) file so that each CSV is a different sheet, optimally with the same name as the CSV file?</p>