import {Injectable} from '@angular/core'; import {Headers, Http} from '@angular/http'; import * as XLSX from 'xlsx'; import * as FileSaver from 'file-saver'; @Injectable() export class FileService { constructor(private http: Http) { } multiDownLoadExl(dataAll, merges, sheetNames) { console.log(merges); const wb: XLSX.WorkBook = {SheetNames: sheetNames, Sheets: {}, Props: {}}; const toSet = XLSX.utils.json_to_sheet(dataAll, {skipHeader: true}); wb.Sheets[sheetNames[0]] = toSet; // 通过json_to_sheet转成单页(Sheet)数据 const wsname: string = wb.SheetNames[0]; const ws: XLSX.WorkSheet = wb.Sheets[wsname]; // ws['!cols'] = colProp[item]; // 单元格宽度 // ws['!rows'] = rowProp[item]; // 列高 ws['!merges'] = merges; // 合并单元格 let fileName = 'excel导出.xlsx'; this.saveAs( new Blob([th
Angular下用js-xlsx和file-saver组合导出excel(适配IE浏览器)
最新推荐文章于 2024-08-10 13:02:01 发布
本文介绍如何在Angular应用中利用js-xlsx库处理Excel数据,并结合file-saver实现文件下载,特别讨论了兼容IE浏览器的策略和关键步骤。
摘要由CSDN通过智能技术生成