java excel 导入图片不显示_用Java向Excel中导入图片出现的问题

主要代码如下：POIFSFileSystemfs=newPOIFSFileSystem(newFileInputStream(newFile(excelPath)));HSSFWorkbookwb=newHSSFWorkbook(fs);HSSFSheetsheet1=wb.getSheet(0);ByteArrayOutp...

主要代码如下：

POIFSFileSystem fs = new POIFSFileSystem(new FileInputStream(new File(excelPath)));

HSSFWorkbook wb = new HSSFWorkbook(fs);

HSSFSheet sheet1 = wb.getSheet(0);

ByteArrayOutputStream byteArrayOut = new ByteArrayOutputStream();

bufferImg = ImageIO.read(new File("d:/PieChart.jpg"));

ImageIO.write(bufferImg,"jpg",byteArrayOut);

HSSFPatriarch patriarch = sheet1.createDrawingPatriarch();

HSSFClientAnchor anchor = new HSSFClientAnchor(0,0,512,255,(short) 1,1,(short)10,20);

anchor.setAnchorType(2);

patriarch.createPicture(anchor , wb.addPicture(byteArrayOut.toByteArray(),HSSFWorkbook.PICTURE_TYPE_JPEG));

fileOut = new FileOutputStream(new File("d:/workbook.xls"));

wb.write(fileOut);

fileOut.close();

可执行，但是再次打开导入图片后的Excel后弹错，说数据丢失，图片导入成功，但是既存的按钮控件都丢失了。。请问有没有大神能帮帮我~~在此感谢~~

展开