Home » Developer & Programmer » Forms » how to reduce time in saving data to excel using forms 5i & ole2
how to reduce time in saving data to excel using forms 5i & ole2 [message #278172] Fri, 02 November 2007 04:35 Go to next message
vijayendra.k
Messages: 11
Registered: August 2006
Junior Member
hi,
i am using forms 5i, i used OLE2 to save the data into excel file.its working fine but its talking much time if number of records are more,is there any posibility to save the data instantly into excel file as like the one we do in toad using 'xls.instance'.
in toad huge no. of records can be saved within less time, using xls instance option, can this method be implemented in forms 5i,if so how it can be implemented

i have currently used the below method :

args:=OLE2.CREATE_ARGLIST;
OLE2.ADD_ARG(args, 4);
oLE2.ADD_ARG(args, 2);
cell:=ole2.get_obj_property(worksheet, 'Cells', args);
OLE2.DESTROY_ARGLIST(args);
OLE2.SET_PROPERTY(cell, 'Value', 'column_name');
ole2.release_obj(cell);
Re: how to reduce time in saving data to excel using forms 5i & ole2 [message #279517 is a reply to message #278172] Thu, 08 November 2007 19:18 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have a look at the following:
Working with Excel via OLE2
http://www.orafaq.com/forum/t/72811/67467/
http://www.orafaq.com/forum/m/84230/67467/
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/

David
Previous Topic: Call html Page from Forms
Next Topic: forms
Goto Forum:
  


Current Time: Sat Dec 03 15:53:46 CST 2016

Total time taken to generate the page: 0.05431 seconds