title: Trying to merge all multiple CSV files to one excel workbook
body: <p>I am able to execute the below code in python 2.7 and able to merge all csv files to a single excel workbook . But when i am trying to execute in python 3.4 . Getting an error . Let me know if anyone faced this issue and sorted out . 
  Code:- </p>
  
  <pre><code>import glob, csv, xlwt, os
  wb = xlwt.Workbook()
  for filename in glob.glob(r'E:\BMCSoftware\Datastore\utility\BPM_Datastore_Utility\*.csv'):
      #print (filename)
      (f_path, f_name) = os.path.split(filename)
      #print (f_name)
      (f_short_name, f_extension) = os.path.splitext(f_name)
      #print (f_short_name)
      ws = wb.add_sheet(f_short_name)
      #print (ws)
      with open(filename, 'rU') as f:
          spamReader = csv.reader(f)
          for rowx, row in enumerate(spamReader):
              for colx, value in enumerate(row):
                  ws.write(rowx, colx, value)
      wb.save("f:\find_acs_errors_ALL_EMEA.xls")
  </code></pre>
  
  <p>ERROR:- </p>
  
  <pre><code>&gt;&gt;&gt; 
  Traceback (most recent call last):
    File "E:\BMCSoftware\Python34\Copy of DataStore.py", line 16, in &lt;module&gt;
      wb.save("f:\find_acs_errors_ALL_EMEA.xls")
    File "E:\BMCSoftware\Python34\lib\site-packages\xlwt-1.0.0-py3.4.egg\xlwt\Workbook.py", line 696, in save
      doc.save(filename_or_stream, self.get_biff_data())
    File "E:\BMCSoftware\Python34\lib\site-packages\xlwt-1.0.0-py3.4.egg\xlwt\CompoundDoc.py", line 262, in save
      f = open(file_name_or_filelike_obj, 'w+b')
  FileNotFoundError: [Errno 2] No such file or directory: 'f:\x0cind_acs_errors_ALL_EMEA.xls'
  &gt;&gt;&gt; 
  </code></pre>