> If you use tab separated columns, you can also generate formula's that look like text, but work just fine in the spreadsheet!
Didn't realize.
In any case, Perl is a much superior tool for this. The SpreadSheet::WriteExcel
module allow you to write to individual pages in a workbook.
Jared
| "Mercadante, Thomas F" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED] 01/20/2004 12:59 PM
|
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: RE: Spool to Excel File |
"SYLK allows cell references, etc, if needed, which you won't get with CSV. "
Ahh. but you can with my method! If you use tab separated columns, you can also generate formula's that look like text, but work just fine in the spreadsheet!
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 20, 2004 3:44 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Spool to Excel File
Strange, no one has mentioned OWA_SYLK.
Do a search on SYLK at asktom.oracle.com
There are 2 versions, one for web output and one for excel output.
SYLK allows cell references, etc, if needed, which you won't get with CSV.
Jared
| "Mudhalvan, Moovarkku" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 01/19/2004 08:44 PM | To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: Spool to Excel File |
Dear Friends,
I am trying to send output from SQLPlus to Excel file. If any
one did the same before please let me know.
Thank You
Mudhalvan M.M
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mudhalvan, Moovarkku
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
