Tuesday, 1 December 2020

upload exel file convet to JSON in angular 4

import * as XLSX from 'ts-xlsx'; arrayBuffer: any; file: File; incomingfile(event) { this.file = event.target.files[0]; this.Upload(); } Upload() { let fileReader = new FileReader(); let me = this; 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(""); console.log(">>>", arr[i]); var workbook = XLSX.read(bstr, { type: "binary" }); var first_sheet_name = workbook.SheetNames[0]; var worksheet = workbook.Sheets[first_sheet_name]; console.log("worksheet:", XLSX.utils.sheet_to_json(worksheet, { raw: true })); me.jsonTrade(XLSX.utils.sheet_to_json(worksheet, { raw: true })); } fileReader.readAsArrayBuffer(this.file); }

No comments:

Post a Comment

IIS deployment support details

  Node JS - IIS deployment support details node: http://go.microsoft.com/?linkid=9784334 IISNode: https://github.com/azure/iisnode/releases/...