我要用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);
但是图片是插入了,原先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);
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货