js-export-excel 前端导出excel模板
1.下载
npm install js-export-excel
2.使用
/*** * 前端生成excel 表格(基于 js-export-excel 插件的二次封装)* fileName:excel文件名* sheetData: 第一行的实例数据* sheetFilter: 和 sheetData 一一对应* sheetHeader:表头* option.datas: 一个对象表示一个表格* columnWidths: 列宽* * ***/export const downLoadExcelMode = (fileName,sheetData,sheetFilter,sheetHeader,sheetName="sheet") =>{var option={};option.fileName = fileNameoption.datas=[{sheetData:sheetData,sheetName:sheetName,sheetFilter:sheetFilter,sheetHeader:sheetHeader,columnWidths: ['8','4'],},];const ExportJsonExcel = require("js-export-excel");var toExcel=new ExportJsonExcel(option);toExcel.saveExcel();}
downLoadFoodModel() {// 菜品模板下载let fileName = 'foodModel' let sheetData = [{one:'铁锅炖',two:'点餐供应',three:'套餐',four:'2.5',five:'10',six:'是',seven:'50',eight:'主食',nine:'个'}]let sheetFilter = ['one','two','three','four','five','six','seven','eight','nine'] let sheetHeader = ['菜品名称','适用服务','适用餐种','出售价格','限购额度','能否打包','上架数量','菜品类','菜品描述单位']let nowtime = new Date()let sheetName = `${nowtime.getFullYear()}-${nowtime.getMonth()+1}-${nowtime.getDate()}` console.log(sheetName)this.$utils.downLoadExcelMode(fileName,sheetData,sheetFilter,sheetHeader,sheetName)},