Can I use then Forms 6i DDE build-in package to generate 2010 EXCEL File?
Hi All,
My company' application is used Oracle FORMS 6i Solution,Client /Server environment to generated EXCEL file
I coding the PL/SQL in the Oracle FORM , it's succeed generated EXCEL file in MS office Excel 2007/2003/2000.
Now I have problem in MS office Excel 2010 , It's just open the Excel file but no data can write into excel file,
It's always raise the error exception "dde.dmlerr_no_conv_established"
some one can help me,thanks !!
my pl/sql code wrote in Button Item's trigger WHEN-BUTTON-PRESSED
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------
declare
obj ole2.obj_type;
path varchar2(256);
p_excel_path varchar2(255);
appid pls_integer;
convid pls_integer;
begin
begin
obj := ole2.create_obj('excel.application');
path := ole2.get_char_property(obj,'path');
ole2.release_obj(obj);
ole2.invoke(obj,'quit');
exception
when others then
message('office excel not found!');
return;
end;
p_excel_path := path||'\excel.exe';
synchronize;
appid := dde.app_begin(p_excel_path, dde.app_mode_normal);
dde.app_focus(appid);
convid := dde.initiate('excel','book1');
dde.poke(convid,'r1c1','abc',dde.cf_text,100000);
dde.poke(convid,'r2c2','abc',dde.cf_text,100000);
exception
when dde.dmlerr_no_conv_established then
message('dmlerr_no_conv_established');
raise form_trigger_failure;
when others then
null;
end;
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------
帖子经 Ronald Wang编辑过