Convert Excel to JSON using Angularjs

Question

I am trying to have a user upload an excel file from their computer then convert it to JSON. I am needing these files as JSON. I have it so they can upload a csv to JSON. Now I am wanting excel to JSON. Any advice or guidance on this would be appreciated. This needs to be done using angularJS. Thanks!

http://www.joyofdata.de/blog/parsing-local-csv-file-with-javascript-papa-parse/ somewhat doable — Pankaj Parkar, Feb 18 '15 at 18:08

score 3 · Answer 1 · edited May 23 '17 at 12:26

Forget about file manipulation using AngulaJS. Angular is a front-end JS framework with no file manipulation support whatsoever. You need to have access to server where the file is stored and you will only get it with server side language.

EDIT:

Ok, I have learnt that you can use FileReader API or $parse Angular service to read file contents on the front-end, which is really cool.

Option A: Read this StackOverflow question and answer and follow the plnkr to see an example of FileReader API being used with Angular. Kudos to @MajoB for providing an excellent answer and code sample.

Option B: Check official Angular documentation to read about $parse service and check this fiddle to see it in action.

Unfortunately neither FileReader API nor $parse service can read Excel files. They can read .txt, .csv, .json, and even .html but not .xlsx

I am trying to have the user upload a file and my controller will take it in and do all the data manipulation. — Troy Reynolds, Feb 24 '15 at 15:27
Hi Troy, I edited my original answer, it looks like there are ways to parse file contents on the front-end. — codeepic, Feb 24 '15 at 15:53

score 1 · Answer 2 · answered Aug 18 '17 at 14:19

1

Example code :

http://jsfiddle.net/d2atnbrt/3/

External library:

https://github.com/SheetJS/js-xls

answered Aug 18 '17 at 14:19

Krzysztof Raciniewski

4,735
3
21
42

Convert Excel to JSON using Angularjs

2 Answers2