write multiple excel files with xlsxwriter python

Question

is there a way to create multi excel files with xlsxwriter?

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()

so i wanna to save all the txt files to exel files. I think the problem is here

workbook = xlsxwriter.Workbook('D:/apera/Workspace/Sounding2/' + newName[:-4] + '.xlsx'

if i'm not using + newName[:-4] + it will work but only write 1 excel files. Is there a way to do it?

What happens when you run the program?

John Zwinck
– John Zwinck

2014-12-23 09:11:15 +00:00
Commented Dec 23, 2014 at 9:11 — John Zwinck
– John Zwinck, Commented Dec 23, 2014 at 9:11

PascalVKooten · Accepted Answer · 2014-12-23 09:15:09Z

2

The error showed that you combined the path to the files 2 times on top of each other:

'D:/apera/Workspace/Sounding2/bla.txtD:/apera/Workspace/Sounding2/'

This does it for me:

import xlsxwriter
import glob ,csv

openSoundingFile = 'D:/apera/Workspace/Sounding2/*.txt'

for filename in glob.glob(openSoundingFile):
    spamReader = csv.reader(open(filename, 'rb'), delimiter=';',quotechar='"')
    # Note that filename is the full path already! Just [:-4] to remove .txt
    workbook = xlsxwriter.Workbook(filename[:-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()

answered Dec 23, 2014 at 9:15

PascalVKooten

21.6k18 gold badges115 silver badges169 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

write multiple excel files with xlsxwriter python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related