使用js-export-excel插件实现前端导出excel表格

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 = fileName
  option.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)
      },