1.maven导入依赖
org.apache.poi poi-ooxml4.1.2 org.apache.poi poi-ooxml-schemas4.1.2 org.apache.poi poi4.1.2 org.apache.poi poi-scratchpad4.1.2 org.apache.commons commons-collections44.4 commons-codec commons-codec1.13 org.apache.commons commons-compress1.19 org.apache.xmlbeans xmlbeans3.1.0 org.apache.poi ooxml-schemas1.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();
}
}



