T O P I C R E V I E W |
country_road |
Posted - 08/16/2010 : 2:27:42 PM Origin Ver8.1. and SP3 (Select Help-->About Origin): Hi,
How to set any(one) column as X (or Y)? Let's say I try to set Book1, sheet1, column D as x and column E ax Y. How can I do it by script?
Thanks,
Steve |
4 L A T E S T R E P L I E S (Newest First) |
country_road |
Posted - 08/16/2010 : 5:46:58 PM It works again.
Thanks. |
larry_lan |
Posted - 08/16/2010 : 5:35:59 PM How about using range variable:
range rr = !col(b); rr.type = 4;
Larry |
country_road |
Posted - 08/16/2010 : 4:40:40 PM Thank you so much Larry. It works.
Is there any way that I can use column name (like column D) rather than the column index? There are too many columns (hundreds of), and some times I have difficulty to figure out the column index.
Thanks again,
Steve |
larry_lan |
Posted - 08/16/2010 : 4:11:06 PM Use the Wks.col object.
wks.coln.type = 4; // Set as X wks.coln.type = 1; // Set as Y
where n is the index of column.
Thanks Larry OriginLab Technical Services |