POI 实现读取项目中的模板文件并往模板文件中写数据

墨蓝 2023-01-21 04:26 98阅读 0赞

### 1 maven依赖 ###

<dependency>
                <groupId>com.alibaba</groupId>
                <artifactId>easyexcel</artifactId>
                <version>2.2.7</version>
            </dependency>

### 2 读取项目中的模板文件 ###

/**
         *  获取项目中文件，不存在返回null
         * @param fileName 文件路径（相对路径）
         * @return
         */
        public static InputStream getServiceFile(String fileName){
            try {
                ClassPathResource classPathResource = new ClassPathResource(fileName);
                return classPathResource.getInputStream();
            }catch (Exception e){
                e.printStackTrace();
                return null;
            }
        }

### 3 **调试代码** ###

/**
         * 读取项目模板文件
         *
         * @param response
         */  
      @GetMapping("/readServiceTemplate")
        public void readServiceTemplate(HttpServletResponse response) {
            try {
                //读文件//读文件
                InputStream inputStream = getServiceFile("/doc/模板.docx");
                XWPFDocument document = inputStream == null ? new XWPFDocument() : new XWPFDocument(inputStream);
    
                //写数据
                XWPFParagraph titleParagraph = document.createParagraph();
                ((XWPFParagraph) titleParagraph).setAlignment(ParagraphAlignment.CENTER);
                titleParagraph.createRun().setText("测试数据");
    
                //返回流
                response.setHeader("content-type", "application/octet-stream");
                response.setContentType("application/octet-stream;charset=UTF-8");
                response.setHeader("Content-Disposition", "attachment; filename=" + new String("模板.docx".getBytes("utf-8"), "ISO-8859-1"));
                OutputStream outputStream = response.getOutputStream();
                document.write(outputStream);
                outputStream.flush();
                outputStream.close();
            } catch (Exception e) {
                e.printStackTrace();
            }
    
        }

### 4 模板文件 ###

模板文件地址：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4OTc0NjM4_size_16_color_FFFFFF_t_70][]

模板文件内容：

![20210514142854498.png][]

### 5 调试结果 ###

![20210514143212643.png][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4OTc0NjM4_size_16_color_FFFFFF_t_70]: /images/20221021/52dedd826115453c81a5fa9daeebdc25.png
[20210514142854498.png]: /images/20221021/68946679f4d34346827c00eca022fb3a.png
[20210514143212643.png]: /images/20221021/a6abe62db6f94dc59b119dc33ae2c309.png