Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Convert query output to MS Excel
Try Discoverer 2000
In article <01bd59c5$763ed2e0$386710ac_at_jrinck.phcs.com>,
"A. J. Narvaez" <nnn_at_mindspring.com> wrote:
>
> I don't know of any product that will do exactly what you need. An
> alternate solution might be to produce a formatted text file in csv (comma
> seperated) format. or some other well known format.
>
> If you have the spec for the Excel file format you could always write a
> program/script to generate that format, but aside from formatting you'd
> have to contend with endian problems when converting non-ascii fields.
>
> Perhaps some reporting software like SQR supports the data format you need?
>
> Or else there may be some software to generate RTF files. Its worth seeing
> if there are any Perl modules that will generate Word or Excel format. If
> so then along with module, use Sybperl to create a script that should
> satisfy your needs.
>
> -Arthur
>
> Alexey Pushkin <A.Pushkin_at_mitsunari.matfys.lth.se> wrote in article
> <351A71FA.231EFBC1_at_mitsunari.matfys.lth.se>...
> > >
> > > >Could anyone recommend a good product for
> > > >converting query output to MS Excel and/or Word on the fly.
> > > >(For a web application).
> > > >
> > > I am not sure if this is what you want.
> > >
> > > Do you want to get the query output on the Excel or do you want it on
> > > the Web.
> >
> > What we need is that a customer sets query parameters in a web page,
> > presses "submit" and gets a ready Excel file for download. We do not
> > need HTML output.
> >
> > In fact I have already found one tool for that but if you know
> > about others it's interesting.
> >
>
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Sun Mar 29 1998 - 00:00:00 CST