leftshifters / excel-parser

nodejs wrapper for parsing spreadsheet.
MIT License
72 stars 70 forks source link

xlsx doesn't work in linux #12

Open shaiui opened 10 years ago

shaiui commented 10 years ago

Great package, just ran into an issue though..

I'm running python 2.75 along with xlrd 0.9.2 on both a windows and a linux box. Windows is running node: v0.10.13 Linux is running node: v0.10.15 I'm using the current excel-parser from "npm install" as of this date.

In windows, all is fine: reads xls and xlsx In linux: reads xls files ok. But xlsx files (even simple ones) throws the following error:

{ [Error: Command failed: Traceback (most recent call last): File "/apps/home/joe/myproject/node_modules/excel-parser/convert.py", line 504, in convert2csv(args.inFile, outfile, args.sheetFlag, args.sheetId, args.sheetName) File "/apps/home/joe/myproject/node_modules/excel-parser/convert.py", line 117, in convert2csv convertXlsx(ziphandle, sheetFlag, sheetId, sheetName, writer) File "/apps/home/joe/myproject/node_modules/excel-parser/convert.py", line 123, in convertXlsx shared_strings = parse(ziphandle, SharedStrings, "xl/sharedStrings.xml") File "/apps/home/joe/myproject/node_modules/excel-parser/convert.py", line 198, in parse instance.parse(ziphandle.read(filename)) File "/usr/local/lib/python2.7/zipfile.py", line 931, in read return self.open(name, "r", pwd).read() File "/usr/local/lib/python2.7/zipfile.py", line 1006, in open close_fileobj=should_close) File "/usr/local/lib/python2.7/zipfile.py", line 526, in init self._decompressor = zlib.decompressobj(-15) AttributeError: 'NoneType' object has no attribute 'decompressobj' ] killed: false, code: 1, signal: null }

Please advise

sthawali commented 10 years ago

@foreyez Can you try tests and send its results. grunt nodeunit

chiuan commented 10 years ago

when run grunt nodeunit on my osx. it always shows:

Testing parse_test.jsFatal error: Cannot read property 'length' of undefined