Home » Developer & Programmer » Forms » Exporting the data from forms 10g to an excel sheet in Symbolic Link (SYLK) format.
Exporting the data from forms 10g to an excel sheet in Symbolic Link (SYLK) format. [message #385996] Thu, 12 February 2009 03:17 Go to next message
SUHAS22845
Messages: 51
Registered: August 2008
Location: BANGALORE
Member

Hi friends,

I am trying this thing from around 2 weeks and am yet to find out the solution for this.

Guru's Please help me in getting a solution for this.

I have a list of records displayed in my form (From one table.) Now i have to transfer these records to an excel sheet with SYLK format. ie, create a new excel sheet at some location, open it and write the records to that excel sheet. All these should happen in when button pressed event.
And the code should work fine even in client systems. Kindly Kindly Please help me getting through this. Embarassed Embarassed
Re: Exporting the data from forms 10g to an excel sheet in Symbolic Link (SYLK) format. [message #386500 is a reply to message #385996] Sun, 15 February 2009 22:54 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Please find below a list of useful Excel threads:
Working with Excel via OLE2
http://www.orafaq.com/forum/t/72811/67467/
http://www.orafaq.com/forum/m/84230/67467/
http://www.orafaq.com/forum/t/101906/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
Excel via DDE
http://www.orafaq.com/forum/m/260061/67467/#msg_260061
Import from Excel
http://www.orafaq.com/forum/mv/msg/32353/86299/67467/#msg_86299
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/
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/
Worked example for using Excel through ODBC
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:4406709207206#18830681837358
create excel chart in form6I/How to SetSourceData into excel.chart in form6i
http://www.orafaq.com/forum/t/99738/67467/
Call Excel file from Forms
http://www.orafaq.com/forum/t/121433/67467/
Sample test form.
http://www.orafaq.com/forum/t/139253/67467/

David
Previous Topic: how to insert picture from form 10g in database
Next Topic: hyperlink style selection in forms 6i
Goto Forum:
  


Current Time: Fri Dec 09 12:01:53 CST 2016

Total time taken to generate the page: 0.11987 seconds