Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Display data in Excel format on a web page

Re: Display data in Excel format on a web page

From: Andrew Hardy <junkmail_at_[127.0.0.1>
Date: Fri, 20 Feb 2004 10:38:56 +0000
Message-ID: <c14o4j$dui$1@sun-cc204.lut.ac.uk>


Nick Li wrote:

> Hi,
>
> I have a web site which displays data generated from Oracle8i
> database(8.17) in html pages. I would like to create links on these
> pages so that when users click them, a separate page will pop up
> displaying the data in Excel format. My question is: what is the best
> way to generate Excel data from Oracle database to a web page? I am
> using OAS 4.0 and PL/SQL pages to generate the data.
>
> Thanks in advance.
>
> Nick

You could just slip a

owa_util.mime_header('application/vnd.ms-excel', TRUE);

before the htmlopen.

-- 
Andy - Opinions are mine and do not necessarily reflect those of 
Advantica Ltd
Received on Fri Feb 20 2004 - 04:38:56 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US