All Forums  Origin Forum  Origin Forum  How do I loop through sheets to plot graphs?

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

Screensize: 640 x 480 800 x 600 1024 x 768 1280 x 1024 UserName: Password: Anti-Spam Code: Format Mode: Basic  Help  Prompt  Format: Font Andale Mono Arial Arial Black Book Antiqua Century Gothic Comic Sans MS Courier New Georgia Impact Lucida Console Script MT Bold Stencil Tahoma Times New Roman Trebuchet MS Verdana   Size 1 2 3 4 5 6   Color Black Red Yellow Pink Green Orange Purple Blue Beige Brown Teal Navy Maroon LimeGreen Message: * HTML is OFF * Forum Code is ON Smilies [quote][i]Originally posted by jblake[/i] [br]Origin Ver. and Service Release (Select Help-->About Origin): Operating System:OriginPro 2018 64bit Hey so I'm trying to write a script that allows me to loop through sheets in a book and perform a calculation (exp(-Col(A)) and then loop through the book again and plot this new column (Y) against another (x) from each sheet and then plot all in one graph together.Below is the code I have so far. The problem is with the plotting. This code plots the graph from the first sheet in the book but then does something strange with the other sheets and also plots extra graphs that I did not specify. Please help! doc -ef LB // Loop through all individual sheets in all books in the current Project Explorer folder { if (exist(%H, 2) == 0) // This filters our Matrix sheets that may be in folder. continue; // If the current item in the loop is NOT a worksheet, Col(C) = exp(-Col(A)); } doc -ef LB // Loop through all individual sheets in all books in the current Project Explorer folder { if (exist(%H, 2) == 0) // This filters our Matrix sheets that may be in folder. continue; // If the current item in the loop is NOT a worksheet, plotxy iy:=(B,C) plot:=200;// Plots line graph } [/quote]   Check here to include your profile signature. Check here to subscribe to this topic.