convert multiple excel files to csv files with python

Question

Is there a way to convert multiple files? Can I use glob.glob?

import sys

sys.path.insert(0,'D:/apera/Python27/xlrd-0.9.3')

import xlrd

import csv

ExcelFile = "D:/apera/Workspace/Sounding/sounding010.xls"
CSVFile = "D:/apera/Workspace/Sounding/sounding010.csv"

def Convert(ExcelFile, SheetName, CSVFile):
    wb = xlrd.open_workbook(ExcelFile)
    ws = wb.sheet_by_name(SheetName)
    csvfile = open(CSVFile, 'wb')
    wr = csv.writer(csvfile, quoting=csv.QUOTE_ALL, delimiter=';')

    for rownum in xrange(ws.nrows):
         wr.writerow(
         list(x.encode('latin1')
              for x in ws.row_values(rownum)))

    csvfile.close()

Convert(ExcelFile, "INPUT", CSVFile)

Bob Haffner · Accepted Answer · 2014-12-14 16:09:30Z

1

Yes, glob combined with os will work

import os
import glob

os.chdir("yourfolder")
for f in glob.glob("*.xls"):
    #call your conversion function

answered Dec 14, 2014 at 16:09

Bob Haffner

8,5231 gold badge40 silver badges44 bronze badges

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

1 Comment

lalalala Over a year ago

can you tell me more specific? because it give me error. because the csv files need to make it multiple. i need your help. thanks

Collectives™ on Stack Overflow

convert multiple excel files to csv files with python

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related