RE: Oracle Data Report to Excel Spreadsheet
- From: "Mercadante, Thomas F" <thomas.mercadante@xxxxxxxxxxxxxxxxx>
- To: "'smishra_97@xxxxxxxxx'" <smishra_97@xxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
- Date: Mon, 10 Jan 2005 15:16:34 -0500
Sanjay,
A very simple way of doing this is to create a tab delimited report (chr(9)
between each column) and spool a .xls data file within SqlPlus. This
creates and excel-like file that can be opened directly by Excel.
I do this all the time and it works fine. It's not fancy, but it always
works.
Good Luck.
Tom
-----Original Message-----
From: Sanjay Mishra [mailto:smishra_97@xxxxxxxxx]
Sent: Monday, January 10, 2005 2:48 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Oracle Data Report to Excel Spreadsheet
I had Oracle 9i database and need to convert several
reports to Excel Spreadsheet. Is there any procedure
that can help. I am planning to use Orace 9iAS Mod
Plsql to provide direct report to Excel Spread sheet
by call Excel and spreading the data in Columns.
I had seen such kind of report Long time back and so
any idea, URL or example is of great help to me
TIA
Sanjay
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
