poi写入图片25.docVIP

POI实现Excel插入多张图片（转） POI的操作Excel时，不可避免有操作图片的处理。怎么插入图片呢？网上也有不少介绍。 下面的代码是向Excel中插入多张图片的例子： public static void main(String[] args) { FileOutputStream fileOut = null; BufferedImage bufferImg = null; BufferedImage bufferImg1 = null; try { // 先把读进来的图片放到一个ByteArrayOutputStream中，以便产生ByteArray // 读入图片1 ByteArrayOutputStream byteArrayOut = new ByteArrayOutputStream(); bufferImg = ImageIO.read(new File(d:\\test11.jpg)); ImageIO.write(bufferImg, jpg, byteArrayOut); // 读入图片2 ByteArrayOutputStream byteArrayOut1 = new ByteArrayOutputStream(); bufferImg1 = ImageIO.read(new File(d:\\test22.png)); ImageIO.write(bufferImg1, png, byteArrayOut1); // 创建一个工作薄 HSSFWorkbook wb = new HSSFWorkbook(); HSSFSheet sheet1 = wb.createSheet(test picture); HSSFPatriarch patriarch = sheet1.createDrawingPatriarch(); HSSFClientAnchor anchor = new HSSFClientAnchor(0, 0, 255, 255, (short) 1, 1, (short) 5, 5); anchor.setAnchorType(3); HSSFClientAnchor anchor1 = new HSSFClientAnchor(0, 0, 255, 255, (short) 6, 6, (short) 10, 10); anchor1.setAnchorType(3); // 插入图片1 patriarch.createPicture(anchor, wb.addPicture(byteArrayOut .toByteArray(), HSSFWorkbook.PICTURE_TYPE_JPEG)); // 插入图片2 patriarch.createPicture(anchor1, wb.addPicture(byteArrayOut1 .toByteArray(), HSSFWorkbook.PICTURE_TYPE_PNG)); fileOut = new FileOutputStream(d:/workbook.xls); // 写入excel文件 wb.write(fileOut); fileOut.close(); } catch (IOException io) { io.printStackTrace();