vue3导出Excel表

1.下载xlsx包

npm i xlsx

2.导入xlsx包

import * as XLSX from "xlsx";

3.创建表格方法内容

functron exportExcel(){
    //设置表头
   const header = [
    "用户ID",
    "手机号",
    "岗位名称",
    "来源抖音号",
    "来源方式",
    "报名时间",
  ];
    //数据内容
  const data = tableData.value.map((item) => [
    item.userId,
    item.mobile,
    item.workName,
    item.uniqueId,
    selctType(item.type),
    item.createdDate,
  ]);
  let list: any = [];
  data.map((item) => {
    let obj: any = {};
    Object.keys(item).map((key: any) => {
      console.log(key);
      obj[header[key]] = item[key];
    });
    list.push(obj);
  });
    //创建表
  const wx = XLSX.utils.json_to_sheet(list, { header });
  // const wb = XLSX.utils.book_new();
    //设置表间距
  const wb: any = { SheetNames: ["Sheet1"], Sheets: {}, Props: {} };
  wx["!cols"] = [
    { wpx: 80 },
    { wpx: 100 },
    { wpx: 100 },
    { wpx: 100 },
    { wpx: 100 },
    { wpx: 150 },
  ];
  wb.Sheets["Sheet1"] = wx;
  for (let i = 2; i < list.length + 2; i++) {
    wb.Sheets["Sheet1"]["M" + i] = { t: "n", f: "J" + i + "+L" + i + "+K" + i };
    wb.Sheets["Sheet1"]["N" + i] = { t: "n", f: "F" + i + "*J" + i };
    wb.Sheets["Sheet1"]["O" + i] = { t: "n", f: "F" + i + "*L" + i };
  }
  XLSX.utils.book_append_sheet(wb, wx, "data");
  const time = new Date().getTime();
//下载表
  XLSX.writeFile(wb, time + ".xlsx");
}