POI向word添加图片,表格
package com.xxx.yyy.commons; import java.io.IOException;import java.io.InputStream;import org.apache.poi.openxml4j.opc.OPCPackage;import org.apache.poi.xwpf.usermodel.XWPFDocument;import org.apache.poi.xwpf.usermodel.XWPFParagraph;import org.apache.xmlbeans.XmlException;import org.apache.xmlbeans.XmlToken;import org.openxmlformats.schemas.drawingml.x2006.main.CTNonVisualDrawingProps;import org.openxmlformats.schemas.drawingml.x2006.main.CTPositiveSize2D;import org.openxmlformats.schemas.drawingml.x2006.wordprocessingDrawing.CTInline; /** * @author POI 导出图片bug修复 * */ public class CustomXWPFDocument extends XWPFDocument { public CustomXWPFDocument(InputStream in) throws IOException { super(in); } /** * */ public CustomXWPFDocument() { super(); // TODO Auto-generated constructor stub } /** * @param pkg * @throws IOException */ public CustomXWPFDocument(OPCPackage pkg) throws IOException { super(pkg); // TODO Auto-generated constructor stub } // picAttch 图片后面追加的字符串 可以是空格 public void createPicture(XWPFParagraph paragraph,int id, int width, int height,String picAttch) { final int EMU = 9525; width *= EMU; height *= EMU; String blipId = getAllPictures().get(id).getPackageRelationship() .getId(); CTInline inline = paragraph.createRun().getCTR() .addNewDrawing().addNewInline(); paragraph.createRun().setText(picAttch); String picXml = "" + "<a:graphic xmlns:a=\"http://schemas.openxmlformats.org/drawingml/2006/main\">" + " <a:graphicData uri=\"http://schemas.openxmlformats.org/drawingml/2006/picture\">" + " <pic:pic xmlns:pic=\"http://schemas.openxmlformats.org/drawingml/2006/picture\">" + " <pic:nvPicPr>" + " <pic:cNvPr id=\"" + id + "\" name=\"Generated\"/>" + " <pic:cNvPicPr/>" + " </pic:nvPicPr>" + " <pic:blipFill>" + " <a:blip r:embed=\"" + blipId + "\" xmlns:r=\"http://schemas.openxmlformats.org/officeDocument/2006/relationships\"/>" + " <a:stretch>" + " <a:fillRect/>" + " </a:stretch>" + " </pic:blipFill>" + " <pic:spPr>" + " <a:xfrm>" + " <a:off x=\"0\" y=\"0\"/>" + " <a:ext cx=\"" + width + "\" cy=\"" + height + "\"/>" + " </a:xfrm>" + " <a:prstGeom prst=\"rect\">" + " <a:avLst/>" + " </a:prstGeom>" + " </pic:spPr>" + " </pic:pic>" + " </a:graphicData>" + "</a:graphic>"; // CTGraphicalObjectData graphicData = inline.addNewGraphic().addNewGraphicData(); XmlToken xmlToken = null; try { xmlToken = XmlToken.Factory.parse(picXml); } catch (XmlException xe) { xe.printStackTrace(); } inline.set(xmlToken); // graphicData.set(xmlToken); inline.setDistT(0); inline.setDistB(0); inline.setDistL(0); inline.setDistR(0); CTPositiveSize2D extent = inline.addNewExtent(); extent.setCx(width); extent.setCy(height); CTNonVisualDrawingProps docPr = inline.addNewDocPr(); docPr.setId(id); docPr.setName("图片" + id); docPr.setDescr(""); } } ?POI或者JXL、docx4j,都是基于公开的标准做的。Office自2007版本开始使用ooxml,压缩的xml文档,2007之前都是二进制的B+树。但是2007+版本也只是把文件通用性结构部分公开了,微软的半开放导致一残废则都残废。所以设计到真正的图表,Flash 都没法子了。上面的类是代替POI中的XWPFDocument。因为继承了XWPFDocument,所以addPictureData不用重写了,图片显示的方法新增一下。这是因为POI 在拼装xml的时候把图片数据放入了,但是没有给提供显示的方法。用了OOXML就要用2007+版本,之所以选择它是因为2007+已经成为了世界标准。2007更是一个里程碑(不谈对微软情感看法)。
?action:
??
public void exportToWord2(){try { int picWidth = 240; int picHeight = 150; int picType = XWPFDocument.PICTURE_TYPE_JPEG; String filePath = "简报.docx"; response.reset(); // 清空buffer response.setContentType("application/vnd.openxmlformats-officedocument.wordprocessingml.document");filePath = java.net.URLEncoder.encode(filePath, "UTF-8");response.setHeader("Content-Disposition", "attachment; filename="+ new String(filePath.getBytes("UTF-8"), "GBK"));// 定义文件名response.setHeader("Pragma", "no-cache");response.setHeader("Expires", " 0");ServletOutputStream fOut = response.getOutputStream();XWPFParagraph paragraph = null;XWPFTable table = null;CustomXWPFDocument doc = new CustomXWPFDocument();paragraph = doc.createParagraph();doc.addPictureData(picInputStream,picType);doc.createPicture(paragraph,doc.getAllPictures().size()-1, picWidth, picHeight,"");doc.write(fOut);fOut.flush();fOut.close();response.getOutputStream().flush();response.getOutputStream().close();} catch (Exception e) {e.printStackTrace();}}?其中picInputStream 省略,这个图可以是又Jfreechart得到。
??
JFreeChart chart = null; //.......省略ByteArrayOutputStream out = new ByteArrayOutputStream();ChartUtilities.writeChartAsPNG(out, chart, 400, 300);ByteArrayInputStream in = new ByteArrayInputStream(out.toByteArray());return in;
??
这样通过Jfreechart就可以得到ByteArrayInputStream.
因为addPictureData方法接收的参数是InputStream 看到网上很多人喜欢先写入操作系统,然后读取到流,我不喜。在生成图片的时候直接放到ByteArrayInputStream(继承了抽象类InputStream),直接获取就少了存储相关的操作。JFreechart获取inputStream也就这2行代码。
createPicture方法的picAttch是图片之间放的东西 可以是N个空格做间隔,也可以是文字
弄一个word文件写入磁盘中测试例子,包含POI生成表格到word,jfreechart和POI生成图插入到word.需要jfreechart和poi ooxml的jar
import java.awt.Color;import java.awt.Font;import java.io.ByteArrayInputStream;import java.io.ByteArrayOutputStream;import java.io.FileOutputStream;import java.text.DecimalFormat;import java.text.NumberFormat;import org.apache.poi.xwpf.usermodel.XWPFDocument;import org.apache.poi.xwpf.usermodel.XWPFTable;import org.apache.poi.xwpf.usermodel.XWPFTableRow;import org.jfree.chart.ChartFactory;import org.jfree.chart.ChartUtilities;import org.jfree.chart.JFreeChart;import org.jfree.chart.labels.StandardPieSectionLabelGenerator;import org.jfree.chart.plot.PiePlot;import org.jfree.chart.plot.PlotOrientation;import org.jfree.data.category.DefaultCategoryDataset;import org.jfree.data.general.DefaultPieDataset; public class CreateTablesWithPOI {public static void main(String[] args) {String outputFile = "D:\\test.docx";CustomXWPFDocument document = new CustomXWPFDocument();XWPFTable tableOne = document.createTable();XWPFTableRow tableOneRowOne = tableOne.getRow(0);tableOneRowOne.getCell(0).setText("第1行第1列");tableOneRowOne.addNewTableCell().setText("第1行第2列");tableOneRowOne.addNewTableCell().setText("第1行第3列");tableOneRowOne.addNewTableCell().setText("第1行第4列");XWPFTableRow tableOneRowTwo = tableOne.createRow();tableOneRowTwo.getCell(0).setText("第2行第1列");tableOneRowTwo.getCell(1).setText("第2行第2列");tableOneRowTwo.getCell(2).setText("第2行第3列");FileOutputStream fOut;try {fOut = new FileOutputStream(outputFile);ByteArrayInputStream in = getPieChartImage();String ind = document.addPictureData(in, XWPFDocument.PICTURE_TYPE_JPEG); System.out.println("pic ID=" + ind);document.createPicture(document.getAllPictures().size()-1, 200, 200," "); // 放第二张图ind = document.addPictureData(getBarChartImage(), XWPFDocument.PICTURE_TYPE_JPEG); System.out.println("pic ID=" + ind);document.createPicture(document.getAllPictures().size()-1, 200, 200," "); document.write(fOut); fOut.flush();// 操作结束,关闭文件fOut.close();} catch (Exception e) {e.printStackTrace();} }public static ByteArrayInputStream getPieChartImage() {ByteArrayInputStream in = null;DefaultPieDataset pieDataset = new DefaultPieDataset();pieDataset.setValue(" 北京局 ", 20);pieDataset.setValue(" 上海局 ", 18);pieDataset.setValue(" 天津局 ", 16);pieDataset.setValue(" 重庆局 ", 15);pieDataset.setValue(" 山东局 ", 45);JFreeChart chart = ChartFactory.createPieChart3D(" 企业备案图 ", pieDataset,true, false, false);// 设置标题字体样式chart.getTitle().setFont(new Font(" 黑体 ", Font.BOLD, 20));// 设置饼状图里描述字体样式PiePlot piePlot = (PiePlot) chart.getPlot();piePlot.setLabelFont(new Font(" 黑体 ", Font.BOLD, 10));// 设置显示百分比样式piePlot.setLabelGenerator(new StandardPieSectionLabelGenerator((" {0}({2}) "), NumberFormat.getNumberInstance(),new DecimalFormat(" 0.00% ")));// 设置统计图背景piePlot.setBackgroundPaint(Color.white);// 设置图片最底部字体样式chart.getLegend().setItemFont(new Font(" 黑体 ", Font.BOLD, 10));try {ByteArrayOutputStream out = new ByteArrayOutputStream();ChartUtilities.writeChartAsPNG(out, chart, 400, 300); in = new ByteArrayInputStream(out.toByteArray());} catch (Exception e) {e.printStackTrace();} return in;}public static ByteArrayInputStream getBarChartImage() {ByteArrayInputStream in = null;DefaultCategoryDataset dataset =new DefaultCategoryDataset(); dataset.addValue(100,"Spring Security","Jan");dataset.addValue(200,"jBPM 4","Jan");dataset.addValue(300,"Ext JS","Jan");dataset.addValue(400,"JFreeChart","Jan");JFreeChart chart = ChartFactory.createBarChart("chart","num","type",dataset, PlotOrientation.VERTICAL, true, false, false); // 设置标题字体样式chart.getTitle().setFont(new Font(" 黑体 ", Font.BOLD, 20));// 设置饼状图里描述字体样式// 设置图片最底部字体样式chart.getLegend().setItemFont(new Font(" 黑体 ", Font.BOLD, 10));try {ByteArrayOutputStream out = new ByteArrayOutputStream();ChartUtilities.writeChartAsPNG(out, chart, 400, 300); in = new ByteArrayInputStream(out.toByteArray());} catch (Exception e) {e.printStackTrace();} return in;}}?
?POI中设置一段文字我们可以写一个静态通用方法createParagraphContent,大致内容如下POI.java
?
public static void createParagraphContent(CustomXWPFDocument doc,String content) {XWPFRun title= doc.createParagraph().createRun();// 设置一个新的段落title.setText(content); title.setFontFamily("宋体"); title.setBold(true); }?
?
?