Origin Version (Select Help-->About Origin): 7.5 Operating System: Vista
Hi,
I am unsing Origin now for a while, and now I need some scripting. I have the following problem: I have several Worksheets and column A of some of them should be added with 3600 and so on. How can I do that with a script? and is there a good tutorial how to learn wrting scripts?
Here is a script that asks for the magic number, then loops through all the worksheets and when it finds one with a column named 'A' asks if you want to add the magic number to it. // BEGIN SCRIPT getn (Value to add) val (Column A Adder); doc -e W { if(exist(%H_A)) { sum(%H_A); getyesno (Add to %H_A? [$(sum.min)..$(sum.max)) resp; if(resp) %H_A+=val; } } // END SCRIPT
getn (Value to add) val (Column A Adder); prompts you for a value. Could replace with val=3600;
doc -e W { .. } handles looping through all Worksheets.
if(exists(%H_A)) { .. } makes sure we only look at worksheets with a column 'A'.
sum(%H_A); gathers some statistics to help you decide.
getyesno (Add to %H_A? [$(sum.min)..$(sum.max)) resp; asks if adding should occur (and gives you a min and max value).
if(resp) %H_A+=val; does the job if you clicked Yes.
Going through the 'Overview of the LabTalk Language' book in the Programming Help : LabTalk Language Reference might be useful.
Script HELP
Posted - 05/06/2008 : 1:23:32 PM
