RE: Oracle Data Report to Excel Spreadsheet

  • From: "Bill Coulam" <bill.coulam@xxxxxxxx>
  • To: <smishra_97@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 10 Jan 2005 14:42:47 -0600

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/

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.

- bill c.

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Sanjay Mishra
Sent: Monday, January 10, 2005 1: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: