java poi 在excel中插入图片

java web中导出excel数据是常见的功能，最近遇到一个需求是在excel中插入图片。处理excel及其他微软办公系列软件常用的就是apache poi，它也是支持图片插入的。插入图片最主要的用到HSSFClientAnchor，HSSFClientAnchor的文档介绍如下：

public HSSFClientAnchor(int dx1,

                int dy1,

                int dx2,

                int dy2,

                short col1,

                int row1,

                short col2,

                int row2)

Creates a new client anchor and sets the top-left and bottom-right coordinates of the anchor. Note: Microsoft Excel seems to sometimes disallow higher y1 than y2 or higher x1 than x2, you might need to reverse them and draw shapes vertically or horizontally flipped!

Parameters:

dx1 - the x coordinate within the first cell.//定义了图片在第一个cell内的偏移x坐标，既左上角所在cell的偏移x坐标，一般可设0dy1 - the y coordinate within the first cell.//定义了图片在第一个cell的偏移y坐标，既左上角所在cell的偏移y坐标，一般可设0dx2 - the x coordinate within the second cell.//定义了图片在第二个cell的偏移x坐标，既右下角所在cell的偏移x坐标，一般可设0dy2 - the y coordinate within the second cell.//定义了图片在第二个cell的偏移y坐标，既右下角所在cell的偏移y坐标，一般可设0col1 - the column (0 based) of the first cell.//第一个cell所在列，既图片左上角所在列row1 - the row (0 based) of the first cell.//图片左上角所在行col2 - the column (0 based) of the second cell.//图片右下角所在列row2 - the row (0 based) of the second cell.//图片右下角所在行

具体demo 如下：

[java] view plain copy

1. import java.awt.image.BufferedImage;  
2. import java.io.ByteArrayOutputStream;  
3. import java.io.File;  
4. import java.io.FileOutputStream;  
5. import javax.imageio.ImageIO;  
6.  
7. import org.apache.poi.hssf.usermodel.HSSFClientAnchor;  
8. import org.apache.poi.hssf.usermodel.HSSFPatriarch;  
9. import org.apache.poi.hssf.usermodel.HSSFSheet;  
10. import org.apache.poi.hssf.usermodel.HSSFWorkbook;  
11.  
12. public class ExcelExport {  
13.  
14.     public static void main(String[] args) {  
15.         FileOutputStream fileOut = null;     
16.         BufferedImage bufferImg = null;     
17.         try {  
18.             ByteArrayOutputStream byteArrayOut = new ByteArrayOutputStream();  
19.           //加载图片  
20.             bufferImg = ImageIO.read(new File("e:/1.jpg"));     
21.             ImageIO.write(bufferImg, "jpg", byteArrayOut);  
22.             HSSFWorkbook wb = new HSSFWorkbook();     
23.             HSSFSheet sheet1 = wb.createSheet("sheet1");    
24.             HSSFPatriarch patriarch = sheet1.createDrawingPatriarch();     
25.             /** 
26.                 dx1 - the x coordinate within the first cell.//定义了图片在第一个cell内的偏移x坐标，既左上角所在cell的偏移x坐标，一般可设0 
27.                 dy1 - the y coordinate within the first cell.//定义了图片在第一个cell的偏移y坐标，既左上角所在cell的偏移y坐标，一般可设0 
28.                 dx2 - the x coordinate within the second cell.//定义了图片在第二个cell的偏移x坐标，既右下角所在cell的偏移x坐标，一般可设0 
29.                 dy2 - the y coordinate within the second cell.//定义了图片在第二个cell的偏移y坐标，既右下角所在cell的偏移y坐标，一般可设0 
30.                 col1 - the column (0 based) of the first cell.//第一个cell所在列，既图片左上角所在列 
31.                 row1 - the row (0 based) of the first cell.//图片左上角所在行 
32.                 col2 - the column (0 based) of the second cell.//图片右下角所在列 
33.                 row2 - the row (0 based) of the second cell.//图片右下角所在行 
34.             */  
35.             HSSFClientAnchor anchor = new HSSFClientAnchor(-100, 0, 0, 0,(short) 2, 2, (short) 5, 8);     
36.             //插入图片    
37.             patriarch.createPicture(anchor, wb.addPicture(byteArrayOut.toByteArray(), HSSFWorkbook.PICTURE_TYPE_JPEG));   
38.             fileOut = new FileOutputStream("e:/excel.xls");     
39.             // 输出文件   
40.             wb.write(fileOut);     
41.         } catch (Exception e) {  
42.             e.printStackTrace();  
43.         }  
44.     }  
45. }  

关于dx1的设置的说明，dx2，dy1等都是类似的

关于一个excel设置设置多张图片的demo

[java] view plain copy

46. package com.poi;  
47.  
48. import java.awt.image.BufferedImage;  
49. import java.io.ByteArrayOutputStream;  
50. import java.io.File;  
51. import java.io.FileOutputStream;  
52. import javax.imageio.ImageIO;  
53.  
54. import org.apache.poi.hssf.usermodel.HSSFClientAnchor;  
55. import org.apache.poi.hssf.usermodel.HSSFPatriarch;  
56. import org.apache.poi.hssf.usermodel.HSSFSheet;  
57. import org.apache.poi.hssf.usermodel.HSSFWorkbook;  
58.  
59. public class ExcelExport {  
60.  
61.     public static void main(String[] args) {  
62.         FileOutputStream fileOut = null;     
63.         BufferedImage bufferImg = null;     
64.         try {  
65.             ByteArrayOutputStream byteArrayOut = new ByteArrayOutputStream();  
66.           //加载图片  
67.             bufferImg = ImageIO.read(new File("e:/1.jpg"));     
68.             ImageIO.write(bufferImg, "jpg", byteArrayOut);  
69.             HSSFWorkbook wb = new HSSFWorkbook();     
70.             HSSFSheet sheet1 = wb.createSheet("sheet1");    
71.             HSSFPatriarch patriarch = sheet1.createDrawingPatriarch();     
72.             HSSFClientAnchor anchor = new HSSFClientAnchor(0, 0, 0, 0,(short) 2, 2, (short) 5, 8);  
73.             //插入图片 1   
74.             patriarch.createPicture(anchor, wb.addPicture(byteArrayOut.toByteArray(), HSSFWorkbook.PICTURE_TYPE_JPEG));  
75.              
76.             //图片2  
77.             anchor = new HSSFClientAnchor(200, 0, 0, 0,(short) 2, 9, (short) 5, 15);  
78.             patriarch.createPicture(anchor, wb.addPicture(byteArrayOut.toByteArray(), HSSFWorkbook.PICTURE_TYPE_JPEG));  
79.             fileOut = new FileOutputStream("e:/excel.xls");     
80.             // 输出文件   
81.             wb.write(fileOut);     
82.         } catch (Exception e) {  
83.             e.printStackTrace();  
84.         }  
85.     }  
86. }  

总体来说使用poi还是很方便的。