You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@struts.apache.org by shankarr <sh...@adventnet.com> on 2004/02/04 11:21:14 UTC

RE: How to export the html table contents (records) to an Excel file - Are there are any POI jar from jakarta to be downloaded?.

Hi!
Yes, you need to download the following and use the jar file present.
http://nagoya.apache.org/poi/news/

This is the link for the 2.0 version.
Use the jakarta-poi-1.5.1-final-20020615.jar jar .
Put in WEB-INF/lib folder of your webapp.

Richie

At 03:31 PM 2/4/2004 +0530, you wrote:

>hi,
>
>are there any .jar files for using jakarta-poi, that need to be placed in lib
>folder?
>
>thanks and regards,
>s.srikanth
>
>
>
>
> 
>
>                       "Jesse Alexander 
> (KAID
>                       11)" 
>                To:  "'Struts Users
>                       <alexander.jesse@credit-         Mailing List'" 
> <St...@Jakarta.Apache.Org>
>                       suisse.com>                     cc: 
>
>                                                       Subject:  RE: How 
> to export the html table contents
>                       02/04/2004 02:41 PM              (records) to an 
> Excel f ile.
>                       Please respond 
> to
>                       "Struts Users 
> Mailing
>                       List" 
>
> 
>
> 
>
> 
>
> 
>
>
>
>
>
>Hi,
>
>three choices:
>
>- export the stuff to a CSV (comma separated value) file. Excelt usually
>   reads that stuff perfectly
>   - do not need any further libraries
>   - does not support formatting of the data from the server side
>- use POI (<http://jakarta.apache.org/poi/>)
>   - exports real excel-files
>- use OpenOffice
>   - allows to export as excel
>   - needs a X-Server on the server
>   - needs special care (not all methods are thread save)
>
>hth
>Alexander
>
>-----Original Message-----
>From: ssrinivasrao@worldbank.org [mailto:ssrinivasrao@worldbank.org]
>Sent: Mittwoch, 4. Februar 2004 10:07
>To: Struts-User@jakarta.apache.org
>Subject: How to export the html table contents (records) to an Excel
>file.
>
>
>Hi,
>
>I have webpage (.jsp) which lists out 4 to 5 records (having say 4 to 5 
>columns)
>inside html table tag.  This page, has an "Export" button, at the bottom.  On
>click of this button, I need to export the records (that the current page is
>displaying) to an .xls (Excel format) file.
>
>Shall be greatful if anyone can tip me on this.
>
>Thanks,
>S.Srikanth
>
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: struts-user-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: struts-user-help@jakarta.apache.org
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: struts-user-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: struts-user-help@jakarta.apache.org
>
>
>
>
>
>
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: struts-user-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: struts-user-help@jakarta.apache.org

"To achieve all that is possible, one must attempt the impossible"


Re: Displaying properties in a nested iterator

Posted by Michael Wiles <mw...@pnp.co.za>.
the class for the contents of the nested form was not public!

On Wed, 2004-02-04 at 12:35, Michael Wiles wrote:
> How do nest iterators?
> 
> An exert from my jsp...
> 
> <logic:iterate property="orders" name="allocationOrder"
> 		id="element">
> ..
> ..
> do stuff with element
> ..
> ..
> 	<logic:iterate property="orderDetails" name="element" id="subElement">
> 	..
> 	..
> 	do with with subElement
> 	..
> 	</logic:iterator>
> ..
> </logic:iterate>
> 
> The problem is that although the _number_ of elements in the nested
> iterator is correct, if I try and do
> 
> 	<bean:write name="subElement" property="orderNo"/>
> 
> I get a "No getter method for property orderNoof bean subElement" exception.
> 
> I noticed that there is a "nested" tag library, and I've tried to utilise this, but with no success.
> 
> How do you successfully nest iterators and display properties in the nested iterator?
> I don't want to use a scriptlet.
> 
> 
> 
> Read our disclaimer at: http://www.picknpay.co.za/email-disclaimer.htm
> If you don't have web access, the disclaimer can be mailed to you on request.
> Disclaimer requests to be sent to it-security@pnp.co.za
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: struts-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: struts-user-help@jakarta.apache.org
> 
> 
> Read our disclaimer at: http://www.picknpay.co.za/email-disclaimer.htm
> If you don't have web access, the disclaimer can be mailed to you on request.
> Disclaimer requests to be sent to it-security@pnp.co.za
-- 
Michael Wiles <mw...@pnp.co.za>
Pick 'n Pay IS - 1665


Read our disclaimer at: http://www.picknpay.co.za/email-disclaimer.htm
If you don't have web access, the disclaimer can be mailed to you on request.
Disclaimer requests to be sent to it-security@pnp.co.za

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


Displaying properties in a nested iterator

Posted by Michael Wiles <mw...@pnp.co.za>.
How do nest iterators?

An exert from my jsp...

<logic:iterate property="orders" name="allocationOrder"
		id="element">
..
..
do stuff with element
..
..
	<logic:iterate property="orderDetails" name="element" id="subElement">
	..
	..
	do with with subElement
	..
	</logic:iterator>
..
</logic:iterate>

The problem is that although the _number_ of elements in the nested
iterator is correct, if I try and do

	<bean:write name="subElement" property="orderNo"/>

I get a "No getter method for property orderNoof bean subElement" exception.

I noticed that there is a "nested" tag library, and I've tried to utilise this, but with no success.

How do you successfully nest iterators and display properties in the nested iterator?
I don't want to use a scriptlet.



Read our disclaimer at: http://www.picknpay.co.za/email-disclaimer.htm
If you don't have web access, the disclaimer can be mailed to you on request.
Disclaimer requests to be sent to it-security@pnp.co.za

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