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
Transpose worksheet and copy Data
Posted - 06/22/2015 : 08:55:45 AM
