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);
}
Also in JavaScript:
- how to add data modal target attribute in jquery
- react native android version code
- javascript dedupe array
- django regular expression
- express validator example
- js hide element by id
- text input underline react native
- how to include in ejs
- orderbychild firebase react
- react hooks call child fuynction
- install cypress
- Mobx-react console warning related observer
- hidden property input angular 2
- validatorjs number
- vuejs use set to prevent duplicates
- loop through api response in react
- "rbac" react redux navigation bar
- javascript picture delete after time
- create element javascript with id
- combine p5 with react
- how to remove spaces in javascript
- remove axis tick ends d3
- jednorozeclinda
- js fake await