title: Write csv to excel with pandas
body: <p>I have 13 csv files in a folder called data, and I want to export that csv's files in the numerical order (1.csv,2.csv ...13.csv) to a excel file having each sheet named (1,2,3,4,5...13). I tryed something like this:</p>
  
  <pre><code>from pandas.io.excel import ExcelWriter
  import pandas
  
  ordered_files = ['1.csv', '2.csv','3.csv','4.csv', '5.csv','6.csv','7.csv', '8.csv','9.csv','10.csv', '11.csv','12.csv','13.csv']
  
  with ExcelWriter('my_excel.xlsx') as ew:
      for csv_file in ordered_files:
          pandas.read_csv(csv_file).to_excel(
                          ew, index = False, sheet_name=csv_file, encoding='utf-8')
  </code></pre>
  
  <p>And I have two problems with this:</p>
  
  <ol>
  <li><p>As you see in my list, I can't import the files directly from my folder data, if I will try:</p>
  
  <p>ordered_files = ['data/1.csv']
  Wont found a valid csv.</p></li>
  <li><p>If I use that list method, my sheet will be named 3.csv for example instead of just 3.</p></li>
  </ol>
  
  <p>A side question, coming from csv I saw some columns that should be int number with the format as strings with a <strong>'</strong> in front.</p>
  
  <p>Thank you so much for your time! I use python 3!</p>