How can I insert images in a file excell generated with serialized cocoon Poi?

[Iris Soto <ms...@agssa.net>]

Hi,

I am using poi-3.0-alpha3. I generate a Excel file with Cocoon/Poi HSSF 
Serializer, obtaining the inputstream that I want to
modify inserting the image and obtain this file with the image.

In the code I have the following:

............
            hssfworkbook = new HSSFWorkbook(inputstream);
            HSSFSheet s = hssfworkbook.getSheetAt(0);
            HSSFPatriarch patriarch = s.createDrawingPatriarch();
            patriarch.createPicture(anchor, 
loadPicture("/tmp/images/image.png",  hssfworkbook ));
            hssfworkbook.write(outputstream);
..........
private static int loadPicture( String path, HSSFWorkbook wb ) throws 
IOException{
        FileInputStream fis = null;
        ByteArrayOutputStream bos = null;
        int pictureIndex = 0;
        try{
            fis = new FileInputStream( path);
            bos = new ByteArrayOutputStream();
            int c;
            while ( (c = fis.read()) != -1) bos.write( c );
            pictureIndex = wb.addPicture( bos.toByteArray(), 
HSSFWorkbook.PICTURE_TYPE_PNG);
        } finally{
            if (fis != null)
                fis.close();
            if (bos != null)
                bos.close();
        }
        return pictureIndex;
    }

The file obtained can't be open. How can I modify the file obtained of 
HSSFSerializer in bytes,
inserting a image or Is there other form of implement this insertion 
using xml tags, to be serialized after with HSSFSerializer?.

Thanks in advance.

Iris Soto.

---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/