使用poi3.9制作Excel模板，新手必看！！！

最新推荐文章于 2021-12-08 10:20:45 发布

码农之斜杠青年King

最新推荐文章于 2021-12-08 10:20:45 发布

阅读量426

点赞数

分类专栏： java 文章标签： maven java poi

本文链接：https://blog.csdn.net/weixin_45915206/article/details/120311204

版权

这篇博客详细介绍了如何使用maven和poi3.9来制作Excel模板，从导入jar包开始，逐步讲解Controller层和服务层的实现，最后展示运行结果。通过访问指定URL，可以看到实际的下载效果。

摘要由CSDN通过智能技术生成

1.导入jar包，这里使用maven

<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi-ooxml</artifactId>
    <version>3.9</version>
</dependency>

2.Controller层

@RequestMapping("/dowload")
public class DowloadFileController {

    private DownloadService downloadService;

    @Autowired
    public DowloadFileController(DownloadService downloadService) {
        this.downloadService = downloadService;
    }




    @GetMapping("/download")
    public void download(HttpServletResponse httpServletResponse, HttpServletRequest httpServletRequest) {
        OutputStream outputStream = null;
        try {
            String fileName = "模板.xlsx";
            if (httpServletRequest.getHeader("User-Agent").toUpperCase().indexOf("MSIE") > 0) {
                fileName = URLEncoder.encode(fileName, "UTF-8"); // IE浏览器
            } else {
                fileName = new String(fileName.getBytes("UTF-8"),"ISO8859-1");
            }
            httpServletResponse.reset();
            httpServletResponse.setContentType("application/octet-stream");
            httpServletResponse.setHeader("Content-Disposition","attachment;filename=\""+ fileName + "\"");
            httpServletResponse.setHeader("Connection", "close");
            outputStream = httpServletResponse.getOutputStream();
            downloadService.download(outputStrea