Home » Developer & Programmer » Forms » OLE2 package and Excel Application (Forms 6i)
OLE2 package and Excel Application [message #278908] Tue, 06 November 2007 04:43 Go to next message
tiyise
Messages: 5
Registered: November 2007
Junior Member
Hi, I´m a problem with Group in Excel, I can group a range of cells but I can´t change the SummaryRow Property of the Outline objet to xlSummaryAbove, deafult is xlSummaryBelow.
I´m use this code for group:

Procedure Agrupar(pHoja in ole2.obj_type,
pCeldas in varchar2) is

rango ole2.obj_type;
args ole2.list_type;
vOutline Ole2.obj_type;

Begin

args:= ole2.create_arglist;
ole2.add_arg(args, pCeldas);
rango:= ole2.GET_OBJ_PROPERTY(phoja, 'Range', args);
ole2.destroy_arglist(args);

ole2.invoke(rango,'Group');

vOutline := ole2.get_obj_property(pHoja,'Outline');

args:= ole2.create_arglist;
ole2.add_arg(args,'XlSummaryAbove');

ole2.invoke(vOutline,'SummaryRow',args);
ole2.destroy_arglist(args);

ole2.release_obj(rango);
ole2.release_obj(vOutline);

End Agrupar;


Thanks
Re: OLE2 package and Excel Application [message #279538 is a reply to message #278908] Thu, 08 November 2007 23:13 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you solved your problem? Have you looked at http://www.orafaq.com/forum/t/47685/67467/

David
Previous Topic: How to send SMS ?
Next Topic: Print to excel format from Oracle Forms
Goto Forum:
  


Current Time: Thu Dec 08 22:03:12 CST 2016

Total time taken to generate the page: 0.20010 seconds