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
 Origin Forum
 Worksheets.

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
nabilou Posted - 02/17/2015 : 06:43:16 AM
Hi,
My Origin Version is : OriginPro 9.0 64Bit

well my problem is the following:

I have 100 worksheets,

Etch worksheet has 3 columns, A, B and C

A(X)
B(Y)

The problem is:

1) I need to find the values in columns A(X) and B(Y) that match the row 50 for all Worksheets.
2) And then, I have to put all the values found in one worksheet.

I think that in have to use Command Window for this computational process.


Thanks
1   L A T E S T    R E P L I E S    (Newest First)
Castiel Posted - 02/17/2015 : 08:21:43 AM
Yes, a piece of Labtalk would help: 'doc -e' and 'wxt'. The former one loops through some collection, while the latter one extract data accordingly.

http://www.originlab.com/doc/LabTalk/ref/Document-cmd#-e_object_.7Bscript.7D.3B_Execute_the_given_script_for_all_objects

http://www.originlab.com/doc/X-Function/ref/wxt

©c¡Ï   ¤È¥¹  ©f¨u©c  ©c¥ì    ¥Î¤³  ©c/     ©¦£¯
 ©c¨Ê¥Î ¤´¥¨  ¥ó ¨×   ¥ó¤á' ¥Ì©¦¥­   /¤í  ¥Õ©¦©f
   ¨Ö             ¦á          ©¦£þ  ©` ¥Õ   ©¦
                              ©¦

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