File Exchange
Try Origin for Free
The Origin Forum
Home
|
Profile
|
Register
|
Active Topics
|
Members
|
Search
|
FAQ
|
Send File to Tech support
Username:
Password:
Save Password
Forgot your Password?
|
Admin Options
All Forums
Origin Forum
Origin Forum
How to set column as x or y
New Topic
Reply to Topic
Printer Friendly
Author
Topic
country_road
USA
7 Posts
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
larry_lan
China
Posts
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
country_road
USA
7 Posts
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
China
Posts
Posted - 08/16/2010 : 5:35:59 PM
How about using
range variable
:
range rr = !col(b);
rr.type = 4;
Larry
country_road
USA
7 Posts
Posted - 08/16/2010 : 5:46:58 PM
It works again.
Thanks.
Topic
New Topic
Reply to Topic
Printer Friendly
Jump To:
Select Forum
Origin Forum
Origin Viewer Forum
Origin Forum
Origin Forum for Programming
Forum for Python
LabTalk Forum
Forum for Origin C
Forum for Automation Server/COM and LabVIEW
Origin中文论坛
Origin 中文论坛 (Chinese Origin Forum)
Japanese Origin Forum
Origin日本語フォーラム (Japanese Origin Forum)
Origin on Linux
The Origin on Linux Forum
Private Forums
Distributor Forum
--------------------
Home
Active Topics
Frequently Asked Questions
Member Information
Search Page
The Origin Forum
© 2020 Originlab Corporation
Snitz Forums 2000