| 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
My sample code is at home. Not sure I can find it. Haven't had to do this
since '97.
As I recall, you have to manipulate the HTTP header, using owa_util.mime_header and close_header or something like that. You specify the MIME type as application/vnd.ms-excel.
The you output text with commas or tabs using htp/htf. I never toyed with Excel's binary format to see if I could interface with that. Probably not. Perhaps with the latest Excel versions you can output XML that Excel can recognize and display.
Hope that gives you a few more keywords to go off of.
-----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:41:14 CST
 |
 |