1、在angular应用程序中按照 xlsx file-saver npm install xlsx --save //当前使用的版本 0.13.3 //编写angular - service代码 import {Injectable} from '@angular/core'; import * as XLSX from 'xlsx'; @Injectable() export class SheetService { constructor() { } public jsontToSheet(json: any[], filename: string): void { //gengerate worksheet const worksheet: XLSX.WorkSheet = XLSX.utils.json_to_sheet(json); //generate workbook and worhsheet const workbook: XLSX.WorkBook = XLSX.utils.book_new(); XLSX.utils.book_append_sheet(workbook, worksheet, 'Sheet1'); //save file XLSX.writeFile(workbook, filename); } } //使用 class SheetJS { constructor(private sheetService: SheetService) { } private export() { let json = [{id: '1', name: '11'}, {id: '2', name: '22'}, {id: '3', name: '33'},]; this.sheetService.jsontToSheet(json, 'test'); } } 详情https://docs.sheetjs.com/#sheetjs-js-xlsx xlsx
angular时间json导出为excel,使用xsls
最新推荐文章于 2024-07-24 17:11:47 发布