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!

Can I use then Forms 6i DDE build-in package to generate 2010 EXCEL File?

RonaldWangMay 24 2011 — edited Jun 7 2011
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编辑过
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 5 2011
Added on May 24 2011
5 comments
1,692 views