Is there a commandline tool for viewing/opening excel (.xls) files?
So the answer works great unless the worksheets don't have a custom name.
When I try to open the file, I get:
Traceback (most recent call last): File "/usr/bin/py_xls2csv", line 17, in <module> for sheet_name, values in parse_xls(arg, 'cp1251'): # parse_xls(arg) -- default encoding File "/usr/lib/python2.5/site-packages/pyExcelerator/ImportXLS.py", line 334, in parse_xls raise Exception, 'No workbook stream in file.' Exception: No workbook stream in file.
However, if I open up the file and rename the sheet to 'test' or something it works fine. What do I need to tweak so that it can handle the default names? (Sheet1, etc)
The file I'm trying to open at present has only 1 sheet, named Sheet1.