Testing import of Excel files

_README_.md

Usage

Run like this for example:

python2 excel_test.py | column -t

Output should look like this:

first_name   last_name  email                     gender
Salomé       笑薇       [email protected]     Ms.
Océanne      漫妮       [email protected]       Fr.
Marie-josée  晧宇       [email protected]  Hr.
Örjan        香茹       [email protected]       Frau
Adèle        墨含       [email protected]       Mrs.
Eléonore     韵寒       [email protected]       Fr.
Maëly        韵含       [email protected]  Hr.
Zoé          茹怡       [email protected]         Mr.
Maëly        怡香       [email protected]          Herr
Pélagie      思宏       [email protected]      Fr.

excel_test.py

#!/usr/bin/env python

import sys
import codecs

# needed to be able to pipe output
sys.stdout = codecs.getwriter('utf8')(sys.stdout)

from xlrd import open_workbook

book = open_workbook('test_data.xls')
sheet = book.sheet_by_index(0)
for row in range(sheet.nrows):
    line = [sheet.cell(row,col).value for col in range(4)]
    print " ".join(line)

test_data.xls

test_data.xlsx