| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle Data Report to Excel Spreadsheet
Checking some of my facts, found that Mr. Kyte uses "application/excel" for
his MIME type. And he mentions the use of a custom package called owa_sylk
that seems to be intended to output data in ASCII format that Excel can
recongize. I saved off one of his examples and it worked semi-OK with a few
errors. So you may need to update owa_sylk for later versions of Excel.
Good thread here:
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:769425837
805
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Sanjay Mishra
Sent: Monday, January 10, 2005 1: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
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jan 10 2005 - 14:49:51 CST
 |
 |