Re: Oracle Web Server 3.0 and mime types to invoke Excel

I'm interested in the same thing. Our users want reports in Excel. We also have Developer 2000.

We were planning to use Reports to generate a CSV file in Reports 6, but the GA version has been delayed and won't meet our delivery date. We were planning on adding a header to each report that identifies a VB macro that will format this report. We'd supply to users a 'helper' application that would open the data, retrieve & execute the VB code from a replicated Notes database, and launch excel. There's got to be a better way!

We want to minimize the number of components the user needs installed on the desktop, yet they want to view reports off line (minimal connection to email or otherwise replicate report to desktop is understood). Basically, we want to ship them the excel application and data in one swoop. We need the ability to fully format the data (eg. headers, grouping with outline summary vs. drill down data,...).

If you've accomplished this for your users, I'd love to ask you some more questions!

kij wrote:
>
> Hello,
>
> We are running Oracle Web Server 3.0 on a HP mini. We would like to
> know how to get a plsql procedure to send the appropriate mime header
> followed by data in csv format and then get the browser to run a
> specific Excel worksheet with the data.
>
> Eg
> 1.User invokes plsql procedure using browser
> 2.Data arrives from Web Server mime-header followed by data in csv
> format
> 3. Browser runs Excel application abc.xls with csv data.
>
> The questions are what would be the syntax of the plsql procedure ie
> use owa_util.mime_header etc.
>
> How should the browser have the mime-header configured to the Excel
> worksheet
>
> Thanks
> Kim
Received on Wed Jan 20 1999 - 18:09:33 CET