cheerPuncH
July 31st, 2012, 08:56 PM
Hi,
I installed the python module pyExcelerator on my local Ubuntu (the latest LTS) and the following works fine.
sudo python xls2cvs variants.xls > variants.csv
However, when I move it to the server (Ubuntu 10.04.2 LTS), it does not work. It complains....
ionadmin@ionT01:/results/analysis/output/Home/TuesdayJuly31_064/plugin_out/variantCaller_out/IonXpress_001$ python /home/ionadmin/tools/pyexcelerator-0.6.4.1/tools/xls2csv.py variants.xls > variants.csv
extracting data from variants.xls
Traceback (most recent call last):
File "/home/ionadmin/tools/pyexcelerator-0.6.4.1/tools/xls2csv.py", line 17, in <module>
for sheet_name, values in parse_xls(arg, 'cp1251'): # parse_xls(arg) -- default encoding
File "/usr/local/lib/python2.6/dist-packages/pyExcelerator/ImportXLS.py", line 327, in parse_xls
ole_streams = CompoundDoc.Reader(filename).STREAMS
File "/usr/local/lib/python2.6/dist-packages/pyExcelerator/CompoundDoc.py", line 63, in __init__
self.__build_header()
File "/usr/local/lib/python2.6/dist-packages/pyExcelerator/CompoundDoc.py", line 105, in __build_header
raise Exception, 'Not an OLE file.'
Exception: Not an OLE file.
I know Ubuntu has Python 2.6 installed and I made sure the module supports 2.6 and it does (2.4 and above).
This leads me to believe that there is a dependency missing. How can I find this dependency? It is essential to get the csv to make our pipeline-ing go a lot smoother. Thanks in advance!
I installed the python module pyExcelerator on my local Ubuntu (the latest LTS) and the following works fine.
sudo python xls2cvs variants.xls > variants.csv
However, when I move it to the server (Ubuntu 10.04.2 LTS), it does not work. It complains....
ionadmin@ionT01:/results/analysis/output/Home/TuesdayJuly31_064/plugin_out/variantCaller_out/IonXpress_001$ python /home/ionadmin/tools/pyexcelerator-0.6.4.1/tools/xls2csv.py variants.xls > variants.csv
extracting data from variants.xls
Traceback (most recent call last):
File "/home/ionadmin/tools/pyexcelerator-0.6.4.1/tools/xls2csv.py", line 17, in <module>
for sheet_name, values in parse_xls(arg, 'cp1251'): # parse_xls(arg) -- default encoding
File "/usr/local/lib/python2.6/dist-packages/pyExcelerator/ImportXLS.py", line 327, in parse_xls
ole_streams = CompoundDoc.Reader(filename).STREAMS
File "/usr/local/lib/python2.6/dist-packages/pyExcelerator/CompoundDoc.py", line 63, in __init__
self.__build_header()
File "/usr/local/lib/python2.6/dist-packages/pyExcelerator/CompoundDoc.py", line 105, in __build_header
raise Exception, 'Not an OLE file.'
Exception: Not an OLE file.
I know Ubuntu has Python 2.6 installed and I made sure the module supports 2.6 and it does (2.4 and above).
This leads me to believe that there is a dependency missing. How can I find this dependency? It is essential to get the csv to make our pipeline-ing go a lot smoother. Thanks in advance!