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:50:34 -0600

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:

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