I am unable to read from .xls file using exceljs library. I also tried to read after changing my file in .xlsx using fs but still I am unable to read data from that file. Is there any way to read from .xls file using exceljs?
I am unable to read from .xls file using exceljs library. I also tried to read after changing my file in .xlsx using fs but still I am unable to read data from that file. Is there any way to read from .xls file using exceljs?
Share Improve this question asked Oct 15, 2019 at 10:00 Lokesh JainLokesh Jain 5796 silver badges19 bronze badges 3- What error are you getting? – Aslam Commented Oct 15, 2019 at 10:04
-
.xls
and.xlsx
are two very different formats, and renaming the file will not magically convert it. All you get is anxls
file with the wrong file ending. exceljs doesn't supportxls
, which is the older, proprietary format.xlsx
is an open standard and just zipped xml, which is easy to support. – user5734311 Commented Oct 15, 2019 at 10:06 - @Aslam I am not getting any error or data – Lokesh Jain Commented Oct 15, 2019 at 10:22
1 Answer
Reset to default 6While its documentation does not say it explicitly, exceljs
only supports either XLSX or CSV:
- https://github./exceljs/exceljs/issues/148
- https://github./exceljs/exceljs/issues/165