Home » Developer & Programmer » Forms » Export data from Form 6 to Excel
Export data from Form 6 to Excel [message #229958] Tue, 10 April 2007 07:21 Go to next message
shakti_goyal
Messages: 60
Registered: November 2006
Location: India
Member


Hello all,
I am using Form 6.0 ..
I want to export data of a block should go directly
to the Excel....
When user query the form after giving some input
parameter, the block data should do in Excel file.
I am not creating an Oracle Application Standard Form..
I am asking about simple form..

Regards
Shakti



Re: Export data from Form 6 to Excel [message #229987 is a reply to message #229958] Tue, 10 April 2007 08:36 Go to previous messageGo to next message
dewildeh
Messages: 3
Registered: February 2007
Junior Member
Hi Shakti,

Use this link to find the answers someone else already gave:

http://forums.oracle.com/forums/thread.jspa?messageID=1430799

I suppose you will not have access to Webutil/Client_OLE2 if you are running Client/Server, but in that case it should be possible to use its predecessor Forms Built-in, OLE2, in a similar way.

Look under 'Predefined Packages' in the Navigator Pane.

Happy Coding!

Hendrik
Re: Export data from Form 6 to Excel [message #230101 is a reply to message #229987] Tue, 10 April 2007 20:56 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have a look at the following links:
Worked example for using Excel through ODBC
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:4406709207206#18830681837358
Working with Excel via OLE2
http://www.orafaq.com/forum/t/72811/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?messageID=1242535&#1242535

David
Previous Topic: How to change the initial value of a radio group at runtime (Merged)
Next Topic: LOV & Record Group
Goto Forum:
  


Current Time: Sat Dec 10 05:08:53 CST 2016

Total time taken to generate the page: 0.08870 seconds