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
Username:
Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum for Programming
 LabTalk Forum
 Wrcopy X-function doesn't work
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

Loksley

France
18 Posts

Posted - 03/16/2009 :  04:47:01 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Origin Ver. : OriginPro 8 Sr4
Operating System: Xp Sp2

I discovered the Wrcopy X-function at this address:
http://wiki.originlab.com/~originla/wiki2/index.php?title=X-Function:Wrcopy
and even when I use the given example:

wrcopy iw:=[book1]sheet1! r1:=5 r2:=10 name:=12 ow:=<new>;


I get the following message:
#Command Error!

Any idea?

Ps :I knew the X-function wcopy instead of wrcopy but it doesn’t take the row option (or I didn’t succeeded to get this option).

cpyang

USA
1406 Posts

Posted - 03/16/2009 :  07:32:50 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
You can use

lx w*

to list all the XF installed. I think wrcopy is a new XF and not in SR4. We will release SR5 this or next week and it should be there.

You can also contact Tech Service and they can check and email that XF to you. If an XF does not need any SR5 feature, then it can be drag and drop to install to SR4. Later, SR5 patch will automatically clean up that temp installation (by asking you first).


CP
Go to Top of Page

Loksley

France
18 Posts

Posted - 03/16/2009 :  07:48:30 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Thanks for the news.

I check with the lx command and wrcopy is not found on Sr4 version.

Edited by - Loksley on 03/16/2009 07:50:40 AM
Go to Top of Page

cpyang

USA
1406 Posts

Posted - 03/16/2009 :  07:59:58 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
I just tried in SR4 and found wrcopy does not compile. It made use of a new Origin C method in the Worksheet class called "CopyTo".

So you have to wait for SR5 to use this new XF. It was developed for copying data from Excel(open in Origin) as it has the option to specify a row to get as long name as well. So you can use this XF to run Pivot table in Excel book and get the results to Origin sheet.

CP
Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000