生成xlsx

<html lang="zh">

<head>
  <script src="https://cdn.bootcdn.net/ajax/libs/jquery/3.6.3/jquery.min.js"></script>
  <script src="https://cdn.bootcdn.net/ajax/libs/xlsx/0.18.5/xlsx.full.min.js"></script>
</head>
<input id="test_button" type="button" value="导出表格"></input>
</body>
<script>
  function exportXlsx(data) {
    const book = XLSX.utils.book_new();
    const sheet = XLSX.utils.json_to_sheet(data);
    XLSX.utils.book_append_sheet(book, sheet);
    XLSX.writeFile(book, 'test.xlsx');
  }
  let datas2 = [].map(e => {
    let departmentName2 =
      (
        orgList.filter(ele => {
          return e.department == ele.id
        }).length ? orgList.filter(ele => {
          return e.department == ele.id
        })[0].name : ''
      ) +
      (
        (e.departmentids && e.departmentids.includes('%%')) ?
        `/${e.departmentids.split('%%')[1]}` : ''
      );
    return {
      offer人员: e.name,
      应聘职位: e.positionName,
      应聘组: departmentName2,
      负责HR: e.traceHrName,
    }
  })

  $('#test_button').click(() => {
    exportXlsx(datas2);
  });
</script>

</html>
生成xlsx

推荐阅读更多精彩内容
