Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle to excel at server side
I'm not too sure what your restrictions are (you have another thread
asking about doing the same thing in Forms 6i).
If you can live with Oracle to Excel only (rather than Excel to Oracle)
and using Reports 6i instead of Forms 6i,you can use the following URL
segment to make the data automatically appear in a new Excel document
/cgi-bin/rwcgi60.exe?server=pubsvr
&report=emp.rdf &destype=cache &desformat=delimited &mimetype=application/vnd.ms-excel &userid=scott/tiger_at_nt805
You get all sorts of crap in the spreadsheet unless the report is coded to not display any boiler plate when displaying delimited format.
application/msaccess (desformat=delimited delimited_hdr={YES|NO}) application/vnd.ms-excel (desformat=delimited delimited_hdr={YES|NO} )
You can also get formatted data in Word and Acrobat
application/msword (desformat=rtf)
application/pdf (desformat=pdf)
Metalink Doc ID: Note:118225.1
Subject: Automatically Launch Excel Running Delimited Report Output
Using Web CGI
Ada wrote:
> Hi,
>
> I want to place Oracle data in an excel worksheet through programming
> at Solaris (server side). Has anyone a solution for this?
>
> Thanks for your help.
>
> Ada
>
Received on Fri Mar 29 2002 - 22:51:42 CST