POI在Excel中插入图片

来源：互联网发布：宇宙大小的相关数据编辑：程序博客网时间：2024/04/26 21:29

POI下载地址

http://www.fayea.com/apache-mirror/poi/release/bin/poi-bin-3.9-20121203.tar.gz

public static void main(String[] args) {FileOutputStream fileOut = null;     BufferedImage bufferImg =null;     BufferedImage bufferImg1 = null; try {//读取图片ByteArrayOutputStream byteArrayOut = new ByteArrayOutputStream();     ByteArrayOutputStream byteArrayOut1 = new ByteArrayOutputStream();     bufferImg = ImageIO.read(new File("e:/nanjing.jpg"));     bufferImg1 = ImageIO.read(new File("e:/nanjing.jpg"));     ImageIO.write(bufferImg,"jpg",byteArrayOut);     ImageIO.write(bufferImg1,"jpg",byteArrayOut1);   //创建excel HSSFWorkbook excelfile = new HSSFWorkbook();HSSFSheet excelsheet=excelfile.createSheet();excelfile.setSheetName(0, "aaa");//设置图片位置    HSSFPatriarch patriarch = excelsheet.createDrawingPatriarch();         HSSFClientAnchor anchor = new HSSFClientAnchor(0,0,512,255,(short) 1,1,(short)10,20);         HSSFClientAnchor anchor1 = new HSSFClientAnchor(0,0,512,255,(short) 2,30,(short)10,60);               patriarch.createPicture(anchor , excelfile.addPicture(byteArrayOut.toByteArray(),HSSFWorkbook.PICTURE_TYPE_JPEG));        patriarch.createPicture(anchor1 , excelfile.addPicture(byteArrayOut1.toByteArray(),HSSFWorkbook.PICTURE_TYPE_JPEG));       //输出到磁盘  fileOut = new FileOutputStream("E:/1/t"+System.currentTimeMillis()+".xls");excelfile.write(fileOut);fileOut.close();} catch (FileNotFoundException e) {System.out.println(e.getLocalizedMessage());} catch (IOException e) {System.out.println(e.getLocalizedMessage());}}