前端用js导出默认Excel格式 代码

/**  
     * service层
     * 导出  下面两个请求响应必须 引入就行
     * @param request
     * @param response
     * @param content  参数
     * @throws IOException
     */
public void download(HttpServletRequest request, HttpServletResponse response, List<ResponseReceiptAmount> content) throws IOException {

        //创建excel表头
        List<String> column = new ArrayList<>();
        column.add("日期");
        column.add("销售员");
        column.add("来源渠道");
        column.add("客户对接群");
        column.add("客户名称");
        column.add("项目编号");
        column.add("国家");
        column.add("上包品类");
        column.add("收款类型");
        column.add("实收款RMB");
        column.add("U汇率");
        column.add("应收U");
        column.add("实收U");
        column.add("我收款钱包");
        column.add("收/付款Hash");
        column.add("备注");

        //表头对应的数据
        List<Map<String,Object>> data = new ArrayList<>();

        //遍历获取到的需要导出的数据，k要和表头一样
        for (ResponseReceiptAmount responseReceiptAmount : content) {
            LinkedHashMap<String, Object> map = new LinkedHashMap<>();
            map.put("日期", responseReceiptAmount.getReceiptDate());
            map.put("销售员", responseReceiptAmount.getReceiptSales());
            map.put("来源渠道", responseReceiptAmount.getSource());
            map.put("客户对接群", responseReceiptAmount.getTgGroup());
            map.put("客户名称", responseReceiptAmount.getCustomerName());
            map.put("项目编号", responseReceiptAmount.getPlanName());
            map.put("国家", responseReceiptAmount.getCountry());
            map.put("上包品类", responseReceiptAmount.getProjectType());
            map.put("收款类型", responseReceiptAmount.getReceiptType()=="1" ? "人民币" : "U");
            map.put("实收款RMB", responseReceiptAmount.getReceivableAmount());
            map.put("U汇率", responseReceiptAmount.getRate());
            map.put("应收U", responseReceiptAmount.getPaidInUsdt());
            map.put("实收U", responseReceiptAmount.getReceivableUsdt());
            map.put("我收款钱包", responseReceiptAmount.getAmountPackage());
            map.put("收/付款Hash", responseReceiptAmount.getReceiptHash());
            map.put("备注", responseReceiptAmount.getRemark());
            data.add(map);
        }

        //调用导出工具类
        FileUtil.exportExcel("工作人员表",column,data,request,response);

    }

/**
         * @param sheetName 工作表的名字
         * @param column  列名
         * @param data  需要导出的数据    ( map的键定义为列的名字 一定要和column中的列明保持一致  )
         * @param response
         */
        public static void exportExcel(String sheetName,List<String> column,List<Map<String,Object>> data,HttpServletRequest request,HttpServletResponse response){
            //创建工作薄
            HSSFWorkbook hssfWorkbook = new HSSFWorkbook();
            //创建sheet
            HSSFSheet sheet = hssfWorkbook.createSheet(sheetName);
            // 表头
            HSSFRow headRow = sheet.createRow(0);
            for (int i = 0; i < column.size(); i++){
                headRow.createCell(i).setCellValue(column.get(i));
            }

            for (int i = 0; i < data.size(); i++) {
                HSSFRow dataRow = sheet.createRow(sheet.getLastRowNum() + 1);
                for (int x = 0; x < column.size(); x++) {
                    dataRow.createCell(x).setCellValue(data.get(i).get(column.get(x))==null?"":data.get(i).get(column.get(x)).toString());
                }
            }

            response.setContentType("application/vnd.ms-excel");

            try {
                //获取浏览器名称
                String agent=request.getHeader("user-agent");
                String filename=sheetName+".xls";
                //不同浏览器需要对文件名做特殊处理
                if (agent.contains("Firefox")) { // 火狐浏览器
                    filename = "=?UTF-8?B?"
                            + new BASE64Encoder().encode(filename.getBytes("utf-8"))
                            + "?=";
                    filename = filename.replaceAll("\r\n", "");
                } else { // IE及其他浏览器
                    filename = URLEncoder.encode(filename, "utf-8");
                    filename = filename.replace("+"," ");
                }
                //推送浏览器
                response.setHeader("Content-Disposition","attachment;filename="+filename);
                hssfWorkbook.write(response.getOutputStream());
            } catch (Exception e) {
                e.printStackTrace();
            }
        }

handleExport() {
      console.log("进入方法");
      console.log(this.Query)
      const data = Object.assign({}, this.Query, {
        page: this.Query.page - 1,
        limit: this.Query.limit = 10000
      })
      
      const  xhr = new XMLHttpRequest();
      xhr.open("POST","api/receiptAmount/download");//路径
      xhr.setRequestHeader('Content-type', 'application/json')// 类型
      xhr.setRequestHeader("Authorization",getToken())// 获取token
      xhr.send(JSON.stringify(data));//传参
      xhr.responseType = 'blob'; //设置请求回来的数据为blob方式
      xhr.onreadystatechange = function() {
        if (xhr.readyState == 4 && xhr.status == 200) {
          // 数据在 this.response 保存
          // excel 的 MIME 格式为 application/vnd.ms-excel
          var blob = new Blob([xhr.response], {
            type: "application/vnd.ms-excel"
          });
          var url = window.URL.createObjectURL(blob);
          let a = document.createElement("a");
          a.href = url
          a.download = '收款.xlsx';//文件名称
          a.click();
        }
      }
    },