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);//插入图片 1patriarch.createPicture(anchor, wb.addPicture(byteArrayOut.toByteArray(), XSSFWorkbook.PICTURE_TYPE_PNG));//图片2anchor = 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();}}
