Message
Thank
you so much for all your response...
To
solve this issue temporarily... I used SYLK.... But i was planning to go for
Perl. Since i am begineer in Perl hope i need to study a bit..
Thank
You
Mudhalvan M.M
> 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"
<thomas.mercadante@labor.state.ny.us>
Sent by: ml-errors@fatcity.com
01/20/2004 12:59 PM
Please respond to ORACLE-L
|
To:
Multiple recipients of list ORACLE-L
<ORACLE-L@fatcity.com>
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:
Jared.Still@radisys.com [mailto:Jared.Still@radisys.com]
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"
<mmudhalvan@gcrejapan.co.jp>
Sent by: ml-errors@fatcity.com
01/19/2004 08:44 PM
Please respond to
ORACLE-L
|
To:
Multiple recipients of list ORACLE-L
<ORACLE-L@fatcity.com>
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:
mmudhalvan@gcrejapan.co.jp
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:
ListGuru@fatcity.com (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mudhalvan, Moovarkku
INET: mmudhalvan_at_gcrejapan.co.jp
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: ListGuru_at_fatcity.com (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).
Received on Tue Jan 20 2004 - 18:54:30 CST
