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
 Failed to resolve range string

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
elements1990 Posted - 08/20/2018 : 09:31:13 AM
Origin Ver. and Service Release (Select Help-->About Origin): Origin 2018 64 bit SR1 / Origin 2015 32 bit
Operating System:Win7

Dear OriginLab,
I tried to execute the following code on both Origin 2015 and 2018, and it shows like "Failed to resolve range string, VarName = iy, VarValue = [extVB]Cs5p_data_lin!(1,2)". Could you please kindly help me have a look, what is the problem?

plotxy iy:=[extVB]Cs5p_data_lin!(1,2) plot:=201 ogl:=[<new template:=ORIGIN name:=Cs5p_S00>];
%A = %H;
plotxy iy:=[extVB]Cs5p_voigt_1!(1,2) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_2!(1,2) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_3!(1,2) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_4!(1,2) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_sum!(1,2) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_res!(1,2) plot:=200 ogl:=[%A]1! ;
delete rag Graph
win -t plot;
plotxy iy:=[extVB]Cs5p_data_lin!(1,3) plot:=201 ogl:=[<new template:=ORIGIN name:=Cs5p_S01>];
%A = %H;
plotxy iy:=[extVB]Cs5p_voigt_1!(1,3) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_2!(1,3) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_3!(1,3) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_4!(1,3) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_sum!(1,3) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_res!(1,3) plot:=200 ogl:=[%A]1! ;
delete rag Graph
win -t plot;
plotxy iy:=[extVB]Cs5p_data_lin!(1,4) plot:=201 ogl:=[<new template:=ORIGIN name:=Cs5p_S02>];
%A = %H;
plotxy iy:=[extVB]Cs5p_voigt_1!(1,4) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_2!(1,4) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_3!(1,4) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_4!(1,4) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_sum!(1,4) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_res!(1,4) plot:=200 ogl:=[%A]1! ;
delete rag Graph
win -t plot;
plotxy iy:=[extVB]Cs5p_data_lin!(1,5) plot:=201 ogl:=[<new template:=ORIGIN name:=Cs5p_S03>];
%A = %H;
plotxy iy:=[extVB]Cs5p_voigt_1!(1,5) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_2!(1,5) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_3!(1,5) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_4!(1,5) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_sum!(1,5) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_res!(1,5) plot:=200 ogl:=[%A]1! ;
delete rag Graph
win -t plot;
plotxy iy:=[extVB]Cs5p_data_lin!(1,6) plot:=201 ogl:=[<new template:=ORIGIN name:=Cs5p_S04>];
%A = %H;
plotxy iy:=[extVB]Cs5p_voigt_1!(1,6) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_2!(1,6) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_3!(1,6) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_4!(1,6) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_sum!(1,6) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_res!(1,6) plot:=200 ogl:=[%A]1! ;
delete rag Graph
win -t plot;
plotxy iy:=[extVB]Cs5p_data_lin!(1,7) plot:=201 ogl:=[<new template:=ORIGIN name:=Cs5p_S05>];
%A = %H;
plotxy iy:=[extVB]Cs5p_voigt_1!(1,7) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_2!(1,7) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_3!(1,7) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_4!(1,7) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_sum!(1,7) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_res!(1,7) plot:=200 ogl:=[%A]1! ;
delete rag Graph
win -t plot;
plotxy iy:=[extVB]Cs5p_data_lin!(1,8) plot:=201 ogl:=[<new template:=ORIGIN name:=Cs5p_S06>];
%A = %H;
plotxy iy:=[extVB]Cs5p_voigt_1!(1,8) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_2!(1,8) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_3!(1,8) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_4!(1,8) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_sum!(1,8) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_res!(1,8) plot:=200 ogl:=[%A]1! ;
delete rag Graph
win -t plot;
plotxy iy:=[extVB]Cs5p_data_lin!(1,9) plot:=201 ogl:=[<new template:=ORIGIN name:=Cs5p_S07>];
%A = %H;
plotxy iy:=[extVB]Cs5p_voigt_1!(1,9) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_2!(1,9) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_3!(1,9) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_4!(1,9) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_sum!(1,9) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_res!(1,9) plot:=200 ogl:=[%A]1! ;
delete rag Graph
win -t plot;
plotxy iy:=[extVB]Cs5p_data_lin!(1,10) plot:=201 ogl:=[<new template:=ORIGIN name:=Cs5p_S08>];
%A = %H;
plotxy iy:=[extVB]Cs5p_voigt_1!(1,10) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_2!(1,10) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_3!(1,10) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_4!(1,10) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_sum!(1,10) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_res!(1,10) plot:=200 ogl:=[%A]1! ;
delete rag Graph
win -t plot;
plotxy iy:=[extVB]Cs5p_data_lin!(1,11) plot:=201 ogl:=[<new template:=ORIGIN name:=Cs5p_S09>];
%A = %H;
plotxy iy:=[extVB]Cs5p_voigt_1!(1,11) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_2!(1,11) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_3!(1,11) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_4!(1,11) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_sum!(1,11) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_res!(1,11) plot:=200 ogl:=[%A]1! ;
delete rag Graph
win -t plot;
plotxy iy:=[extVB]Cs5p_data_lin!(1,12) plot:=201 ogl:=[<new template:=ORIGIN name:=Cs5p_S10>];
%A = %H;
plotxy iy:=[extVB]Cs5p_voigt_1!(1,12) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_2!(1,12) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_3!(1,12) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_4!(1,12) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_sum!(1,12) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_res!(1,12) plot:=200 ogl:=[%A]1! ;
delete rag Graph
win -t plot;
plotxy iy:=[extVB]Cs5p_data_lin!(1,13) plot:=201 ogl:=[<new template:=ORIGIN name:=Cs5p_S11>];
%A = %H;
plotxy iy:=[extVB]Cs5p_voigt_1!(1,13) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_2!(1,13) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_3!(1,13) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_4!(1,13) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_sum!(1,13) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_res!(1,13) plot:=200 ogl:=[%A]1! ;
delete rag Graph
win -t plot;
plotxy iy:=[extVB]Cs5p_data_lin!(1,14) plot:=201 ogl:=[<new template:=ORIGIN name:=Cs5p_S12>];
%A = %H;
plotxy iy:=[extVB]Cs5p_voigt_1!(1,14) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_2!(1,14) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_3!(1,14) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_4!(1,14) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_sum!(1,14) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_res!(1,14) plot:=200 ogl:=[%A]1! ;
delete rag Graph
win -t plot;
plotxy iy:=[extVB]Cs5p_data_lin!(1,15) plot:=201 ogl:=[<new template:=ORIGIN name:=Cs5p_S13>];
%A = %H;
plotxy iy:=[extVB]Cs5p_voigt_1!(1,15) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_2!(1,15) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_3!(1,15) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_4!(1,15) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_sum!(1,15) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_res!(1,15) plot:=200 ogl:=[%A]1! ;
delete rag Graph
win -t plot;
plotxy iy:=[extVB]Cs5p_data_lin!(1,16) plot:=201 ogl:=[<new template:=ORIGIN name:=Cs5p_S14>];
%A = %H;
plotxy iy:=[extVB]Cs5p_voigt_1!(1,16) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_2!(1,16) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_3!(1,16) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_4!(1,16) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_sum!(1,16) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_res!(1,16) plot:=200 ogl:=[%A]1! ;
delete rag Graph
win -t plot;
plotxy iy:=[extVB]Cs5p_data_lin!(1,17) plot:=201 ogl:=[<new template:=ORIGIN name:=Cs5p_S15>];
%A = %H;
plotxy iy:=[extVB]Cs5p_voigt_1!(1,17) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_2!(1,17) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_3!(1,17) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_4!(1,17) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_sum!(1,17) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_res!(1,17) plot:=200 ogl:=[%A]1! ;
delete rag Graph
win -t plot;
plotxy iy:=[extVB]Cs5p_data_lin!(1,18) plot:=201 ogl:=[<new template:=ORIGIN name:=Cs5p_S16>];
%A = %H;
plotxy iy:=[extVB]Cs5p_voigt_1!(1,18) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_2!(1,18) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_3!(1,18) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_4!(1,18) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_sum!(1,18) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_res!(1,18) plot:=200 ogl:=[%A]1! ;
delete rag Graph
win -t plot;
plotxy iy:=[extVB]Cs5p_data_lin!(1,19) plot:=201 ogl:=[<new template:=ORIGIN name:=Cs5p_S17>];
%A = %H;
plotxy iy:=[extVB]Cs5p_voigt_1!(1,19) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_2!(1,19) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_3!(1,19) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_4!(1,19) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_sum!(1,19) plot:=200 ogl:=[%A]1! ;
plotxy iy:=[extVB]Cs5p_voigt_res!(1,19) plot:=200 ogl:=[%A]1! ;

Thanks a lot for your kind help!!

1   L A T E S T    R E P L I E S    (Newest First)
yuki_wu Posted - 08/20/2018 : 10:01:31 PM
Hi,

Please double check if there is a worksheet named “Cs5p_data_lin” in the workbook named “extVB”. Also, please make sure that there are at least two columns in that worksheet.

The error message means LabTalk fails to access the range, sometimes it is caused by the wrong range string, sometimes it is caused by the non-existent range.

BTW, it seems that you need to loop over some worksheets and get the data to plot the line plot. Perhaps you could try doc command:
https://www.originlab.com/doc/LabTalk/guide/Looping-Over-objsaps

Regards,
Yuki

OriginLab

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