SpringBoot整合poi实现Word文件的导出

SpringBoot整合poi实现Word文件的导出

1、引入Maven依赖

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

2、封装WordUtils工具类

import com.hikvision.treasury.cache.FilePathCache;
import lombok.extern.slf4j.Slf4j;
import org.apache.poi.hwpf.HWPFDocument;
import org.apache.poi.hwpf.usermodel.Range;
import org.apache.poi.hwpf.usermodel.Table;
import org.apache.poi.hwpf.usermodel.TableIterator;
import org.apache.poi.hwpf.usermodel.TableRow;
import org.apache.poi.xwpf.usermodel.*;
import org.apache.xmlbeans.XmlException;
import org.apache.xmlbeans.XmlOptions;
import org.openxmlformats.schemas.wordprocessingml.x2006.main.CTBody;
import org.springframework.core.io.ClassPathResource;
import java.io.*;
import java.util.Iterator;
import java.util.List;
import java.util.Map;
import java.util.regex.Matcher;
import java.util.regex.Pattern;
import javax.servlet.http.HttpServletResponse;
import java.util.ArrayList;

/**
 * @ClassName WordUtils
 * @Description TODO
 * @Author 
 * @Date 2020/11/20 14:43
 * @Version 1.0
 */
@Slf4j
public class WordUtils {
   
    /**
     * docx文档导出工具类
     * @param params 要替换段落的参数
     * @param templatePath docx模板文档路径
     * @param listData 动态插入word表格中的数据
     */
    public static void wordXUtils(Map<String, Object> params, String templatePath, ArrayList<Map<String, String>> listData) {
   
        try {
   
            //String filePath = "E:\\text.docx";
            ClassPathResource fileResource = new ClassPathResource("file/templateFile/非库管人员入库登记簿.docx");
            //InputStream is = new FileInputStream(templatePath);
            InputStream is = fileResource.getInputStream();
            XWPFDocument doc = new XWPFDocument(is);
            //对两个docx文件进行合并
            //XWPFDocument doc = mergeWord(docx, docx);
            //替换段落里面的变量
            replaceInPara(doc, params);
            //替换表格里面的变量
            //replaceInTable(doc, params);
            //动态的向表格里写入数据
            insertInTable(doc, listData);
            //word 强制分页的两种方式
            //doc.createParagraph().setPageBreak(true);
            //推荐使用该方式实现分页
            //doc.createParagraph().createRun().addBreak(BreakType.PAGE);
            //String tempFile1 = "D:\\\\我的项目\\\\安徽研发中心\\\\阜阳人行金库合规化改造项目\\\\"+ Math.random() +".docx";
            //设定为当前文件夹
            File directory = new File("");
            //获取标准的路径
            //System.out.println(directory.getCanonicalPath());
            //获取绝对路径
            //System.out.println(directory.getAbsolutePath());
            String tempFile = directory.getAbsolutePath()+"\\"+ Math.random() +".docx";
            log.info("获取临时文件存储的路径：" + tempFile);
            FilePathCache.tempPath.add(tempFile);
            OutputStream os = new FileOutputStream(tempFile);
            doc.write(os);
            close(os);
            close(is);
        } catch (IOException e) {
   
            e.printStackTrace();
        }
    }

    /**
     * 两个对象进行追加
     * @param document 文档1
     * @param doucDocument2 文档2
     * @return 合并后的文档
     * @throws Exception
     */
    public static XWPFDocument mergeWord(XWPFDocument document, XWPFDocument doucDocument2) {
   
        XWPFDocument src1Document = document;
        //XWPFParagraph p = src1Document.createParagraph();
        //设置分页符
        //p.setPageBreak(true);
        //p.createRun().addBreak(BreakType.PAGE);
        CTBody src1Body = src1Document.getDocument().getBody();
       XWPFDocument src2Document = doucDocument2;
        CTBody src2Body = src2Document.getDocument().getBody();
        //XWPFParagraph p2 = src2Document.createParagraph();
        XmlOptions optionsOuter = new XmlOptions();
        optionsOuter.setSaveOuter();
        String appendString = src2Body.xmlText(optionsOuter);
        String srcString = src1Body.xmlText();
        String prefix = srcString.substring(0, srcString.indexOf(">") + 1);
        String mainPart = srcString.substring(srcString.indexOf(">") + 1, srcString.lastIndexOf("<"));
        String sufix = srcString.substring(srcString.lastIndexOf("<"));
        String addPart = appendString.substring(appendString.indexOf(">") + 1, appendString.lastIndexOf("<"));
        CTBody makeBody = null;