Re: Developer 2000 Web - Launching Excel

shay wrote:
> When you run Forms in Web architecture calls to DDE and OLE2 will be
> executed on the server. This might still work for you if you are on a
> windows server.
> However there are also solution to invoke excel on the client when
> running on the Web with OLE and Java to OLE bridge.
> Check out the OLE on the Web paper on the forms upgrade center here
> (the news section on the right):
> http://otn.oracle.com/products/forms/htdocs/upgrade

This approach does not need to be running on a windows server. It uses the MIME type application/vnd.ms-excel and a delimited file that Excel can open automatically.

I used Developer Reports to create and display the delimited file the but you could used the SHOW_URL function.

See this Oracle problem report

Subject: Automatically Launch Excel Running Delimited Report Output Using Web CGI Doc ID: Note:118225.1
Type: PROBLEM
Status: PUBLISHED
  Content Type: TEXT/PLAIN
Creation Date: 24-AUG-2000
Last Revision Date: 27-NOV-2000

/* SRT
These mime types also work:

        application/msaccess (desformat=delimited delimited_hdr={YES|NO} )

	application/msword (desformat=rtf)
	application/vnd.ms-excel (desformat=delimited
delimited_hdr={YES|NO} )
	application/pdf (desformat=pdf)

These not tried:
	application/x-msexcel (desformat=delimited
delimited_hdr={YES|NO} )
	application/x-mspowerpoint

When running a web report to delimited output, you would like to have Excel,
Word, etc. launch automatically.

SOLUTION DESCRIPTION:

Bug 1105701 was filed to ask for this ability. As of Reports 6i patch 1

(6.0.8.10.1), there is a new CGI command line parameter "mimetype" to safisfy
this requirement.

Per the bug:

Users will be responsible to set desformat=delimited with correct mimetype for
their report output.

For example:  

/cgi-bin/rwcgi60.exe?server=pubsvr&report=emp.rdf&destype=cache&desformat=delimited&mimetype=application/vnd.ms-excel&userid=scott/tiger _at_nt805

Reports CGI/Cartridge will set the mimetype based on the value the user provides.

REFERENCES:

Bug:1105701 Received on Thu Jan 16 2003 - 22:37:22 CET