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); // 設(shè)置圖片的位置.開始位置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();
 }
經(jīng)過測試,只能占用整個單元格! 郁悶中...........