Skip to main content
 首页 » 编程设计

python之使用 xlsxwriter python 写入多个 excel 文件

2024年10月25日12luoye11

有没有办法用 xlsxwriter 创建多个 excel 文件?

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

所以我想把所有的txt文件保存到exel文件中。我觉得问题出在这里

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

如果我不使用 + newName[:-4] + 它会工作但只写 1 个 excel 文件。有办法吗?

请您参考如下方法:

错误表明您将文件的路径彼此叠加了 2 次:

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

这是为我做的:

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