/Javascript/AngularJS/Read xlsx file in angular 5

Read xlsx file in angular 5

//import it

    import * as XLSX from 'ts-xlsx';

//inside export class

arrayBuffer:any;
file:File;
incomingfile(event) 
  {
  this.file= event.target.files[0]; 
  }

 Upload() {
      let fileReader = new FileReader();
        fileReader.onload = (e) => {
            this.arrayBuffer = fileReader.result;
            var data = new Uint8Array(this.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 first_sheet_name = workbook.SheetNames[0];
            var worksheet = workbook.Sheets[first_sheet_name];
            console.log(XLSX.utils.sheet_to_json(worksheet,{raw:true}));
        }
        fileReader.readAsArrayBuffer(this.file);
}

Source: stackoverflow.com

Similar codes

0 vote319 views1 answer
Angular load json file with httpclient
Javascript AngularJS
1 vote302 views1 answer
Angular run validation on other controls
Javascript AngularJS
0 vote312 views1 answer
Return index of array with function in array angular
Javascript AngularJS
0 vote340 views1 answer
Angular keyframes %
Javascript AngularJS
2 votes317 views1 answer
Refresh date and time every second angular
Javascript AngularJS
5 votes301 views1 answer
Experimental support for decorators is a feature that is subject to change in a future release. Set the 'experimentalDecorators' option in your 'tsconfig' or 'jsconfig' to remove this warning.ts(1219) angular
Javascript AngularJS
0 vote310 views1 answer
Angular array export to excel
Javascript AngularJS
-1 vote335 views1 answer
Angularjs form validation on submit
Javascript AngularJS
0 vote307 views1 answer
No provider service angular
Javascript AngularJS
0 vote320 views2 answers
Function with return type in angular
Javascript AngularJS