Home » Developer & Programmer » Reports & Discoverer » Need alternative method to export data from Oracle To Excel (Reports 6i)
Need alternative method to export data from Oracle To Excel [message #310056] Mon, 31 March 2008 01:59 Go to next message
mustaf_82
Messages: 20
Registered: May 2007
Location: UAE
Junior Member

Hello

I want an alternative method to export the data from oracle to excel file rather transferring from OLE.
The problem which I faced in using OLE in exporting the data was of Excel Version. I developed a report which was exporting data to Excel 2003 but if the user is using Excel 2007 which causes the failure.
Appreciate responce of you ppl as soon as possible.

Thanks.

Note: Delimated is not the other option as I want to create a formatted excel file in colors and fonts.
Re: Need alternative method to export data from Oracle To Excel [message #310151 is a reply to message #310056] Mon, 31 March 2008 07:26 Go to previous messageGo to next message
dillango
Messages: 145
Registered: January 2008
Senior Member
Can you attach the sample created for Excel 2003?

Ilango

Re: Need alternative method to export data from Oracle To Excel [message #310153 is a reply to message #310056] Mon, 31 March 2008 07:27 Go to previous message
dillango
Messages: 145
Registered: January 2008
Senior Member
Did you tried using Rep2xls tool?

Ilango
Previous Topic: Referencing column from lower group
Next Topic: Exect Fetch
Goto Forum:
  


Current Time: Thu Dec 08 08:33:52 CST 2016

Total time taken to generate the page: 0.09142 seconds