基础数据模板.xlsx下载

红烧牛肉排骨饭

于 2022-11-24 14:42:43 发布

阅读量56

点赞数

文章标签： java 服务器 servlet

本文链接：https://blog.csdn.net/weixin_43762113/article/details/128018269

版权

@ApiOperation(value = "模板下载")
@PostMapping("/download")
public void download(HttpServletResponse res) {
    String filePath = "./template/基础数据模板.xlsx"; //模板文件存放路径
    try (OutputStream os = res.getOutputStream();
         InputStream bis = new BufferedInputStream(new ClassPathResource(filePath).getStream())) {
        String type = new MimetypesFileTypeMap().getContentType("基础数据模板.xlsx");
        res.setContentType(type);
        String name = URLEncoder.encode("goods.xlsx", "UTF-8");
        res.setHeader("Content-Disposition", "attachment;filename=" + name);
        download(os, bis); //业务层方法
    } catch (Exception e) {
        e.printStackTrace();
    }
}

public void download(OutputStream outputStream, InputStream inputStream) {
    try {
        XSSFWorkbook workbook = new XSSFWorkbook(inputStream);
        workbook.write(outputStream);
    } catch (Exception e) {
        e.printStackTrace();
    }
}