] On
Behalf Of Mark Richard
Sent: 20 January 2004 05:14
To: Multiple recipients of list ORACLE-L
Subject: Re: Spool to Excel File
Hi,
You won't be able to write an Excel format directly but you
can create a .csv file, which Excel will happily read in -
you'll just have
Mudhalvan,
I generate files that excel can open all the time. they are not actual
real excel files, but Excel can deal with them quite easily.
Here is a tablespace report I run every week. Note the use of the CHR(9)'s.
This is a TAB character. This forces each column into a new cell in the
If you're keen on Perl, the Spreadsheet-WriteExcel module is very handy:
http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel-0.42/
With that you could slurp data out via DBI, and then build a customized spreadsheet
based on the data.
But I'd agree with what others have said. Dumping to
[EMAIL PROTECTED]
c.com cc:
Sent by: Subject: Re: Spool to Excel File
]
c.com cc:
Sent by: Subject: Re: Spool to
Excel File
[EMAIL PROTECTED]
.com
01/20/2004
PROTECTED]
01/19/2004 08:44 PM
Please respond to ORACLE-L
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
"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
Mercadante, Thomas F [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/20/2004 12:59 PM
Please respond to ORACLE-L
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
] [mailto:[EMAIL PROTECTED] Sent:
Wednesday, January 21, 2004 8:29 AMTo: Multiple recipients of list
ORACLE-LSubject: RE: Spool to Excel
File 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
Hi Thomas-
Pretty interested in your method!! I tried it out but I guess I have to
create the WTW_JOB_NOTIFY table and populate it and I can't figure where the
mail notification is used. Assit with the table structure and an explanation
on how this table is used.
Thanks and Cheers,
CSW Simon.
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
:
apan.co.jp Subject: Spool to Excel File
Sent
PRANK
Try with
spool c:\Program*Files\Microsoft*Office\Office\excel.exe
/PRANK
On 2004.01.19 23:44, Mudhalvan, Moovarkku wrote:
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
--
Hi,
Years ago, I stole this idea from:
http://www.quest-pipelines.com/newsletter-v3/newsletter_1002.htm
I've used it a few times, mostly to impress
bystanders. It's got size limitations, but kinda cool
anyhow.
QUOTE
Getting SQL Query Results into an Excel Spread Sheet
By Pavel Luzanov
This
14 matches
Mail list logo