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,
How do I loop through sheets to plot graphs?
Posted - 05/03/2019 : 12:39:58 PM
