poi 移除图片_使用POI在EXCEL文件中插入图片的方法!

public void test4() throws Exception{

POIFSFileSystem fs  = new POIFSFileSystem(new FileInputStream("D:\\xxx.xls"));  //打开一个Excel文件

HSSFWorkbook wb = new HSSFWorkbook(fs);

HSSFSheet sheet = wb.getSheetAt(0);

HSSFPatriarch patriarch = sheet.createDrawingPatriarch();

ByteArrayOutputStream byteArrayOut = new ByteArrayOutputStream();

BufferedImage bufferImg = ImageIO.read(new File("d:\\pic02.jpg"));  //打开一个图片文件

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

//HSSFClientAnchor anchor = new HSSFClientAnchor(0,0,0,0,(short) 19,35,(short)(19+3),35+4);

HSSFClientAnchor anchor = new HSSFClientAnchor(0,0,0,0,(short) 19,35,(short)(19+3),35+4); // 设置图片的位置.开始位置19,35  占用格子3,4

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

FileOutputStream fileOut = new FileOutputStream("D:\\xxx4.xls");    // 输出文件.

wb.write(fileOut);

fileOut.close();

}

经过测试,只能占用整个单元格! 郁闷中...........