How Using dde.app_begin on linux path?
783329Jan 7 2011 — edited Jan 11 2011Below 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 น.