Reputation: 101
I have a plunker attached herewith. http://plnkr.co/edit/RkUCchxd6UghOTclMDFj?p=preview
I am able to import a text file properly without any errors. However, when I try to import an Excel file, it imports random alphanumeric values and unrelated data.
Can you please let me know if there is an easy way out there to import and Excel file (csv and xlsx file )?
I read online and found this document but I am not sure how it is used in JavaScript and HTML. Can anyone help?
http://psjinx.com/programming/2014/01/04/parsing-excel-workbooks-using-javascript/
<html>
Upvotes: 0
Views: 40841
Reputation: 89
You may use js-xlsx library to parse excel file to json using javascript js-xlsx
the readme file explain how to use the library, or you may refer to the following article which talks about the library usage Parse and Read Excel Files (xls/xlsx) With JavaScript
Upvotes: 4