download exel angular 4

import { ExcelService } from '../service/excel.service'; constructor(private excelService: ExcelService, ){} exportAsXLSX(dataJSON): void { this.excelService.exportAsExcelFile(dataJSON, 'sample'); } =========================Service import { Injectable } from '@angular/core'; import * as FileSaver from 'file-saver'; import * as XLSX from 'xlsx'; const EXCEL_TYPE = 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;charset=UTF-8'; const EXCEL_EXTENSION = '.xlsx'; @Injectable({ providedIn: 'root' }) export class ExcelService { constructor() { } public exportAsExcelFile(json: any[], excelFileName: string): void { const worksheet: XLSX.WorkSheet = XLSX.utils.json_to_sheet(json); console.log('worksheet',worksheet); const workbook: XLSX.WorkBook = { Sheets: { 'data': worksheet }, SheetNames: ['data'] }; const excelBuffer: any = XLSX.write(workbook, { bookType: 'xlsx', type: 'array' }); // //const excelBuffer: any = XLSX.write(workbook, { bookType: 'xlsx', type: 'buffer' }); this.saveAsExcelFile(excelBuffer, excelFileName); } private saveAsExcelFile(buffer: any, fileName: string): void { const data: Blob = new Blob([buffer], { type: EXCEL_TYPE }); FileSaver.saveAs(data, fileName + '_export_' + new Date().getTime() + EXCEL_EXTENSION); } } ====App.module import { ExcelService } from './service/excel.service'; providers: [ExcelService],

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); }