RE: Oracle Data Report to Excel Spreadsheet
- From: "Marquez, Chris" <CMarquez@xxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 10 Jan 2005 17:57:39 -0500
Been around for a long time...I have never used it;
http://www.oraxcel.com/
Bridge between Excel and all your databases=20
Chris Marquez
Oracle DBA
HEYMONitor(tm) - heymonitor.com
"Oracle Monitoring & Alerting Solution"
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jared Still
Sent: Monday, January 10, 2005 4:16 PM
To: bill.coulam@xxxxxxxx
Cc: smishra_97@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: Re: Oracle Data Report to Excel Spreadsheet
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=20
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=20
> "application/excel" for his MIME type. And he mentions the use of a=20
> custom package called owa_sylk that seems to be intended to output=20
> data in ASCII format that Excel can recongize. I saved off one of his=20
> examples and it worked semi-OK with a few errors. So you may need to=20
> update owa_sylk for later versions of Excel.
>=20
> Good thread here:=20
> =
http://asktom.oracle.com/pls/ask/f?p=3D4950:8:::::F4950_P8_DISPLAYID:769
> 425837
> 805
>=20
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx=20
> [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
>=20
> 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.
>=20
> I had seen such kind of report Long time back and so
> any idea, URL or example is of great help to me
>=20
> TIA
> Sanjay
>=20
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around=20
> http://mail.yahoo.com
> --
> //www.freelists.org/webpage/oracle-l
>=20
> --
> //www.freelists.org/webpage/oracle-l
>=20
--=20
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
