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


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

Good Luck.


-----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 


Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 

Other related posts: