导出excel方法

1.先安装两个插件:

1. npm install xlsx –save 
2. npm install file-saver –save

2.引入:

import * as FileSaver from 'file-saver';
import * as XLSX from 'xlsx';

3.html

 <a (click)="exportExcle()">导出数据</a>

4.js代码如下:

exportExcle() {
  this.listOfData.forEach((item) => {
    this.exportData.push({
      房屋名: item.house + '\t',
      开门时间: item.time + '\t',
      开门人姓名: item.name + '\t',
      手机号码: item.phone + '\t',
      开门人身份: item.role + '\t',
      开门方式: item.type + '\t',

    });
  });
  const worksheet: XLSX.WorkSheet = XLSX.utils.json_to_sheet(this.exportData);
  const workbook: XLSX.WorkBook = {Sheets: {data: worksheet}, SheetNames: ['data']};
  const excelBuffer: any = XLSX.write(workbook, {bookType: 'xlsx', type: 'array'});
  this.saveAsExcelFile(excelBuffer, `${this.RangeData.startTime}日到 ${this.RangeData.endTime}日开锁记录`);


}
private saveAsExcel(buffer: any, fileName: string){
  const data: Blob = new Blob([buffer], {type: 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;charset=UTF-8'})
  FileSaver.saveAs(data, fileName + '.xlsx');
}