You could also use the excel "web-query" functionality (search
msdn.microsoft.com for the document that explains this) which will do a http
connection to your "JSP page" and parse the table into the spreadsheet
automatically.

-----Original Message-----
From: news [mailto:news@;main.gmane.org]On Behalf Of Bill Barker
Sent: Wednesday, 13 November 2002 6:39 p.m.
To: [EMAIL PROTECTED]
Subject: Re: OFF_TOPIC: How to convert JSP page into an EXCEL format


If I was going to do this from scratch, I'd probabaly write the JSP in xml
format and use a filter (or, even, cocoon http://xml.apache.org/cocoon/) to
transform it into either HTML, or EXCEL output.  (cocoon has a serializer
based on POI http://jakarta.apache.org/poi/).

The other suggestions are probably a lot less work for you, seeing as how
you've already got your JSP page.

"Nagpal, Vikas" <[EMAIL PROTECTED]> wrote in message
news:1874CD14866CD6118DF000D0B79E84F1026D15DA@;exchange4...
> Hi EveryBody,
>
> 1) I have a JSP page which contains the TABLE. Now i want to send this
> JSP page as an  EXCEL email attachment so that as soon as people opens
> this attachment they can view there JSP page as an EXCEL worksheet. I
> have downloaded JINTEGRA.JAR from the web. I have put this package
> into my classpath. Can somebody tell me what should i do so that i can
> convert columns of my JSP page into columns of my EXCEL worksheet.
>
> 2) I have been trying to sort the elements of an array but I want to
> ignore any SPECIAL CHARACTERS that preceeds alphabets. In  most of
> these elements I have double quotes as my special charcter. How can I
> sort so as to start from alphabets.
>
> Thanks,
> With regards,
> Vikas Nagpal.





--
To unsubscribe, e-mail:
<mailto:tomcat-user-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail:
<mailto:tomcat-user-help@;jakarta.apache.org>



--
To unsubscribe, e-mail:   <mailto:tomcat-user-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <mailto:tomcat-user-help@;jakarta.apache.org>

Reply via email to