public static void main(String[] args) throws Exception{
FileOutputStream fileOut = null;
BufferedImage bufferImg = null;
try {
ByteArrayOutputStream byteArrayOut = new ByteArrayOutputStream();
//加载图片
bufferImg = ImageIO.read(new File("C:\\Users\\12436\\Desktop\\pict.jpg"));
ImageIO.write(bufferImg, "png", byteArrayOut);
XSSFWorkbook wb = new XSSFWorkbook();
XSSFSheet sheet1 = wb.createSheet("sheet1");
XSSFDrawing patriarch = sheet1.createDrawingPatriarch();
XSSFClientAnchor anchor = new XSSFClientAnchor(0, 0, 0, 0,(short) 2, 2, (short) 5, 8);
//插入图片 1
patriarch.createPicture(anchor, wb.addPicture(byteArrayOut.toByteArray(), XSSFWorkbook.PICTURE_TYPE_PNG));
//图片2
anchor = new XSSFClientAnchor(200, 0, 0, 0,(short) 2, 9, (short) 5, 15);
patriarch.createPicture(anchor, wb.addPicture(byteArrayOut.toByteArray(), XSSFWorkbook.PICTURE_TYPE_PNG));
fileOut = new FileOutputStream("C:\\Users\\12436\\Desktop\\excel.xlsx");
// 输出文件
wb.write(fileOut);
} catch (Exception e) {
e.printStackTrace();
}
}
java poi导出excel插入图片
最新推荐文章于 2024-05-29 15:29:20 发布