excel 导出

function downLoadExcel() {


    var url = prefix + '/downloadExcel';
    var args = {
        startTime: layDateTime($('#tm').val())[0],
        endTime: layDateTime($('#tm').val())[1],
        stcd: $('#stnm').val(),
    };
    var params = Object.keys(args).map(function (key) {
        return encodeURIComponent(key) + "=" + encodeURIComponent(args[key]);
    }).join("&");
    window.location.href = url + "?" + params;


}

@GetMapping("/downloadExcel")
	public void downloadExcel(@RequestParam Map<String, Object> params, HttpServletResponse response) {

		List<RiverDZVO> RiverDZGCXs = stRiverRSbService.getRiverDZGCXs(params);

		Workbook workbook = ExcelExportUtil.exportExcel(new ExportParams("河道单站过程线—数据报表","河道单站过程线—数据报表"),
				RiverDZVO .class, RiverDZGCXs);

		try {
			response.setCharacterEncoding("UTF-8");
			response.setHeader("content-Type", "application/vnd.ms-excel");
			response.setHeader("Content-Disposition",
					"attachment;filename=" + URLEncoder.encode("河道单站过程线—数据报表.xlsx", "UTF-8"));
			workbook.write(response.getOutputStream());
		} catch (IOException e) {
			throw new RuntimeException(e);
		}


	}

 public static void downloadExcel(Class c, List list, String titel , String sheetName, HttpServletResponse response) {


        Workbook workbook = ExcelExportUtil.exportExcel(new ExportParams(titel,sheetName),
                c, list);

        try {
            response.setCharacterEncoding("UTF-8");
            response.setHeader("content-Type", "application/vnd.ms-excel");
            response.setHeader("Content-Disposition",
                    "attachment;filename=" + URLEncoder.encode(titel+".xlsx", "UTF-8"));
            workbook.write(response.getOutputStream());
        } catch (IOException e) {
            throw new RuntimeException(e);
        }
    }

easyExcel导出

@ResponseBody
    @GetMapping("/uploadExcel")
    //@RequiresPermissions("charsming:bordingShip:bordingShip")
    public void uploadExcel(@RequestParam Map<String, Object> params, HttpServletResponse response) {
        String name = "人员登记信息表" + DateUtil.today() + IdUtil.simpleUUID();
        //防止中文件名,在浏览器消失
        String fileName = new String(name.getBytes(), StandardCharsets.ISO_8859_1);
        response.setContentType("application/vnd.ms-excel");
        response.setCharacterEncoding("utf8");
        response.setHeader("Content-disposition", "attachment;filename=" + fileName+ ".xlsx" );
        List<BordingShipDO> bordingShipList = bordingShipService.list(params);

        try {
            EasyExcel.write(response.getOutputStream(), BordingShipDO.class).sheet("人员登记信息表").doWrite(bordingShipList);
        } catch (IOException e) {
            e.printStackTrace();
        }

    }