使用js-export-excel导出数据为excel文件

啃火龙果的兔子

于 2023-11-27 15:16:43 发布

阅读量357

点赞数

分类专栏：开发DEMO vue3.2 vue2.0 文章标签：前端 javascript vue.js

本文链接：https://blog.csdn.net/qq_43592064/article/details/134646169

版权

开发DEMO 同时被 3 个专栏收录

144 篇文章 1 订阅

订阅专栏

28 篇文章 0 订阅

订阅专栏

23 篇文章 1 订阅

订阅专栏

import ExportJsonExcel from "js-export-excel";
const sureExport = (option) => {
  let toExcel = new ExportJsonExcel(option);
  toExcel.saveExcel();
}
const exportExcel1 = (exportDataList: any) => {
  const option: any = {};
  const dataList = exportDataList;
  let dataTable = []; //   dataTable代表excel文件中的数据内容
  if (dataList) {
    for (let i in dataList) {
      let obj = {
        "开始充电时间": dataList[i].startTime,
        "手机号": dataList[i].phoneNumber,
        "订单编号": dataList[i].cmsOrderId,
        "订单状态": dataList[i].status,
        "充电金额": dataList[i].totalFee,
        "充电度数": dataList[i].totalPower,
        "车型": dataList[i].vehicleType,
        "启动方式": dataList[i].startModeName,
        "创建时间": dataList[i].created,
        "充电停止原因": dataList[i].stopReason,
        "运营商": dataList[i].cpoName,
        "充电站类型": dataList[i].stationTypeName,
        "支付方式": dataList[i].paymentMethod,
        "开票状态": dataList[i].invoiceStatus,
        "Vin": dataList[i].vin,
        "用户编号": dataList[i].partnerId,
        "充电站编号": dataList[i].stationId,
        "充电站名称": dataList[i].stationName,
        "省": dataList[i].province,
        "市": dataList[i].city,
        "充电终端类型": dataList[i].equipmentTypeName,
        "充电终端编号": dataList[i].connectorId,
        "充电终端功率": dataList[i].power,
        "充电站评级": dataList[i].stationScore,
        "位置属性": dataList[i].locationAttributionName
      };
      dataTable.push(obj); //   设置excel每列获取的数据源
    }
  }

  const time = moment().format('YYYYMMDDHHmmss');
  option.fileName = `订单_${time}`;
  option.datas = [
    {
      sheetData: dataTable,
      // sheetName: "sheet",
      sheetHeader: ["开始充电时间","手机号", "订单编号","订单状态","充电金额","充电度数","车型","启动方式","创建时间","充电停止原因","运营商","充电站类型","支付方式","开票状态","Vin","用户编号","充电站编号","充电站名称","省","市","充电终端类型","充电终端编号","充电终端功率","充电站评级","位置属性"],
      sheetFilter: ["开始充电时间","手机号", "订单编号","订单状态","充电金额","充电度数","车型","启动方式","创建时间","充电停止原因","运营商","充电站类型","支付方式","开票状态","Vin","用户编号","充电站编号","充电站名称","省","市","充电终端类型","充电终端编号","充电终端功率","充电站评级","位置属性"],
      // columnWidths:['10','10','20']//excel列宽度设置
    },
  ];
  sureExport(option);
}