addfile(event) { let data, header; const target: DataTransfer = <DataTransfer>(event.target); this.isExcelFile = !!target.files[0].name.match(/(.xls|.xlsx)/); if (target.files.length > 1) { //this.inputFile.nativeElement.value = ''; } if (this.isExcelFile) { this.spinnerEnabled = true; const reader: FileReader = new FileReader(); reader.onload = (e: any) => { /* read workbook */ const bstr: string = e.target.result; const wb: XLSX.WorkBook = XLSX.read(bstr, { type: 'binary' }); /* grab first sheet */ const wsname: string = wb.SheetNames[0]; const ws: XLSX.WorkSheet = wb.Sheets[wsname]; /* save data */ data = XLSX.utils.sheet_to_json(ws); }; reader.readAsBinaryString(target.files[0]); reader.onloadend = (e) => { this.spinnerEnabled = false; this.keys = Object.keys(data[0]); //console.log(this.keys); //console.log(data); for(var i = 5; i != data.length; ++i) { console.log(data[i]); } //this.dataSheet.next(data) } } else { //this.inputFile.nativeElement.value = ''; } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)