在angular里的使用js-xlsx生成Excel文件

发表于

js-xlsx使用js生成Excel文件

下载

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

下载xlsx用于生成Excel, 下载file-saver来保存文件

引入

1
2
import {utils, write, WorkBook} from 'xlsx';
import {saveAs} from 'file-saver';

使用

1
2
3
4
5
6
7
8
9
saveAsXlsx() {
  const tableJson = [{'name': '名字'}] //要生成文件的json
  const wb: WorkBook = {SheetNames: [], Sheets: {}};
  const ws: any = utils.json_to_sheet(tableJson);
  wb.SheetNames.push('SheetNames');
  wb.Sheets['SheetNames'] = ws;
  const wbout = write(wb, {bookType: 'xlsx', bookSST: true, type: 'binary'});
  saveAs(new Blob([this.s2ab(wbout)], {type: 'application/octet-stream'}), '文件名.xlsx');
  }