Home » Developer & Programmer » Forms » Database package for excel conversion (10g)
Database package for excel conversion [message #288306] Mon, 17 December 2007 00:47 Go to next message
ganesh_jadhav0509
Messages: 63
Registered: May 2007
Location: Chester
Member

Dear All,

I m using 10g database.

I want to build the package / Prodedure for exporting data to excel.

Can anyone help me how can i do this.

Regards,

Ganesh Jadhav.
Re: Database package for excel conversion [message #288316 is a reply to message #288306] Mon, 17 December 2007 01:12 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
I know I'd be repeating myself but I've used OWA_SYLK in past projects. It's not 100% Excel, but Excel can read it and you have the option to format your data.

MHE
Re: Database package for excel conversion [message #289134 is a reply to message #288306] Wed, 19 December 2007 18:58 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Here's the list:
Worked example for using Excel through ODBC
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:4406709207206#18830681837358

Excel via DDE
http://www.orafaq.com/forum/m/260061/67467/#msg_260061

Working with Excel via OLE2
http://www.orafaq.com/forum/t/72811/67467/
http://www.orafaq.com/forum/m/84230/67467/
Merge two cells in Excel using ole2
http://www.orafaq.com/forum/t/77825/67467/
Error closing Excel file generated using OLE2
http://www.orafaq.com/forum/t/77351/67467/
How to wrap text in excel cell using ole2
http://forums.oracle.com/forums/thread.jspa;jsessionid=8d92200830d62336f40f5aad44efb36ee981f4e6c19e.e34QbhuKaxmMai0MaNeMb3eKb390?mess ageID=1242535&#1242535
Forms to Excel example with webutil
http://forums.oracle.com/forums/thread.jspa?messageID=1430799
Another Forms to Excel example
http://www.orafaq.com/forum/t/81537/67467/
http://www.orafaq.com/forum/t/32353/67467/
How to kill EXCEL.exe from Task Manager from Oracle Forms
http://www.orafaq.com/forum/t/88643/67467/
how do i display all excel worksheets name in form
http://www.orafaq.com/forum/t/89775/67467/
More Excel stuff
http://www.orafaq.com/forum/t/90502/67467/
To run an excel macro
http://www.orafaq.com/forum/t/47685/67467/

David
Previous Topic: Strange Problem in Forms 6i
Next Topic: not dispalying the icons while running
Goto Forum:
  


Current Time: Sat Dec 03 00:48:33 CST 2016

Total time taken to generate the page: 0.10465 seconds