POI does not support image inclusion in Excel files, so you can't use it
for this purpose. There is a far better API for managing Excel
spreadsheets in Java called JExcelApi. See
http://jexcelapi.sourceforge.net/. Generally JExcelAPI is far more
efficient and straightforward than POI. The WriteableImage class in
there makes image writing simple and easy, for example:
WritableImage wi= new WritableImage(imagecol, imagerow, imagewidth,
imageheight, new File(params.IMAGESFILE()));
writeSheet.addImage(wi);
good luck.
joan612@so-net.net.tw wrote:
>Dear all
> Does anyone can insert an image into a excel file?
>I use the quick guide in hssf help as my program code..but it not work!
>It can generate a excel successfully, but an empty content..
>When I close this file, excel will alert unexpect error..
>Anyone can help me to solve this issue.......
>
>
> a = new HSSFClientAnchor( 0, 0, 1023, 255, (short) 1, 0, (short) 1, 0 );
> group = patriarch.createGroup( a );
> group.setCoordinates( 0, 0, 80 * 4 , 12 * 23 );
> float verticalPointsPerPixel = a.getAnchorHeightInPoints(sheet) / (float)Math.abs(group.getY2()
- group.getY1());
> g = new EscherGraphics( group, wb, Color.black, verticalPointsPerPixel );
> g2d = new EscherGraphics2d( g );
> g2d.drawimage(image, ...............) //image object is created by java.awt
>
>
>Joan
>
>
>
|