将PrimeNG表导出到Excel文件(xlsx)

npm install xlsx file-saver --save

import * as XLSX from 'xlsx';
import { saveAs } from 'file-saver';

exportToExcel(table: Table) {
  const fileName = 'data.xlsx';
  const ws: XLSX.WorkSheet = XLSX.utils.table_to_sheet(table.el.nativeElement);
  const wb: XLSX.WorkBook = XLSX.utils.book_new();
  XLSX.utils.book_append_sheet(wb, ws, 'Sheet1');
  const excelBuffer: any = XLSX.write(wb, { bookType: 'xlsx', type: 'array' });
  const blob = new Blob([excelBuffer], { type: 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;charset=UTF-8' });
  saveAs(blob, fileName);
}

<button (click)="exportToExcel(table)">导出Excel</button>