Parse xls/xlsx/xlsm in Node.js

Question

Running in Node.js, I need to be able to parse cell value's from Excel .xls,.xlsx, and .xlsm.

Are there solutions available? I doubt there's a single module out there that will do the trick, so perhaps there is a way to internally convert two of the formats into the third and have a single format parser?

Has anyone else encountered this problem? If so, what kind of solution did you come up with?

Any help is greatly appreciated. Thank you

@Nirk I have both those up and working. *xlsm* is where I run into trouble — gone, Jul 18 '13 at 14:40

score 7 · Answer 1 · answered Oct 15 '13 at 15:19

7

The package https://npmjs.org/package/excel-parser works for XLS & XLSX

answered Oct 15 '13 at 15:19

Robbert

182
1
4

3

why vote downs? Anything wrong with npm module? I was thinking of using it. – Raeesaa May 06 '14 at 06:31
1

how to install python in node.js application? – Hardik Mandankaa Mar 18 '17 at 13:56

score 2 · Answer 2 · answered Dec 08 '15 at 16:44

The node module named 'xlsx' (https://www.npmjs.com/package/xlsx) claims to parse *.xlsm files. I've used it with *.xls and *.xlsx files successfully. I don't see any reference to having to have Python installed, although I do have it installed so I can't be sure if it's needed.

score 1 · Answer 3 · answered Oct 11 '15 at 13:37

1

Another option that does not require python to be installed is node-xlsx.

answered Oct 11 '15 at 13:37

Rafael Vega

4,575
4
32
50

score 0 · Answer 4 · answered May 06 '17 at 13:14

0

you can use excel-parser or xlsx from npm. more information npm xlsx

answered May 06 '17 at 13:14

Daniel Taub

5,133
7
42
72

Parse xls/xlsx/xlsm in Node.js

4 Answers4