You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by David Thielen <da...@windward.net> on 2004/12/04 22:39:48 UTC

Placing an image in xls

Hi;

 

How do I place an image (jpg, etc) in a cell?

 

Thanks - dave


Re: How to generate EXCEL in JSP

Posted by Balaji <ba...@solverminds.com>.
Hi friends,

I have developed Export to excel report from Java Swing appln with POI, now
my requirement is to export the report from JSP(Web) to excel, I am
retrieving the result set in Java Bean, not in the JSP, I am sending the
Value Objects to the JSP from JavaBean, how can i do the export feature in
web? can i do it with POI efficiently??



---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org


Re: Placing an image in xls

Posted by Danny Mui <da...@muibros.com>.
stable is as stable does.  if it works for you go for it.

David Thielen wrote:
> Should I use jxl instead of poi? I only need to create spreadsheets, not
> read them. And if so, how stable is jxl?
> 
> Thanks - dave
> 
> 
> -----Original Message-----
> From: Andre Schild [mailto:a.schild@aarboard.ch] 
> Sent: Monday, December 06, 2004 12:19 AM
> To: 'POI Users List'
> Subject: AW: Placing an image in xls
> 
> 
>>How do I place an image (jpg, etc) in a cell?
>>
> 
> 
> Actually you can't with POI.
> There are currently two work arrounds:
> 
> - Use a template with the images already in them
> - Create the xls file with poi, and in a second step add
>   the images with jxl. http://www.andykhan.com/jexcelapi/
> 
> André
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
> 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org

---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org


AW: Placing an image in xls

Posted by Andre Schild <a....@aarboard.ch>.
> Should I use jxl instead of poi? I only need to create 

I can't answer if you should use jxl INSTEAD of poi.
We use poi for the read AND write of excel files, so it's a good choice for us.

> spreadsheets, not read them. And if so, how stable is jxl?
> 

We use jxl only to add images to the xls file, and it has
never failed at this task. It even generated 185MB xls files with ~8000 pictures
in it with no problem. (Ok, it took some time to generate, but it did work)


I think, if you need images in you xls file and jxl covers your needs,
then go for it, no need to involve two systems if one covers your needs.


André

> Thanks - dave
> 
> 
> -----Original Message-----
> From: Andre Schild [mailto:a.schild@aarboard.ch] 
> Sent: Monday, December 06, 2004 12:19 AM
> To: 'POI Users List'
> Subject: AW: Placing an image in xls
> 
> > How do I place an image (jpg, etc) in a cell?
> > 
> 
> Actually you can't with POI.
> There are currently two work arrounds:
> 
> - Use a template with the images already in them
> - Create the xls file with poi, and in a second step add
>   the images with jxl. http://www.andykhan.com/jexcelapi/
> 
> André
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
> 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
> 
> 


---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org


RE: Placing an image in xls

Posted by David Thielen <da...@windward.net>.
Should I use jxl instead of poi? I only need to create spreadsheets, not
read them. And if so, how stable is jxl?

Thanks - dave


-----Original Message-----
From: Andre Schild [mailto:a.schild@aarboard.ch] 
Sent: Monday, December 06, 2004 12:19 AM
To: 'POI Users List'
Subject: AW: Placing an image in xls

> How do I place an image (jpg, etc) in a cell?
> 

Actually you can't with POI.
There are currently two work arrounds:

- Use a template with the images already in them
- Create the xls file with poi, and in a second step add
  the images with jxl. http://www.andykhan.com/jexcelapi/

André


---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org


AW: Placing an image in xls

Posted by Andre Schild <a....@aarboard.ch>.
> How do I place an image (jpg, etc) in a cell?
> 

Actually you can't with POI.
There are currently two work arrounds:

- Use a template with the images already in them
- Create the xls file with poi, and in a second step add
  the images with jxl. http://www.andykhan.com/jexcelapi/

André


---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org