Re: spool excel file with sql*plus
From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 18 May 2002 12:07:33 +0200
Message-ID: <uecb291dr48cf0_at_corp.supernews.com>
Date: Sat, 18 May 2002 12:07:33 +0200
Message-ID: <uecb291dr48cf0_at_corp.supernews.com>
csv can be automatically opened in Excel, and it is very easy to create a
csv file from sql*plus
so why on earth do you insist on creating excel files?
If you reject all the common approaches, you will end up with no solution at
all, due to your own stubborness.
Regards
-- Sybrand Bakker Senior Oracle DBA to reply remove '-verwijderdit' from my e-mail address "Bas" <b_map_at_hotmail.com> wrote in message news:ac5730$jvj$1_at_ncc1701.cistron.net...Received on Sat May 18 2002 - 12:07:33 CEST
> 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
> (in a very big company, where changes go very slow) witch other users
should
> 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
> >
>
>