I am quite new to Origin scripting / programming, but I've already managed to get a couple things up and running such as creating workbooks and worksheets.
Now the next step requires me to copy some data from one worksheet to another worksheet (in a different workbook). I need to create the workbooks and worksheets in the script too (but as I said I know how to do that, using 'newbook' and 'newsheet'). What I can't figure out is how to copy entire columns of data from one worksheet to another.
Suppose I have one large workbook called "master_workbook" with a large number of worksheets called "sheet1" to "sheet15". Suppose also I just created a new workbook called "WB3", and in that a new worksheet called "data" (ignore the default worksheet for the moment):
newbook WB3;
newsheet name:="data";
How do I now copy the data in column C of "sheet13" in workbook "master_workbook" to column A of my newly created "data" worksheet in workbook "WB3" ?
This greatly simplifies what I need to do, obviously (otherwise I'd do it manually), but if I can just figure this step out I'm sure I can get the rest myself.
So all I need is to know how I can copy the data from one column in one worksheet to another column in another worksheet (and in another workbook), assuming I have all these: - the name of the source workbook (master_workbook) - the name of the source worksheet (sheet13) - the name of the source column (C) - the name of the destination workbook (WB3) - the name of the destination worksheet (data) - the name of the destination column (A)
This should not be very hard, right? I can't find much help on "copying data" let alone from one worksheet to the other. Perhaps I'm using the wrong search terms... Can anyone assist me with this?
Thanks, that works. What a strange syntax though, I would expect r1 and r2 to behave as variables and that "r2 = r1" would simply assign r1 to the variable r2 (thus 'erasing' r2), but this seems to be the step where the data is copied... Strange, but as long as it works :p
Copying columns from one worksheet to another
Posted - 11/15/2011 : 1:12:47 PM
