Hi, Checkout following link
http://jakarta.apache.org/poi/index.html POI is supposed to have capability to write files in Excel 97 format. Kailash -----Original Message----- From: Kranti Parisa [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 28, 2004 2:55 PM To: Struts Users Mailing List Subject: Re: Need Help: exporting oracle database records to excel files Hi Paul, Thanq very much for ur reply... Its exporting to excel.. but in our application we need to generate a seperate excel file for the records...and how to obtain the freezing properties for the generated excel file Thanq Kranti On Tue, 28 Sep 2004 10:14:18 +0100, Paul McCulloch <[EMAIL PROTECTED]> wrote: > http://www.displaytag.org/example-export.jsp > > Paul > > > > > -----Original Message----- > > From: Kranti Parisa [mailto:[EMAIL PROTECTED] > > Sent: Tuesday, September 28, 2004 9:56 AM > > To: [EMAIL PROTECTED] > > Subject: Need Help: exporting oracle database records to excel files > > > > > > Hi eveybody, > > > > 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 serach 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 anynody tell me some way to think for the solution ..... > > > > waiting for the reply > > > > > > -- > > -- > > Kranti Kiran Kumar Parisa > > Software Engineer [ e-Biz ], > > Patni Computer Systems Ltd., > > India > > Mobile: +91 98504 45977 > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > ********************************************************************** > Axios Email Confidentiality Footer > Privileged/Confidential Information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message, and notify us immediately. If you or your employer does not consent to Internet email messages of this kind, please advise us immediately. Opinions, conclusions and other information expressed in this message are not given or endorsed by my Company or employer unless otherwise indicated by an authorised representative independent of this message. > WARNING: > While Axios Systems Ltd takes steps to prevent computer viruses from being transmitted via electronic mail attachments we cannot guarantee that attachments do not contain computer virus code. You are therefore strongly advised to undertake anti virus checks prior to accessing the attachment to this electronic mail. Axios Systems Ltd grants no warranties regarding performance use or quality of any attachment and undertakes no liability for loss or damage howsoever caused. > ********************************************************************** > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > -- -- Kranti Kiran Kumar Parisa Software Engineer [ e-Biz ], Patni Computer Systems Ltd., India Mobile: +91 98504 45977 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] "Quinnox is an Award Winning IT services organisation, accredited to CMM Level 5. We are successfully delivering Application Development, Integration, Support and Testing services to clients in the Finance, Manufacturing, Retail and Telecom sectors. Particular focus areas include e-Business and ERP (notably SAP) solutions." --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
