Re: Oracle Data Report to Excel Spreadsheet

  • From: Jared Still <jkstill@xxxxxxxxx>
  • To: bill.coulam@xxxxxxxx
  • Date: Mon, 10 Jan 2005 13:16:02 -0800

Ugh. owa_sylk is very limited.

If you know how to use Perl, use the Spreadsheet::WriteExcel
module in concert with DBI, as it will allow you to create complete 
Excel spreadsheets that do not need further formatting.



On Mon, 10 Jan 2005 14:50:34 -0600, Bill Coulam <bill.coulam@xxxxxxxx> wrote:
> 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@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
> 
> TIA
> Sanjay
> 
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
> --
> //www.freelists.org/webpage/oracle-l
> 
> --
> //www.freelists.org/webpage/oracle-l
> 


-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
//www.freelists.org/webpage/oracle-l

Other related posts: