For really simple output for Excel then you can just dump a comma separated file from the database, set the correct mime type and let Excel sort it out - but if you want to start adding formatting and fancy stuff like frozen columns then you're gonna have to generate an XLS file.
If you're running the J2EE container on a non Windows machine then you should probably look at the Jakarta POI project (http://jakarta.apache.org/poi/)
If you're running on an Windows box (or at least can call one from the server side) then you could drive from Excel itself using something like Oracle Objects for OLE (http://www.oracle.com/technology/tech/windows/ole/index.html ). Or do things programatically using something like Dan Adler's JACOB libraries(danadler.com/jacob) which will allow you to call Excels OLE interfaces directly from your Java Code. I've used the latter a lot but you have to know Excels OLE interfaces well otherwise it can be a little frustrating
Regards
Duncan Mills Senior Principal Product Manager Oracle Application Development Tools
[EMAIL PROTECTED]
Kranti Parisa wrote:
Hi Everybody,
need some information .....
the prob goes like this...
we have a jsp page with some select boxes n all...its a search criteria.... the contects of the select boxes should be dynamically changed....
after user clicks on go button... the report has to be generated with that search criteria...
actually the prob is...
there will be a "export to excel" button...if user clicks that button ...
the generated report, based on the search criteria, should be exported as an excel file at the server end and rendered to the user..
the generated excel file should be freezed one.. means the first column should remains constant irrespective of the no of records fetched...
so that the user can see the report properly...
can u tell me some way to think for the solution .....
waiting for the reply
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
