The Origin Forum

The Origin Forum

All Forums

LabTalk Forum

copy a row

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:

UserName:

Password:

Anti-Spam Code:

Format Mode:

Format:

Message:

* HTML is OFF
* Forum Code is ON

Check here to include your profile signature.
Check here to subscribe to this topic.

T O P I C R E V I E W
OndrejMM	Posted - 07/14/2008 : 03:12:49 AM Hi Guys, just a stupid question, how can I copy Xth (1st) row from many worksheet to a new worksheet,... I've started as follows but I have a problem there,... doc -cw data; // count test worksheets loop(i,1,count) { win -a data$(i); // activate next wks work -s 0 1 0 1; menu -e 57634; // execute Edit> Copy win -a newdata; how can I now select the first empty row in worksheet "newdata"??? menu -e 57637; // execute Edit> Paste }; is this really the easist way? not sure if thre is not any other error,... Many Thanks Ondrej
2 L A T E S T R E P L I E S (Newest First)
OndrejMM	Posted - 07/16/2008 : 8:44:52 PM Hi Vincent, many thanks for your help,... Ondrej
VincentLiu	Posted - 07/15/2008 : 04:24:37 AM Hi OndrejMM, You may try following code to get you want. doc -cw data; iRow = 1; //The ith row of the new worksheet loop(i,1,count) { win -a data$(i); // activate next wks nCol = wks.nCols; loop(jj,1,nCol) { %(newdata,$(jj),$(iRow)) = %(%H,$(jj),1); //copy the 1st row to the newdata wks } iRow = iRow + 1; //The next row of the newdata worksheet. } Regards, Vincent OriginLab Technical Services

The Origin Forum