OraFAQ Forum: Forms » how to set the height for row in excel via ole2

Home » Developer & Programmer » Forms » how to set the height for row in excel via ole2 (forms 6i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to set the height for row in excel via ole2 [message #395593]

Wed, 01 April 2009 23:48

mm_kanish05
Messages: 493
Registered: January 2007
Location: Chennai

Senior Member

Hi
I want to set row Height programatically using ole2.

i use this code that not giving any effect. please help me what is the problem.

  Arg := ole2.create_arglist;
  	   ole2.add_arg(Arg,1);
  	   rrow := ole2.get_obj_property(WorkSheet,'Rows',Arg);
  	   ole2.destroy_arglist(arg);
  	   ole2.set_property(rrow,'Height',50);

kanish

[Updated on: Wed, 01 April 2009 23:51]

Report message to a moderator

Re: how to set the height for row in excel via ole2 [message #395623 is a reply to message #395593]

Thu, 02 April 2009 01:47

mm_kanish05
Messages: 493
Registered: January 2007
Location: Chennai

Senior Member

Hi
Solved

      	   ole2.set_property(rrow,'RowHeight',50);

kanish

[Updated on: Thu, 02 April 2009 01:47]

Report message to a moderator

Re: how to set the height for row in excel via ole2 [message #395879 is a reply to message #395623]

Thu, 02 April 2009 23:56

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Thanks for the feedback.

David

Report message to a moderator

Previous Topic:	Reference Type from database to filesystem
Next Topic:	win_api_utility procedure

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Sep 23 04:38:30 CDT 2025