RE: Oracle Data Report to Excel Spreadsheet

From: Mercadante, Thomas F <thomas.mercadante_at_labor.state.ny.us>
Date: Mon, 10 Jan 2005 15:16:34 -0500
Message-ID: <C9995D8C5E0DDA4A8FF9D68EE666CE0702A97206@exchsen0a1ma>

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_at_yahoo.com] Sent: Monday, January 10, 2005 2:48 PM
To: oracle-l_at_freelists.org
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 Received on Mon Jan 10 2005 - 14:18:00 CST