POI如何循環插入圖片

最近遇到一個問題，特與大家一起分享一下，如果用POI對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();    
            System.out.println("erorr : " + io.getMessage());    
        } finally {    
            if (fileOut != null) {    
                try {    
                    fileOut.close();    
                } catch (IOException e) {    
                    e.printStackTrace();    
                }    
            }    
        }    
    }    

 

 

試著用一個循環來插入圖片，不知道可我怎么試都不成功！是不是哪裡還少了什么。下面是我的代碼：

public static void main(String[] args) {
    FileOutputStream fileOut = null;
    BufferedImage bufferImg = null;
    BufferedImage bufferImg1 = null;
    try {
      //创建一个工作薄
      HSSFWorkbook wb = new HSSFWorkbook();
      HSSFSheet sheet1 = wb.createSheet("new sheet");
      //先把读进来的图片放到一个ByteArrayOutputStream中，以便产生ByteArray
      for (int i = 0; i < 20; i++) {
        ByteArrayOutputStream byteArrayOut = new ByteArrayOutputStream();
        bufferImg = ImageIO.read(new File("c:\\wwwroot\\smeposV3\\images\\logo.jpg"));
        ImageIO.write(bufferImg, "jpg", byteArrayOut);

        //HSSFRow row = sheet1.createRow(2);
        HSSFPatriarch patriarch = sheet1.createDrawingPatriarch();
        HSSFClientAnchor anchor = new HSSFClientAnchor(0, 0, bufferImg.getWidth(), bufferImg.getHeight(), (short) 0, i, (short) 3, i+5);
        //插入图片
        patriarch.createPicture(anchor, wb.addPicture(byteArrayOut.toByteArray(), HSSFWorkbook.PICTURE_TYPE_JPEG));
      }
      fileOut = new FileOutputStream("c:/workbook.xls");
      //写入excel文件
      wb.write(fileOut);
      fileOut.close();

    } catch (IOException io) {
      io.printStackTrace();
      System.out.println("io erorr : " + io.getMessage());
    } finally {
      if (fileOut != null) {

        try {
          fileOut.close();
        }
        catch (IOException e) {
          // TODO Auto-generated catch block
          e.printStackTrace();
        }
      }
    }
  }

 

如何循環加入圖片呢？請大家幫幫忙！謝謝了！

 

 

上面這個問題終於解決了，原來我把HSSFPatriarch patriarch = sheet1.createDrawingPatriarch();這個對象放在循環裡去了，它只能聲明一次，下次再遇到，記住了！