helvio88/angular-xlsx-model

Angular model to convert XLSX files into JSON directly into the model

angular-xlsx-model

Angular directive to convert XLSX files into JSON directly into the model.

Not compatible with Internet Explorer. It doesn't support JS readAsBinaryString. Will not fix.

Usage

Install with bower:

bower install angular-xlsx-model --save

Add to your HTML files:

<script src='/bower_components/xlsx-model/xlsx-model.js'></script>

Inject the directive to your angular application:

angular.module('myApp', ['xlsx-model']);

Start using:

index.html:

<input type='file' xlsx-model='excel'>
<pre>{{excel | json}}</pre>

Demo

Check this Plunker: http://plnkr.co/edit/inETA0PcxIkm4EmS9qjD?p=preview.

Author

© 2016, Helvio Pedreschi <[email protected]>.

License

The files are licensed under the MIT terms.

angular-xlsx-model's Issues

Anyone can guide me how to post json data to mongodb using angular

i used angular-xlsx-model to convert my excel into json and now i want to send json to mongodb using angular

Here is my sample excel data sheet

Internet Explorer Compability Issue for readAsBinaryString function

I figured out how to solve Internet Explorer compability issue.

You have to add following script for extend FileReader.readAsBinaryString function to head of your html page.
if (FileReader.prototype.readAsBinaryString === undefined) { FileReader.prototype.readAsBinaryString = function (fileData) { var binary = ""; var pt = this; var reader = new FileReader(); reader.onload = function (e) { var bytes = new Uint8Array(reader.result); var length = bytes.byteLength; for (var i = 0; i < length; i++) { binary += String.fromCharCode(bytes[i]); } pt.content = binary; $(pt).trigger('onload'); } reader.readAsArrayBuffer(fileData); } }
After that in xlsx-model.js file; you should add the following lines after onload functions.
if (!file) { var data1 = reader.content; } else { var data1 = file.target.result; }

I combined it with the information on this page.
It gave a successful result.

Receiving error: Uncaught ReferenceError: XLSX is not defined at FileReader.reader.onload (xlsx-model.js:68)

Uncaught ReferenceError: XLSX is not defined
at FileReader.reader.onload (xlsx-model.js:68)

Does not work in internet explorer

You get an error on xlsx-model.js line 86: Object doesn't support property or method 'readAsBinaryString'

I then tried this workaround: http://stackoverflow.com/a/32665193/1324921

And I got an error on line 67: Unable to get property 'target' of undefined or null reference

You can replicate this with the Plunker you listed on your repo.