jfblog

Random logs and notes

Convert xls files to csv

I had to convert a bunch of xlsx files to csv. A simple solution is obtained thanks to the libraries in http://www.python-excel.org/. More specifically, I only had to use xlrd. It is as simple as

wb = xlrd.open_workbook(file)
sh = wb.sheet_by_name('Sheet1')

Now the sh object ...