| 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 |
