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
Messages: 60
Registered: November 2006
Location: India

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..


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
Messages: 3
Registered: February 2007
Junior Member
Hi Shakti,

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


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!

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
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
Working with Excel via OLE2
Merge two cells in Excel using ole2
Error closing Excel file generated using OLE2
How to wrap text in excel cell using ole2

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

Current Time: Mon Oct 24 21:22:37 CDT 2016

Total time taken to generate the page: 0.13528 seconds