Bind multiple TSV files into Excel workbook.

tsv2excel.py

#!/usr/bin/env python3
# -*- coding: utf-8 -*-

"""Bind multiple TSV files into Excel workbook.

Requires "xlwt" for Python 2.x, or "xlwt-future" for Python 3.x series.
"""

import os
import sys
from xlwt import Workbook

DELIMITER = '\t'
OUTPUT = 'book.xls'


def main():
    book = Workbook()
    for f in sys.argv[1:]:
        sheet = book.add_sheet(os.path.splitext(os.path.basename(f))[0])
        stream = map(lambda l: l.rstrip('\r\n').split(DELIMITER), open(f))
        for i, row in enumerate(stream):
            for j, v in enumerate(row):
                sheet.write(i, j, v)
    book.save(OUTPUT)

if __name__ == '__main__':
    main()

# vim: set et ts=4 sw=4 cindent fileencoding=utf-8 :