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
 All Forums
 Origin Forum for Programming
 LabTalk Forum
 change specific column for every book and sheet

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Anti-Spam Code:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkUpload FileInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
BMG92 Posted - 05/03/2019 : 10:59:33 AM
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.
2   L A T E S T    R E P L I E S    (Newest First)
BMG92 Posted - 05/07/2019 : 09:33:39 AM
Thanks for the quick help.
I think i now got an idea about how to shape my script.

Kind regards
Behrus
yuki_wu Posted - 05/05/2019 : 03:43:58 AM
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

The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000