Hi,
At first, I don’t think your Czech version is a problem.
In order to illustrate more clearly, let me take a simple example:
There are 5 columns in my data, and I want copy each row 15-20 of column 2-5 to a new worksheet respectively.
1. Check the name of workbook and worksheet that should point to your data correctly in the script.
2. Run the script to see if it can be successful to copy only one column to a new worksheet
copydata irng:=[book1]sheet1!col(2)[15:20] orng:=<new>!<new>;
3. Need to loop over the columns now, please go to this page and find out how to loop the columns:
http://www.originlab.com/doc/LabTalk/guide/Looping-Over-objs#Looping_over_Columns_and_Rows
loop (ii, 2, 5){copydata irng:=[book1]sheet1!col($(ii))[15:20] orng:=<new>!<new>;}
Note that $ should be added in col() of a loop
BTW, I have a small tip. If you want to know more about copydata, you can type “copydata -d” and hit ENTER in Command window. A dialog will be brought up. You can specify the input and output in the flyout by clicking the triangle button. At last, you select the triangle button at the top and select Generate Script, you can see the script shows on the Command window.
Hope this can be some help.
Regards,
Yuki
OriginLab
Failed to resolve range string
Posted - 10/24/2016 : 04:54:22 AM
