How to Export to Excel Mat-Table in Angular

This library will do the trick:

https://www.npmjs.com/package/mat-table-exporter

+1

Use Link using angular

Export in Excel	https://stackblitz.com/edit/angular-material-table-export-excel-xlsx
Exportin PDF	https://stackoverflow.com/questions/57443246/how-can-we-print-and-download-mat-table-as-pdf
Export in PDF	https://morioh.com/p/44aeb57cdf81

+1

Muthu Kumar7y ago

Here is the solution for you.It's looks like similar to you.

https://stackoverflow.com/questions/50398284/angular-material-data-table-export-to-excel

+2

Amit Kumar Singh7y ago

Hi Joginder,

this code I have written

const ws: XLSX.WorkSheet = XLSX.utils.table_to_sheet(this.exporttable.nativeElement);

console.log(this.exporttable.nativeElement);

const wb: XLSX.WorkBook = XLSX.utils.book_new();

XLSX.utils.book_append_sheet(wb,ws,'Sheet1');

console.log(wb);

XLSX.writeFile(wb,'IMPS.xlsx');

+2

Joginder Banger7y ago

it seems to you have selected wrong range, it should be A1:A10 or have selected the greater than 1.

+2