CODEWITHSUNDEEP
javascriptjqueryhtmlexcel
Arjun
Arjun

Reputation: 31

How to get a Header from xls/xlsx in JavaScript or jQuery?

How to get only header values from the xls/xlsx file in JavaScript or jQuery without parsing the whole file?. XLSX.read(data, { type: 'binary' }); taking too much time for parsing. But I need only headers on browser side. I'll do the rest on server-side. Thank you.

Upvotes: 0

Views: 2563

Answers (1)

Krunal Shah
Krunal Shah

Reputation: 863

var url = "your excel file.xlsx";
var oReq = new XMLHttpRequest();
oReq.open("GET", url, true);
oReq.responseType = "arraybuffer";
oReq.onload = function(e) {
  var arraybuffer = oReq.response;
  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("");
  var workbook = XLSX.read(bstr, {type:"binary"});
  var t = workbook.SheetNames;
}
oReq.send();

Upvotes: 1

Related Questions