The Origin Forum

The Origin Forum

All Forums

Origin Forum

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:

Message:

* HTML is OFF
* Forum Code is ON

Check here to include your profile signature.
Check here to subscribe to this topic.

T O P I C R E V I E W
cw8bm68bhgeo	Posted - 07/27/2011 : 10:17:19 AM Origin Ver. and Service Release (Select Help-->About Origin): 8.5 Operating System: Windows 7 I would like to extract an interpolated value from another Workbook. If I were in the same Book I would e.g. use "Col(B)(205)" to get an interpolated value for the data in column B at the X-Value of 205. If I define a range with the data from another Book I can't seem to find any way of doing this.
1 L A T E S T R E P L I E S (Newest First)
easwar	Posted - 07/28/2011 : 2:43:17 PM Hi, You can use range notation to first define range for the column in the book. You can include book, sheet etc name so that book does not have to be the active window. So you can use code such as this: range ry=[book1]sheet1!col(b); ry(205)=; You can refer to the LabTalk wiki, and this section in particular for interpolation: http://wiki.originlab.com/~originla/ltwiki/index.php?title=Script:Interpolation If you need more help please post in the LabTalk forum. Easwar OriginLab

The Origin Forum