我要用JAVA POI 插一张图片到已经图片的EXCEL里
但是图片是插入了,原先EXCEL里的图片确不见了,EXCEL里还有CHECKBOX也不见了,求助各位
代码:
                          String excelFileName = "D:/bb.xls";
      String pictureFileName = "D:/aa.jpg";
      FileInputStream  file = new FileInputStream(excelFileName);
      HSSFWorkbook wb = new HSSFWorkbook(file);
      
      ByteArrayOutputStream byteArrayOut = new ByteArrayOutputStream();
      BufferedImage bufferImg = ImageIO.read(new File(pictureFileName));
      ImageIO.write(bufferImg, "JPG", byteArrayOut);
      HSSFClientAnchor anchor = new HSSFClientAnchor(0,0, 512, 255,(short) 1, 37, (short) 4, 47);
               HSSFPatriarch patri = wb.getSheetAt(0).createDrawingPatriarch();
      patri.createPicture(anchor, wb.addPicture(byteArrayOut
                 .toByteArray(), HSSFWorkbook.PICTURE_TYPE_JPEG));
               FileOutputStream outStream = new FileOutputStream(excelFileName _out);
      wb.write(outStream);