大家好我是小逗号,今天给大家带来一期前端下载excel表格的教程
一、包名
这个包名叫做 # js-export-excel
npm链接 www.npmjs.com/package/js-…
二、下载方式
我们可以通过npm或者yarn下载,我现在运用的框架是 vue2。
npm install js-export-excel
or
yarn add js-export-excel
三、引入
const ExportJsonExcel = require("js-export-excel");
四、代码逻辑
var option = {};
option.fileName = "excel"; // 文件名字
option.datas = [{
sheetData: this.Arrays, // 数组数据
sheetName: "待派单订单", // 表格名字
sheetFilter: [ // 属性名
"thirteen",
"twelve",
"eleven",
"ten",
"nine",
"eight",
"seven",
"six",
"five",
"four",
"three",
"two",
"one",
"fourteen",
"fifteen",
"sixteen",
],
sheetHeader: [
"订单编号",
"服务类型",
"服务名称",
"车辆信息",
"预约人姓名",
"预约人电话",
"留言备注",
"上门时间",
"订单地址",
"订单金额",
"下单时间",
"下单账号",
"支付方式",
"退款原因",
"订单状态",
"上门小哥",],
columnWidths: [15, 5, 5, 15, 5, 5, 10, 5, 5, 5, 10, 14, 5, 10, 5, 5], // 列宽
},];
var toExcel = new ExportJsonExcel(option); //new
toExcel.saveExcel(); //保存