How to insert images in excel using jxl API

[Manikanta Mogalluri]

Hi All,

Could you please help me to insert images in excel workbook using jxl API.

Kindly give me any sample code.

[Ulf Dittmer]

The jxl.write.WritableSheet class has the addImage method for that. Note that only PNG images are supported. If you have a JPEG, GIF or BMP you can use the javax.imageio.ImageIO class to convert them to PNG.

[Manikanta Mogalluri]

Hi Ulf,

Thanks for giving the method.

It will be very useful if give me the sample code for this issue.

[Ulf Dittmer]

Search for "jexcelapi faq", it has an example.

[shareeef hiasat]

This code i used and worked but i faced little problems with sizing the image

As you see you must convert to PNG because its the only one supported

As if you worndered about if you can put it in some cell you cant stackoverflow inserting image into cell jxl

////////// WritableImage
//////////
//////////public WritableImage(double x,
//////////                     double y,
//////////                     double width,
//////////                     double height,
//////////                     java.io.File image)
//////////
//////////    Constructor
//////////
//////////Parameters:
//////////    x - the column number at which to position the image
//////////    y - the row number at which to position the image START FROM 0
//////////    width - the number of columns cells which the image spans
//////////    height - the number of rows which the image spans
//////////    image - the source image file
///
       

 java.io.File imageFile = new java.io.File(imgPath + "/HK_logo.jpg");
        BufferedImage input = ImageIO.read(imageFile);
        ByteArrayOutputStream baos = new ByteArrayOutputStream();
        ImageIO.write(input, "PNG", baos);
        sheet.addImage(new WritableImage(4,0,1,
        1,baos.toByteArray()))

;