Created attachment 25807 [details]
test insert image xls file

@Test
    public void testInsertImageForHSSF() {
	HSSFWorkbook wb;
	HSSFSheet sheet;
	FileOutputStream foutput = null;
	FileInputStream finput = null;
	String xlsSourceFile = "testfile\\testinsertimage.xls";
	try {
	    finput = new FileInputStream(xlsSourceFile);
	    wb = new HSSFWorkbook(finput);
	    finput.close();
	    HSSFRow row;
	    sheet = wb.getSheetAt(1);
	    HSSFPatriarch patriarch = sheet.createDrawingPatriarch();

	    HSSFClientAnchor anchor;
	    anchor = new HSSFClientAnchor(0, 0, 0, 255, (short) 2, 2, (short) 4, 7);
	    anchor.setAnchorType(HSSFWorkbook.PICTURE_TYPE_EMF);
	    HSSFPicture picture = patriarch.createPicture(anchor, loadPicture("testfile\\test.emf", wb, HSSFWorkbook.PICTURE_TYPE_EMF));
	    // Reset the image to the original size.
	    picture.resize();
	    picture.setLineStyle(picture.LINESTYLE_DASHDOTGEL);
	    foutput = new FileOutputStream(xlsSourceFile);
	    wb.write(foutput);
	} catch (FileNotFoundException e) {
	    e.printStackTrace();
	} catch (IOException e) {
	    e.printStackTrace();
	} finally {
	    try {
		if (foutput != null)
		    foutput.close();
	    } catch (IOException e) {
		e.printStackTrace();
	    }
	}
    }