Parse data from Excel using js-xlsx

Question

I am using the js-xlsx, here is a link to my excel sheet if needed. I'm using the following code:

/* set up XMLHttpRequest */
var url = "Test.xlsx";
var oReq = new XMLHttpRequest();
oReq.open("GET", url, true);
oReq.responseType = "arraybuffer";

oReq.onload = function(e) {
var arraybuffer = oReq.response;

/* convert data to binary string */
var data = new Uint8Array(arraybuffer);
var arr = new Array();
for(var i = 0; i != data.length; ++i) arr[i] =String.fromCharCode(data[i]);
var bstr = arr.join("");

/* Call XLSX */
var workbook = XLSX.read(bstr, {type:"binary"});

/* DO SOMETHING WITH workbook HERE */
var first_sheet_name = workbook.SheetNames[0];
/* Get worksheet */
var worksheet = workbook.Sheets[first_sheet_name];

console.log(XLSX.utils.sheet_to_json(worksheet,{raw:true}));
}
oReq.send();

In the console loge I get an output of:

(3) […]0: Object { FirstName: "Mayuresh", MiddleName: "Dinkar ", LastName: "Joshi", … }1: Object { FirstName: "Arun", MiddleName: "Vikas", LastName: "Pathak", … }2: Object { FirstName: "Narendra", MiddleName: "Damodardas", LastName: "Modi", … }length: 3<prototype>: Array []

I'm sure not sure how to access that data. I don't know it's name to call it. I tried arr.length, but it only returned 1 and it should've returned 3. The JS files returns a length of 3, but I'm not sure where it's pulling that from. I just need some accessing that Array. Thanks

danh · Accepted Answer · 2019-01-15 03:33:34Z

1

It looks like it's working. Try this to see...

let worksheet = workbook.Sheets[first_sheet_name];
let objects = XLSX.utils.sheet_to_json(worksheet,{raw:true});
let names = objects.map(object => `${object.FirstName} ${object.LastName}`);
console.log(names);

edited Jan 15, 2019 at 3:33

answered Jan 15, 2019 at 3:18

danh

62.7k10 gold badges100 silver badges139 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

mcadamsjustin Over a year ago

I got "TypeError: workbook.map is not a function". I know it's working, I just don't know how to tap into that array

mcadamsjustin Over a year ago

the new edit doesn't work, but let objects = XLSX.utils.sheet_to_json(worksheet,{raw:true}); let names = objects.map(object => ${object.FirstName} ${object.LastName}); did

danh Over a year ago

yikes. sorry, your response was so quick, i thought you were referring to the prior edit. will fix back. "to_json" is a really non-sensical name for that utlitly

Collectives™ on Stack Overflow

Parse data from Excel using js-xlsx

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related