Home » Developer & Programmer » Forms » how to set the height for row in excel via ole2 (forms 6i)
how to set the height for row in excel via ole2 [message #395593] Wed, 01 April 2009 23:48 Go to next message
mm_kanish05
Messages: 487
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 Go to previous messageGo to next message
mm_kanish05
Messages: 487
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 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Thanks for the feedback.

David
Previous Topic: Master Detail Form
Next Topic: oracle 10g import
Goto Forum:
  


Current Time: Mon Aug 21 20:53:03 CDT 2017

Total time taken to generate the page: 0.13285 seconds