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: Canberra ACT Australia
Senior Member
Account Moderator
Thanks for the feedback.

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


Current Time: Sat Dec 03 12:19:09 CST 2016

Total time taken to generate the page: 0.27749 seconds