OraFAQ Forum: Forms » how to reduce time in saving data to excel using forms 5i & ole2

Home » Developer & Programmer » Forms » how to reduce time in saving data to excel using forms 5i & ole2

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

how to reduce time in saving data to excel using forms 5i & ole2 [message #278172]

Fri, 02 November 2007 04:35

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);

Report message to a moderator