title: write multiple excel files with xlsxwriter python
body: <p>is there a way to create multi excel files with xlsxwriter?</p>
  
  <pre><code>from itertools import chain
  import glob ,csv, sys, os
  
  openSoundingFile = 'D:/apera/Workspace/Sounding2/*.txt'
  
  
  for filename in glob.glob(openSoundingFile):
      newName = filename
      spamReader = csv.reader(open(filename, 'rb'), delimiter=';',quotechar='"')
      workbook = xlsxwriter.Workbook('D:/apera/Workspace/Sounding2/' + newName[:-4] + '.xlsx'
      sheet = workbook.add_worksheet('Original data')
  
      for rowx, row in enumerate(spamReader):
          for colx, value in enumerate(row):
              sheet.write(rowx, colx, value)
  
  
      workbook.close()
  </code></pre>
  
  <p>so i wanna to save all the txt files to exel files. I think the problem is here</p>
  
  <pre><code>workbook = xlsxwriter.Workbook('D:/apera/Workspace/Sounding2/' + newName[:-4] + '.xlsx'
  </code></pre>
  
  <p>if i'm not using  <code>+ newName[:-4] +</code> it will work but only write 1 excel files. Is there a way to do it? </p>