栏目分类:
子分类:
返回
名师互学网用户登录
快速导航关闭
当前搜索
当前分类
子分类
实用工具
热门搜索
名师互学网 > IT > 软件开发 > 后端开发 > Java

java-poi实现生成word

Java 更新时间: 发布时间: IT归档 最新发布 模块sitemap 名妆网 法律咨询 聚返吧 英语巴士网 伯小乐 网商动力

java-poi实现生成word

1.maven导入依赖


            org.apache.poi
            poi-ooxml
            4.1.2
        
        
            org.apache.poi
            poi-ooxml-schemas
            4.1.2
        
        
            org.apache.poi
            poi
            4.1.2
        
        
            org.apache.poi
            poi-scratchpad
            4.1.2
        
        
            org.apache.commons
            commons-collections4
            4.4
        
        
            commons-codec
            commons-codec
            1.13
        
        
            org.apache.commons
            commons-compress
            1.19
        
        
            org.apache.xmlbeans
            xmlbeans
            3.1.0
        
        
            org.apache.poi
            ooxml-schemas
            1.4
        

2.工具类

package com.maxplus.analysis.utils;

import org.apache.commons.lang.StringUtils;
import org.apache.poi.openxml4j.exceptions.InvalidFormatException;
import org.apache.poi.util.Units;
import org.apache.poi.xddf.usermodel.chart.*;
import org.apache.poi.xwpf.usermodel.*;
import org.openxmlformats.schemas.drawingml.x2006.chart.CTDLbls;
import org.openxmlformats.schemas.drawingml.x2006.chart.CTPlotArea;
import org.openxmlformats.schemas.wordprocessingml.x2006.main.*;

import java.io.*;
import java.math.BigInteger;
import java.net.URL;
import java.util.List;


public class WordUtils {

    
    public void setXWPFParagraph(XWPFParagraph titleParagraph, ParagraphAlignment paragraphAlignment, String text,
                                 String color, int size) {
        //设置段落居中 ParagraphAlignment.CENTER
        titleParagraph.setAlignment(paragraphAlignment);
        //标题添加内容
        XWPFRun titleParagraphRun = titleParagraph.createRun();
        titleParagraphRun.setText(text);
        titleParagraphRun.setColor(color);
        titleParagraphRun.setFontSize(size);
    }

    
    public void setXWPFParagraph(XWPFParagraph paragraph, String text, String color, int size, int line) {
        //行
        XWPFRun run = paragraph.createRun();
        //paragraph1.setAlignment(ParagraphAlignment.CENTER); 居中
        //设置行间距
        paragraph.setSpacingAfter(line);
        paragraph.setSpacingBefore(line);
        //内容
        run.setText(text);
        //字体颜色
        run.setColor(color);
        //字体大小
        run.setFontSize(size);
    }


    
    public void setCTTblWidth(XWPFTable infoTable) {
        //列宽自动分割
        CTTblWidth infoTableWidth = infoTable.getCTTbl().addNewTblPr().addNewTblW();
        infoTableWidth.setType(STTblWidth.DXA);
        infoTableWidth.setW(BigInteger.valueOf(9072));

    }


    
    public void setXWPFTableCell(List tableName, int cell, String text, String color, boolean center) {
        tableName.get(cell).setText(text); //为第0行第0列设置内容
        if (StringUtils.isNotBlank(color)) {
            tableName.get(cell).setColor(color);//设置颜色
        }
        if (center) {
            centerTable(tableName.get(cell));//设置居中
        }
    }

    
    public void centerTable(XWPFTableCell cell) {
        CTTc cttc = cell.getCTTc();
        CTP ctp = cttc.getPList().get(0);
        CTPPr ctppr = ctp.getPPr();
        if (ctppr == null) {
            ctppr = ctp.addNewPPr();
        }
        CTJc ctjc = ctppr.getJc();
        if (ctjc == null) {
            ctjc = ctppr.addNewJc();
        }
        ctjc.setVal(STJc.CENTER); //水平居中
    }
    
    public void mergeVertically(XWPFTable table, int col, int fromRow, int toRow) {
        for (int rowIndex = fromRow; rowIndex <= toRow; rowIndex++) {
            XWPFTableCell cell = table.getRow(rowIndex).getCell(col);
            if (rowIndex == fromRow) {
                cell.getCTTc().addNewTcPr().addNewVMerge().setVal(STMerge.RESTART);
            } else {
                cell.getCTTc().addNewTcPr().addNewVMerge().setVal(STMerge.CONTINUE);
            }
        }
        //合并后垂直居中
        table.getRow(fromRow).getCell(col).setVerticalAlignment(XWPFTableCell.XWPFVertAlign.CENTER);
    }


    
    public void mergeHorizontal(XWPFTable table, int row, int fromCell, int toCell) {
        for (int cellIndex = fromCell; cellIndex <= toCell; cellIndex++) {
            XWPFTableCell cell = table.getRow(row).getCell(cellIndex);
            if (cellIndex == fromCell) {
                cell.getCTTc().addNewTcPr().addNewHMerge().setVal(STMerge.RESTART);
                continue;
            } else {
                cell.getCTTc().addNewTcPr().addNewHMerge().setVal(STMerge.CONTINUE);
            }
        }
    }
    
    public void setPicture(XWPFParagraph paragraph, String path, String imgName, int wide, int high) throws IOException {
        //创建一个run。run具体是什么,我也不知道。但是run是这里面的最小单元了。
        XWPFRun run = paragraph.createRun();
        //使用url替代获取然后转换成流即可
        URL url = new URL(path);
        InputStream inputStream = url.openStream();
        //插入图片
        try {
            run.addPicture(inputStream,
                    XWPFDocument.PICTURE_TYPE_PNG,
                    imgName,
                    Units.toEMU(wide),
                    Units.toEMU(high));
        } catch (InvalidFormatException e) {
            e.printStackTrace();
        } catch (IOException e) {
            e.printStackTrace();
        }
        //关流
        inputStream.close();
    }

    
    public void setPieChart(XWPFDocument document, int width, int height, String title, String[] member, Integer[] dataNum) {
        XWPFChart chart = null;
        try {
            chart = document.createChart(width * Units.EMU_PER_CENTIMETER, height * Units.EMU_PER_CENTIMETER);
        } catch (InvalidFormatException e) {
            e.printStackTrace();
        } catch (IOException e) {
            e.printStackTrace();
        }
        // 标题
        chart.setTitleText(title);
        // 标题是否覆盖图表
        chart.setTitleOverlay(false);
        // 图例位置
        XDDFChartLegend legend = chart.getOrAddLegend();
        //legend.setPosition(LegendPosition.TOP_RIGHT);

        // CellRangeAddress(起始行号,终止行号, 起始列号,终止列号)
        // 分类轴标数据,
        // XDDFDataSource countries = XDDFDataSourcesFactory.fromStringCellRange(sheet, new CellRangeAddress(0, 0, 0, 6));
        XDDFCategoryDataSource countries = XDDFDataSourcesFactory.fromArray(member);
        // 数据1,
        // XDDFNumericalDataSource values = XDDFDataSourcesFactory.fromNumericCellRange(sheet, new CellRangeAddress(1, 1, 0, 6));
        XDDFNumericalDataSource values = XDDFDataSourcesFactory.fromArray(dataNum);
        // XDDFChartData data = chart.createData(ChartTypes.PIE3D, null, null);
        XDDFChartData data = chart.createData(ChartTypes.PIE, null, null);
        // 设置为可变颜色
        data.setVaryColors(true);
        // 图表加载数据
        data.addSeries(countries, values);

        //图表上显示数据
        CTDLbls dLbls = chart.getCTChart().getPlotArea().getPieChartArray(0).getSerArray(0).addNewDLbls();
        dLbls.addNewShowVal().setVal(false);
        dLbls.addNewShowLegendKey().setVal(false);
        dLbls.addNewShowCatName().setVal(true);//类别名称
        dLbls.addNewShowSerName().setVal(false);
        dLbls.addNewShowPercent().setVal(true);//百分比
        dLbls.addNewShowLeaderLines().setVal(true);//引导线
        dLbls.setSeparator("n");//分隔符为分行符
        dLbls.addNewDLblPos().setVal(org.openxmlformats.schemas.drawingml.x2006.chart.STDLblPos.Enum.forString("inEnd"));//数据标签内
        // 绘制
        chart.plot(data);
    }

    
    public void setHistogram(XWPFDocument document, int width, int height, String title, String xTitle, String yTitle,
                             String[] xMamber, Integer[] yDataNum, String xtitle) {
        // 2、创建chart图表对象,抛出异常
        XWPFChart chart = null;
        try {
            chart = document.createChart(width * Units.EMU_PER_CENTIMETER, height * Units.EMU_PER_CENTIMETER);
        } catch (InvalidFormatException e) {
            e.printStackTrace();
        } catch (IOException e) {
            e.printStackTrace();
        }
        // 3、图表相关设置
        chart.setTitleText(title); // 图表标题
        chart.setTitleOverlay(false); // 图例是否覆盖标题
        // 4、图例设置
        XDDFChartLegend legend = chart.getOrAddLegend();
        legend.setPosition(LegendPosition.TOP); // 图例位置:上下左右
        // 5、X轴(分类轴)相关设置
        XDDFCategoryAxis xAxis = chart.createCategoryAxis(AxisPosition.BOTTOM); // 创建X轴,并且指定位置
        xAxis.setTitle(xTitle); // x轴标题
        XDDFCategoryDataSource xAxisSource = XDDFDataSourcesFactory.fromArray(xMamber); // 设置X轴数据
        // 6、Y轴(值轴)相关设置
        XDDFValueAxis yAxis = chart.createValueAxis(AxisPosition.LEFT); // 创建Y轴,指定位置
        yAxis.setTitle(yTitle); // Y轴标题
        yAxis.setCrossBetween(AxisCrossBetween.BETWEEN); // 设置图柱的位置:BETWEEN居中
        XDDFNumericalDataSource yAxisSource = XDDFDataSourcesFactory.fromArray(yDataNum); // 设置Y轴数据
        // 7、创建柱状图对象
        XDDFBarChartData barChart = (XDDFBarChartData) chart.createData(ChartTypes.BAR, xAxis, yAxis);
        barChart.setBarDirection(BarDirection.COL); // 设置柱状图的方向:BAR横向,COL竖向,默认是BAR
        // 8、加载柱状图数据集
        XDDFBarChartData.Series barSeries = (XDDFBarChartData.Series) barChart.addSeries(xAxisSource, yAxisSource);
        barSeries.setTitle(xtitle, null); // 图例标题
        // 9、绘制柱状图
        chart.plot(barChart);
        // 10柱状图上显示数值
        CTPlotArea plotArea = chart.getCTChart().getPlotArea();
        plotArea.getValAxArray(0).addNewMajorGridlines();// 网格线
        plotArea.getBarChartArray(0).getSerArray(0).addNewDLbls();
        plotArea.getBarChartArray(0).getSerArray(0).getDLbls().addNewShowVal().setVal(true);
        plotArea.getBarChartArray(0).getSerArray(0).getDLbls().addNewShowLegendKey().setVal(false);
        plotArea.getBarChartArray(0).getSerArray(0).getDLbls().addNewShowCatName().setVal(false);
        plotArea.getBarChartArray(0).getSerArray(0).getDLbls().addNewShowSerName().setVal(false);
    }

    
    public void setLineChart(XWPFDocument document, int width, int height, String title, String xTitle, String yTitle
            , String[] member, Integer[] dataNum, String name) {

        // create the chart
        XWPFChart chart = null;
        try {
            chart = document.createChart(width * Units.EMU_PER_CENTIMETER, height * Units.EMU_PER_CENTIMETER);
        } catch (InvalidFormatException e) {
            e.printStackTrace();
        } catch (IOException e) {
            e.printStackTrace();
        }
        // 标题
        chart.setTitleText(title);
        // 标题覆盖
        chart.setTitleOverlay(false);
        // 图例位置
        XDDFChartLegend legend = chart.getOrAddLegend();
        legend.setPosition(LegendPosition.TOP);
        // 分类轴标(X轴),标题位置
        XDDFCategoryAxis bottomAxis = chart.createCategoryAxis(AxisPosition.BOTTOM);
        bottomAxis.setTitle(xTitle);
        // 值(Y轴)轴,标题位置
        XDDFValueAxis leftAxis = chart.createValueAxis(AxisPosition.LEFT);
        leftAxis.setTitle(yTitle);
        // CellRangeAddress(起始行号,终止行号, 起始列号,终止列号)
        // 分类轴标(X轴)数据,单元格范围位置[0, 0]到[0, 6]
        // XDDFDataSource countries = XDDFDataSourcesFactory.fromStringCellRange(sheet, new CellRangeAddress(0, 0, 0, 6));
        XDDFCategoryDataSource countries = XDDFDataSourcesFactory.fromArray(member);
        // 数据1,单元格范围位置[1, 0]到[1, 6]
        // XDDFNumericalDataSource area = XDDFDataSourcesFactory.fromNumericCellRange(sheet, new CellRangeAddress(1, 1, 0, 6));
        XDDFNumericalDataSource area = XDDFDataSourcesFactory.fromArray(dataNum);
        // 数据1,单元格范围位置[2, 0]到[2, 6]
        // XDDFNumericalDataSource population = XDDFDataSourcesFactory.fromNumericCellRange(sheet, new CellRangeAddress(2, 2, 0, 6));
        // LINE:折线图,
        XDDFLineChartData data = (XDDFLineChartData) chart.createData(ChartTypes.LINE, bottomAxis, leftAxis);
        // 图表加载数据,折线1
        XDDFLineChartData.Series series1 = (XDDFLineChartData.Series) data.addSeries(countries, area);
        // 折线图例标题
        series1.setTitle(name, null);
        // 直线
        series1.setSmooth(false);
        // 设置标记大小
        series1.setMarkerSize((short) 6);
        // 设置标记样式,星星
        series1.setMarkerStyle(MarkerStyle.STAR);
        // 绘制
        chart.plot(data);
    }
}

使用word工具类

​
  public void addWord() {
        WordUtils wordUtils = new WordUtils();

        XWPFDocument document = new XWPFDocument();
        //Write the Document in file system
        FileOutputStream out = null;
        try {
            out = new FileOutputStream(new File("D:\成绩分析.docx"));
        } catch (FileNotFoundException e) {
            e.printStackTrace();
        }

        //添加标题
        XWPFParagraph titleParagraph = document.createParagraph();
        wordUtils.setXWPFParagraph(titleParagraph, ParagraphAlignment.CENTER, "成绩分析", "000000", 30);

        population(document, wordUtils, new PopulationVo());

        //关流
        try {
            document.write(out);
            out.close();
        } catch (IOException e) {
            e.printStackTrace();
        }
    }

​

转载请注明:文章转载自 www.mshxw.com
本文地址:https://www.mshxw.com/it/946112.html
我们一直用心在做
关于我们 文章归档 网站地图 联系我们

版权所有 (c)2021-2022 MSHXW.COM

ICP备案号:晋ICP备2021003244-6号