Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How Using dde.app_begin on linux path?

783329Jan 7 2011 — edited Jan 11 2011
Below function
Appid := dde.app_begin('C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE E:\Oracle\names.xls',dde.app_mode_minimized);
for call path excel program on window if I compile on linux has error command dde.app_begin
how to set path from window 'C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE E:\Oracle\names.xls' as linux path?????


thank you


PROCEDURE get_from_xls IS

CONVID PLS_INTEGER;

APPID PLS_INTEGER;

i number;

x number;

v_name VARCHAR2(100);

v_NO number;


OUT_FILR TEXT_IO.FILE_TYPE;

BEGIN synchronize;



Appid := dde.app_begin('C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE E:\Oracle\names.xls',dde.app_mode_minimized);



dde.app_focus(appid);

convid := dde.initiate('EXCEL','names.xls');



x := 0;



FOR I IN 2..558 loop



dde.request(convid,'R' || to_char(i) ||'C1',v_name,dde.cf_text,558);

dde.request(convid,'R' || to_char(i) ||'C2',v_no,dde.cf_text,558);


/*

if substr(v_NAME,1,length(v_NAME)-2) is null then exit;

end if;
*/



insert into ex1( name,

id)

VALUES(
v_name,
v_no);



x:= x + 1;

end loop;

COMMIT;

dde.terminate(convid);

dde.app_end(appid);



END;

Edited by: user7657179 on 7 ม.ค. 2554, 2:00 น.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 8 2011
Added on Jan 7 2011
7 comments
324 views