Comments on: Easily Import Spreadsheets into UI-Grid

By: Brian Hann

Brian Hann — Thu, 14 Dec 2017 17:59:00 +0000

Thanks for the tip. I’ve updated the plunk.

By: Vinod Nadar

Vinod Nadar — Thu, 14 Dec 2017 15:59:00 +0000

change script reference to https from http. It starts working

By: aggelos kappos

aggelos kappos — Mon, 02 Oct 2017 11:16:00 +0000

Hello! i want to use UI GRiD for a SPA in order to take csv files and display the data into the grid to my view? I would imagine that i have to follow the same process in order to have the functionality ready, wouldn’t i?
Also , another question which comes after maybe a personal misunderstood: if i use the $http service in order to get a csv file and display it in my view , is it possible? or the $http service covers only json formats?
Thank you…

By: sreeja .c

sreeja .c — Mon, 25 Sep 2017 05:43:00 +0000

Hi,
Could you please help me to upload multiple files and combine them all into one grid.
Thank you

By: Tomaž

Tomaž — Tue, 22 Aug 2017 15:37:00 +0000

Plunker not working and not exactly the same as the tutorial. Did you forget to write down some code from MainCtrl in the tutorial?

By: Ignacio Caballero

Ignacio Caballero — Thu, 20 Jul 2017 10:42:00 +0000

Hello,
I would like to know how to directly access to an excel file in the server without uploading it. Maybe with a button that launches a js function.

By: Brian Hann

Brian Hann — Fri, 07 Jul 2017 13:46:00 +0000

Check your console to see if there are any errors.

By: ashok

ashok — Fri, 07 Jul 2017 07:03:00 +0000

Hi Brian,
I tried to upload an excel file,after uploading excel in the plunker nothing happens .Appreciate your help.

Thanks

By: fudfighter

fudfighter — Mon, 12 Jun 2017 21:02:00 +0000

IE10 and later.

By: Mamasa

Mamasa — Fri, 26 May 2017 11:20:00 +0000

Will this work in internet explorer? Please help me

By: fudfighter

fudfighter — Fri, 10 Mar 2017 15:06:00 +0000

This article pointed me in the right direction. Here are the couple tweaks I needed.
The use of the readAsBinaryString is officially not recommended, but the use of readAsArrayBuffer is. From David Jones’ answer on StackOverflow (http://stackoverflow.com/questions/18582643/alternative-to-readasbinarystring-for-ie10#18582809), you just need to massage the data from array buffer into a binary string in the onload handler:

var data = “”;
var bytes = new Uint8Array(evt.target.result);
var length = bytes.byteLength;
for (var i = 0; i < length; i++) {
data += String.fromCharCode(bytes[i]);
}
var workbook = XLSX.read(data, {type: 'binary'});

then replace the read statement with:

reader.readAsArrayBuffer(changeEvent.target.files[0]);

Thank You, Brian!

By: Akash

Akash — Mon, 20 Feb 2017 06:44:00 +0000

Thanks Shailendra for your reply, I didn’t get what you mean, Please can you elaborate. COde doesn’t have any line like charCodeAt(0)

By: Shailenrdra Tripathi

Shailenrdra Tripathi — Tue, 14 Feb 2017 18:15:00 +0000

issue reolved..changed return charCodeAt(0) with 80..

By: Shailenrdra Tripathi

Shailenrdra Tripathi — Tue, 14 Feb 2017 18:14:00 +0000

change return charCodeAt(0) with 80.. it should work.

By: Shailenrdra Tripathi

Shailenrdra Tripathi — Tue, 14 Feb 2017 14:06:00 +0000

This is not working in IE11. Gettig Error -Object doesn’t support property or method ‘charCodeAt’
at firstbyte (https://cdn.rawgit.com/SheetJS/js-xlsx/v0.8.0/dist/xlsx.full.min.js:18:21435)
and many more.
Any workaround of this or could you send me the uncpomressed file so that I can take a look.

By: Brian Hann

Brian Hann — Fri, 10 Feb 2017 15:32:00 +0000

Not sure what the problem might be. I’d check for bug reports in js-xlsx regarding whichever version of Angular you’re using. 1.x isn’t very specific.

By: Brian Hann

Brian Hann — Fri, 10 Feb 2017 15:31:00 +0000

Can’t tell what’s going on; you’ll need be very specific about the issue and provide some details.

By: Sunny negi

Sunny negi — Fri, 10 Feb 2017 05:37:00 +0000

@brianhann:disqus any help on this.

By: Sunny negi

Sunny negi — Thu, 09 Feb 2017 08:11:00 +0000

Facing issue while getting data from spredsheet in json data is missing.
chck image please
https://uploads.disquscdn.com/images/1883586d809437d0b7a9642e0cfdf53d4818b2abba216238eb823aa269fb8c7f.png https://uploads.disquscdn.com/images/154ef3e0df95df2e6d982416dbd6e35876ea94e7fb76d5a66e61a8e9ce61f83b.png

By: Akash

Akash — Tue, 07 Feb 2017 08:40:00 +0000

Thanks @brianhann:disqus for this great and very helpful article.

I am facing an issue with IE11, the data doesn’t reflect in the grid, the file gets selected using the choose file button but it doesn’t get uploaded it seems, there are no errors in console.

Please can you guide how to resolve this issue.

Thanks in anticipation.