How to Extract/Read data from Excel document in Angular
Extract/Read data from Excel document in Angular EXCEL DATA RESULT Install node library: npm i xlsx Dependency Link Import XLSX Package import * as XLSX from 'xlsx' ; Install node library: <input type="file" (change)="onFileChange($event)"> Event to extract data from Excel document in typescript: onFileChange ( event: any ) { /* wire up file reader */ const target : DataTransfer = < DataTransfer >(event. target ); if (target. files . length !== 1 ) { throw new Error ( 'Cannot use multiple files' ); } const reader : FileReader = new FileReader (); reader. readAsBinaryString (target. files [ 0 ]); reader. onload = ( e: any ) => { /* create workbook */ const binarystr : string = e. target . result ; const wb : XLSX . WorkBook = XLSX . read (binarystr, { type : 'binary' }); /* selected the first sheet */ const wsname : string = wb. SheetNames