title: how to export several .xls (Excel) files in a directory into a single .csv file?
body: <p>So I'm looking for a way to export all of the .xls files in a directory into a single .csv file. Any ideas as to how I would approach this?</p>
  
  <p>Specifically:</p>
  
  <p>say my directory contains-</p>
  
  <pre><code>wksht1.xls
  wksht2.xls
  wksht3.xls
  ...
  wksht1000.xls
  </code></pre>
  
  <p>how would I merge all of those files into a single .csv (We'll call is aggregate.csv).
  Assume each file has the maximum amount of worksheets/rows filled.</p>
  
  <p><em>All of the files are normalized to a data standard</em></p>
  
  <p>Thank you very much!</p>