Re: spool excel file with sql*plus

[Quoted] oraxcel is no good for me, because you need a addin for Excel. I need this to run a few batches which places a few files on a shared server [Quoted] (in a very big company, where changes go very slow) witch other users should [Quoted] open automatically in Excel.

"Daniel Morgan" <dmorgan_at_exesolutions.com> schreef in bericht news:3CE55F17.D3E7C210_at_exesolutions.com...
> Mike Alba wrote:
>
> > How about using Oracle forms?
> > Or if you want to get more fancy
> > v
> >
> > bb wrote:
> >
> > > Is there any posibility to make a spool file in the right format for
> > > Excel?
> > > Just from sql*plus. So i open a dos-batch file which opens sqlplus and
> > > runs a statement like 'select * from dual' and i'll wil get an .xls
> > > file on my C: which contains an 'X'
> > > I really need a real excel formatted file, which does not have to been
> > > imported in excel. I.e. from TOAD you can save directly to an Excel
> > > file. This is what i wanna do in a batch without using TOAD. (So, no
.csv file)
> > >
>
> I would still like someone to tell me what they are doing with Oracle data
in Excel
> that they couldn't do better in Oracle. Except, perhaps, cook the numbers.
>
> Daniel Morgan
>
Received on Sat May 18 2002 - 11:32:10 CEST