Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Spool to Excel File

RE: Spool to Excel File

From: Mercadante, Thomas F <thomas.mercadante_at_labor.state.ny.us>
Date: Tue, 20 Jan 2004 12:59:43 -0800
Message-ID: <F001.005DDAD0.20040120125943@fatcity.com>








"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: Mercadante, Thomas F
  INET: thomas.mercadante_at_labor.state.ny.us

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 - 14:59:43 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US