springboot内置下载模版

需求

1、springboot项目,在项目中放置一个模版EXCEL,然后通过连接下载下来

 

@Log("供应商-下载导入模板")
    @ApiOperation(value = "供应商-下载导入模板", response = String.class)
    @GetMapping(value = "/downloadSupplierTemplate")
    @AnonymousAccess
    public void supplierTemplate(HttpServletResponse response) throws Exception {
        supplierService.downloadSupplierTemplate(response);
    }
/**
     * 供应商-下载导入模板
     *
     * @param response
     * @return
     */
    void downloadSupplierTemplate(HttpServletResponse response) throws Exception;

  

    @Override
    public void downloadSupplierTemplate(HttpServletResponse response) throws Exception {
        DateTimeFormatter format = DateTimeFormatter.ofPattern("yMMddHHmmss");
        LocalDateTime dataTime = LocalDateTime.now();
        //格式化,不能用Date类的实例作为参数
        String dateTimeStr = format.format(dataTime);
        System.out.println(dateTimeStr);
        String fileName = "催收供应商导入" + dateTimeStr + ".xlsx";
        try {
            fileName = URLEncoder.encode(fileName, "UTF-8");
        } catch (UnsupportedEncodingException e) {
            e.printStackTrace();
        }
        String fileSuffix = "template/supplier/supplier_settlement.xlsx";
        InputStream inputStream = getClass().getClassLoader().getResourceAsStream(fileSuffix);
        XSSFWorkbook workbook = new XSSFWorkbook(inputStream);
        // 设置输出的格式
        response.setHeader("Content-disposition", "attachment;filename=" + fileName + ";" + "filename*=utf-8''" + fileName);
        response.addHeader("Access-Control-Expose-Headers", "Content-Disposition");
        response.setContentType("application/vnd.ms-excel;charset=UTF-8");
        workbook.write(response.getOutputStream());
        workbook.close();
    }

  

 

posted @ 2021-04-25 14:46  花语苑  阅读(713)  评论(1编辑  收藏  举报