The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
 All Forums
 Origin Forum for Programming
 LabTalk Forum
 copy row data

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: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkUpload FileInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
kdsaransh Posted - 12/27/2014 : 07:27:30 AM
hello,

I want to copy row1 data and place this data to row2, But the problem is that i cant find any command that copies the row data.All copy commands seem to be just for columns.

Thanks

Rajesh
9   L A T E S T    R E P L I E S    (Newest First)
ed-rod Posted - 04/29/2015 : 5:41:34 PM
Assuming "Shadow" is Sheet1 and "Database" is Sheet2, this seems to work for me.

[url=http://quickhealthyrecipe.blogspot.com/]healthy recipes[/url]
kdsaransh Posted - 04/29/2015 : 08:42:35 AM
Thanks a lot....
SeanMao Posted - 04/29/2015 : 05:00:27 AM
Hi,

The code is as following:


ii=1;
doc -e LB
{
wrcopy iw:=[%H]1! r1:=10 r2:=10 dr1:=$(ii) ow:=[DestinationBookName]SheetName!;
ii++;
}


Regards!

Sean
kdsaransh Posted - 04/23/2015 : 04:08:21 AM
hello,

I am facing another problem.

I have 10 workbooks with different names. Each having only 1 worksheet. Now i want to copy 10th row from each workbook and place that value into rows of a new workbook. So the first data goes into 1st row, 2nd data into 2nd row and so on...

I am using wrcopy, but since the name of the workbook is different, i am not able to do so .

Please help.

Thanks a lot...
kdsaransh Posted - 04/10/2015 : 03:51:44 AM
It worked,

Thanks a lot....
SeanMao Posted - 04/09/2015 : 04:22:06 AM
Hi,

I guess what you are looking for is a command we called Set as Long Name.

The following script will do the job:


doc -e LW // Loop all worksheets in active workbook
	{
		worksheet -s 0 1 0 1;  // Select first row
		wks.SetAsLabel(L,-1,0,0); // Set as Long Name and 
                                          // remove first row after
	}


Give it try.

Regards!

Sean

OriginLab Tech. Service
kdsaransh Posted - 04/03/2015 : 09:04:09 AM
Hi,

I am using origin 9.1 and i have a small query. I have a single workbook with 3 worksheets and i want to do the followings:

1. i want to copy the 1st complete row of the 1st worksheet and paste this row values as long name in that same very workbook and worksheet.

I am trying wrcopy function , but could not do so....

2. Now i want to delete this row.
3. I want to do this for all the 3 worksheets.

Thanks in advance...
kdsaransh Posted - 12/29/2014 : 11:22:10 AM
Thank you so much....
lkb0221 Posted - 12/29/2014 : 10:14:21 AM
Hi,

You can try wrcopy XF (http://www.originlab.com/doc/X-Function/ref/wrcopy), for example:

wrcopy iw:=[book1]sheet1! ow:=[book2]sheet2! r1:=2 r2:=2 dr1:=3; // Copy the 2nd row of [book1]sheet1 to the 3rd row of [book2]sheet2


Zheng
OriginLab

The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000