RE: Oracle Data Report to Excel Spreadsheet

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 
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l

Other related posts: