OraFAQ Forum: Forms » Export data from Form 6 to Excel

Home » Developer & Programmer » Forms » Export data from Form 6 to Excel

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Export data from Form 6 to Excel [message #229958]

Tue, 10 April 2007 07:21

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

Report message to a moderator

Re: Export data from Form 6 to Excel [message #229987 is a reply to message #229958]

Tue, 10 April 2007 08:36

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

Report message to a moderator

Re: Export data from Form 6 to Excel [message #230101 is a reply to message #229987]

Tue, 10 April 2007 20:56

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 05 13:44:27 CST 2024