| T O P I C R E V I E W |
| nastrovja |
Posted - 06/22/2015 : 08:55:45 AM
Origin Ver. and Service Release (Select Help-->About Origin): 9.0G
Operating System:Win7
Hi everyone this is my first post i couldn't find any exakt answer to my question hope it is the right place for my request:
I have a workbook with several sheets it i already sortet an i did the statistics.
now i want to copy the col with (sum, min, max, nuber of points, mean) transposed to a result book.
i've tried a loop an also a for-loop but neither works. But if i do do it step by step it works.:
the for-loop:
win -a book1;//activate data book
nsheet = page.nlayers;//get number of sheets
for (ii=1;ii <= nsheet;ii++){;
copydata irng:=[book1]$(ii)!2 orng:= [output];//copy second Col of sheet ii to book output
wtranspose;//transpose ouput book
copydata irng:=[output]1!(1:6) orng:= [results]1!(1[$(ii)]:6[$(ii)]);//cpoy transposed data to result book
win -c output; //delete output for next loop
}
i don't where i make my mistake because if i do it step by step ist works just fine |
| 3 L A T E S T R E P L I E S (Newest First) |
| lkb0221 |
Posted - 06/23/2015 : 09:57:51 AM
There is a redundant semicolon at the end of the line where your for loop is. Please delete it. |
| nastrovja |
Posted - 06/23/2015 : 05:21:07 AM
Thanks for your answer. But this didn't solve my problem. Now i get following error message:
[23.06.2015 11:18:32 copydata]
Failed to resolve range string, VarName = irng, VarValue = [book1]3!2
|
| lkb0221 |
Posted - 06/22/2015 : 11:14:47 AM
1). In the first CopyData XF, you need to specify the target column for pasting.
2). You can also try wrcopy XF. |
