导出的相关方法

onlyusc2

已于 2022-03-06 12:26:05 修改

阅读量188

点赞数

分类专栏： JAVA 文章标签： java 后端

于 2022-03-05 21:00:48 首次发布

本文链接：https://blog.csdn.net/onlyusc2/article/details/123299802

版权

JAVA 专栏收录该内容

10 篇文章 0 订阅

订阅专栏

该博客介绍了如何使用Apache POI库在Java中导出Word文档。通过添加依赖，设置模板，填充数据并调整字体样式，实现了从模板生成包含特定内容的Word文件。主要涉及的技术包括XWPFTemplate、XWPFDocument和XWPFParagraph等。

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

导出成word文档

准备好jar包

<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi</artifactId>
    <version>3.17</version>
</dependency>
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi-ooxml</artifactId>
    <version>3.17</version>
</dependency>
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi-ooxml-schemas</artifactId>
    <version>3.17</version>
</dependency>
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>ooxml-schemas</artifactId>
    <version>1.1</version>
</dependency>
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi-scratchpad</artifactId>
    <version>3.17</version>
</dependency>
<dependency>
    <groupId>com.deepoove</groupId>
    <artifactId>poi-tl</artifactId>
    <version>1.3.1</version>
</dependency>

public class WordUtil {

    private Logger logger = LoggerFactory.getLogger(WordUtil.class);

    public static String exportToWordUtil(HttpServletResponse response, String fileName, String templateName, Map<String, Object> dataMap) {
        OutputStream out = null;
        XWPFTemplate template = null;
        try {
            response.reset();
            response.setContentType("application/vnd.ms-excel;charset=UTF-8");
            response.setHeader("Content-Disposition", "attachment;filename=" + URLEncoder.encode(fileName, "UTF-8"));
            //这里的ExcelUtil.class应该只是提供一个class对象吧？然后才能调用getResourceAsStream方法
            InputStream is = Object.class.getResourceAsStream("/template/" + templateName);
            //这一步应该是把准备好的map内容，转成XWPFTemplate对象
            template = XWPFTemplate.compile(is).render(dataMap);
            XWPFDocument xwpfDocument = template.getXWPFDocument();
            List<XWPFTable> tables = xwpfDocument.getTables();
            //设置字体和大小
            List<XWPFParagraph> paragraphs = getTableParagraphs(xwpfDocument, tables.get(0));
            //1.取得某一个表格的全部段落
            for (XWPFParagraph paragraph : paragraphs) {
                //获取XWPFRun
                XWPFRun xwpfRun = getOrAddParagraphFirstRun(paragraph, false, false);
                //设置字体大小内容
                String font = "仿宋";
                String fontSize = "22";
                setParagraphRunFontInfo(paragraph, xwpfRun, null, font, fontSize);
            }
            out = response.getOutputStream();
            template.write(out);
        } catch (Exception e) {

        } finally {
            try {
                if (out != null) {
                    out.close();
                }
            } catch (IOException e) {

            }
            try {
                if (template != null) {
                    template.close();
                }
            } catch (IOException e) {

            }
        }
        return null;
    }


    //取得某一个表格的全部段落
    public static List<XWPFParagraph> getTableParagraphs(XWPFDocument document, XWPFTable table) {
        List<XWPFParagraph> paragraphs = new ArrayList<>();
        //列表内段落
        List<XWPFTableRow> rows = table.getRows();
        for (XWPFTableRow row : rows) {
            List<XWPFTableCell> cells = row.getTableCells();
            for (XWPFTableCell cell : cells) {
                paragraphs.addAll(cell.getParagraphs());
            }
        }
        return paragraphs;
    }

    private static XWPFRun getOrAddParagraphFirstRun(XWPFParagraph p, boolean isInsert, boolean isNewLine) {
        XWPFRun pRun = null;
        if (isInsert) {
            pRun = p.createRun();
        } else {
            if (p.getRuns() != null && p.getRuns().size() > 0) {
                pRun = p.getRuns().get(0);
            }
        }
        if (isNewLine) {
            pRun.addBreak();
        }
        return pRun;
    }

    private static void setParagraphRunFontInfo(XWPFParagraph p, XWPFRun pRun, String content, String fontFamily, String fontSize) {
        CTRPr pRpr = getRunCTRPr(p, pRun);
        if (StringUtils.isNoneBlank(content)) {
            pRun.setText(content);
        }
        //设置字体
        CTFonts fonts = pRpr.isSetRFonts() ? (CTFonts) pRpr.getRFonts() : pRpr.addNewRFonts();
        fonts.setAscii(fontFamily);
        fonts.setEastAsia(fontFamily);
        fonts.setHAnsi(fontFamily);

        //设置字体大小
        CTHpsMeasure sz = pRpr.isSetSz() ? pRpr.getSz() : pRpr.addNewSz();
        sz.setVal(new BigInteger(fontSize));

        CTHpsMeasure szCs = pRpr.isSetSzCs() ? pRpr.getSzCs() : pRpr.addNewSzCs();
        szCs.setVal(new BigInteger(fontSize));
    }

    private static CTRPr getRunCTRPr(XWPFParagraph p, XWPFRun pRun) {
        CTRPr pRpr = null;
        if (pRun.getCTR() != null) {
            pRpr = pRun.getCTR().getRPr();
            if (pRpr == null) {
                pRpr = pRun.getCTR().addNewRPr();
            }
        } else {
            pRpr = p.getCTP().addNewR().addNewRPr();
        }
        return pRpr;
    }

}