Convert a folder of CSVs into an Excel workbook, one worksheet per file.

CSVsToWorksheets.py

#!/usr/bin/python


"""CSVsToWorksheets.py: takes a folder of CSVs and puts them into a single Excel workbook, one worksheet per file."""

__author__ = "Zach Fogg"
__email__  = "[email protected]"


import xlwt, csv, os


csv_folder = "Output/"


book = xlwt.Workbook(encoding="utf8")
for fil in os.listdir(csv_folder):
    name = fil[:-18] # FIXME - clip the filenames to your liking
    sheet = book.add_sheet(name)
    with open(csv_folder + fil) as filname:
        reader = csv.reader(filname)
        i = 0
        for row in reader:
            for j, each in enumerate(row):
                sheet.write(i, j, each)
            i += 1


book.save("Output.xls")