Menu
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
449
Explanation: First, the npm module is included in the read. js file and then the excel file is read into a workbook i.e constant file in the above program. A for loop is run until the end of the excel file starting from the first page.
A file with XLSX, XLSM, XLS, XLTX or XLTM extension is a Microsoft Excel file that uses specific standard file format. You can show or display file extension on Windows OS from Folder Options. MS Excel lets you save files in any of these file formats using the Save As option.
xlsm" is basically the same as ". xlsx" and can be opened with Excel 2007 and above. The only difference is that ". xlsm" starts the macro.
The package https://npmjs.org/package/excel-parser works for XLS & XLSX
152
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
