#poi导出图片到excel,导出成功但是图片不显示,哪位大佬帮助一下
//写入图片
private static void writeImg(Workbook workbook, Sheet sheet, Row currentRow, String imgPath, int currentColumnIndex, SXSSFDrawing drawing) {
try {
URL url = new URL(imgPath);
BufferedImage image = ImageIO.read(url);
ByteArrayOutputStream byteArrayOut = new ByteArrayOutputStream();
ImageIO.write(image, imgPath.substring(imgPath.lastIndexOf(".") + 1), byteArrayOut);
//判断图片后缀
int addPicture;
String hz = imgPath.substring(imgPath.lastIndexOf(".") + 1);
if("jpg".equals(hz)){
addPicture = workbook.addPicture(byteArrayOut.toByteArray(), workbook.PICTURE_TYPE_JPEG);
} else {
addPicture = workbook.addPicture(byteArrayOut.toByteArray(), workbook.PICTURE_TYPE_PNG);
}
ClientAnchor anchor = drawing.createAnchor( 50, 50, 50, 50, currentColumnIndex, currentRow.getRowNum(), currentColumnIndex + 1, currentRow.getRowNum() + 1);
//图片位置
// XSSFClientAnchor anchor = new XSSFClientAnchor(5, 5, 5, 5, currentColumnIndex, currentRow.getRowNum(), currentColumnIndex + 1,currentRow.getRowNum() + 1);
// anchor.setAnchorType(ClientAnchor.AnchorType.MOVE_AND_RESIZE);
drawing.createPicture(anchor, addPicture);
} catch (Exception e) {
e.printStackTrace();
}
}
图片及输出流都是没问题的,但是导出后图片就如下所示了