Home » Developer & Programmer » Reports & Discoverer » Is there any COM component for export data from Oracle reports to EXCEL
Is there any COM component for export data from Oracle reports to EXCEL [message #88130] Mon, 01 April 2002 21:36 Go to next message
Ravi
Messages: 251
Registered: June 1998
Senior Member
Hi,
Is there any existing COM component to export data from Oracle reports to Excel.

regards
Ravi.
Re: Is there any COM component for export data from Oracle reports to EXCEL [message #88138 is a reply to message #88130] Sun, 07 April 2002 23:04 Go to previous message
Ayan
Messages: 11
Registered: February 2002
Junior Member
To take report output to excell is very easy. Add a local printer into your system. Select any generic printer like epson fx 100 +. When it asks for port, select "FILE: create a file on disk". When report output is obtained, select file print and then select this printer name. It will generate a text file. Open this file in excell with whatever delimiter and the report output is there in excell. For getting proper output use | in order to separate columns in report.

Hope this will help
Ayan
Previous Topic: Java code to execute rwrun60 or rwcli60
Next Topic: Re: How To Open .Eps file which is send as an attachment when you select mail option of the generate
Goto Forum:
  


Current Time: Tue May 28 02:41:53 CDT 2024