The Origin Forum
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 for Programming
 LabTalk Forum
 change specific column for every book and sheet		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

BMG92

Germany
2 Posts
Posted - 05/03/2019 :  10:59:33 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Hello OriginLab community,

im currently working on rearranging a project from my supervisor, containing various books and sheets. I am expected to give them a uniform layout in order to make it easier to find and access specific data.
One task is to change the value of specific columns in most of the sheets (those columns all have the same name and should have a maximum value less than 1). I need to multiply them all by a certain value.

My question: can i access them all at once or do i have to access them one by one?

Kind regards
Behrus M. Gh.

yuki_wu

896 Posts
Posted - 05/05/2019 :  03:43:58 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi,

You can take a look at this page to see how to loop over columns, worksheets and workbook:
https://www.originlab.com/doc/LabTalk/guide/Looping-Over-objs

Regards,
Yuki

OriginLab
Go to Top of Page

BMG92

Germany
2 Posts
Posted - 05/07/2019 :  09:33:39 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Thanks for the quick help.
I think i now got an idea about how to shape my script.

Kind regards
Behrus
Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000