@PostMapping("/download")
    public R downLoad(@RequestBody FyGroupProjectItemUserDTO itemUserList, HttpServletResponse response) {

        try {
            //命名列名
            List<String> cellNameList = new ArrayList<>();
            cellNameList.add("id");
            cellNameList.add("名字");
            cellNameList.add("當(dāng)日報數(shù)");
            cellNameList.add("累計報數(shù)");

            //給文件命名

            SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyyMMdd");
            String dateformat = simpleDateFormat.format(new Date());
            String excelPath = "報數(shù)記錄" + dateformat + ".xls";
            //給表命名
            String title = "報數(shù)記錄";
            HSSFWorkbook excel = Excel.createExcel(title, cellNameList);
            int row = 1;
            //從數(shù)據(jù)庫讀數(shù)據(jù)然后循環(huán)寫入
            List<FyGroupProjectItemUser> itemUserListList = itemUserList.getList();
            for (FyGroupProjectItemUser itemUser : itemUserListList) {
                List<String> excelData = new ArrayList<>();
                excelData.add(itemUser.getId().toString());
                excelData.add(itemUser.getName().toString());
                excelData.add(itemUser.getCount().toString());
                excelData.add(itemUser.getNewCount().toString());
                excel = Excel.createExcelData(excel, excelData, row);
                row++;
            }
            //輸出數(shù)據(jù)
            //FileOutputStream fos = new FileOutputStream(excelPath);
            OutputStream out = null;
            //防止中文亂碼
            String headStr = "attachment; filename=\"" + new String(excelPath.getBytes("utf-8"), "ISO8859-1") + "\"";
            //response.setContentType("octets/stream");
            response.setContentType("application/octet-stream");
            response.setHeader("Content-Disposition", headStr);
            out = response.getOutputStream();
            //將excel寫入流
            excel.write(out);
            out.flush();
            out.close();
            System.out.println("寫出去了");
        } catch (Exception e) {
            e.printStackTrace();
        }
        return null;
    }

downLoadExcel() {
                wx.showLoading({
                    title: '加載中',
                })
                console.log("list",this.projectList)
                for (var i = 0; i < this.projectList.length; i++) {
                    this.projectList[i].newCount = this.projectList[i].totalNum  //這里我做下數(shù)據(jù)處理，可忽略
                }
                wx.request({
                    url: 'http://localhost:8886/count/export/download', //調(diào)用后臺接口的全路徑
                    data: {
                        list: this.projectList
                    },
                    method: "POST",
                    header: {
                        // 'Content-type': 'application/x-www-form-urlencoded',
                        'Content-type': 'application/json',  //這里指定的數(shù)據(jù)要和后端對應(yīng)
                        // 'Cookie': app.globalData.userInfo && app.globalData.userInfo.cookie ? app.globalData.userInfo.cookie : '',
                    },
                    responseType: 'arraybuffer', //此處是請求文件流，必須帶入的屬性
                    success: res => {
                        if (res.statusCode === 200) {
                            console.log("200")
                            const fs = wx.getFileSystemManager(); //獲取全局唯一的文件管理器
                            fs.writeFile({
                                // filePath: wx.env.USER_DATA_PATH + "/身體成分報告.pdf", // wx.env.USER_DATA_PATH 指定臨時文件存入的路徑，后面字符串自定義
                                filePath: wx.env.USER_DATA_PATH + "/test.xls", // wx.env.USER_DATA_PATH 指定臨時文件存入的路徑，后面字符串自定義
                                data: res.data,
                                encoding: "binary", //二進(jìn)制流文件必須是 binary
                                success(res) {
                                    console.log("success(res)",res)
                                    
                                    wx.openDocument({ // 打開文檔
                                        filePath: wx.env.USER_DATA_PATH + "/test.xls", //拿上面存入的文件路徑
                                        // showMenu: true, // 顯示右上角菜單
                                        success: function(res) {
                                            console.log("successfun",res)
                                            setTimeout(() => {
                                                wx.hideLoading()
                                            }, 500)
                                        },fail:function(res){
                                            console.log("failfun",res)
                                        }
                                    })
                                },
                                fail(res){
                                    console.log("fail",res)
                                }
                            })
                        }else{
                            console.log("不是200")
                        }
                        console.log("success",res)
                    },
                    fail:res =>{
                        console.log("fail",res)
                    }
                })
            },