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
 Forum for Origin C
 Help with scripting
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

shashank.vasudevan

Germany
4 Posts

Posted - 08/01/2019 :  06:30:04 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Hi,

This post is more asking for help from the scratch. If it is inappropriate, I will delete this.

I have tons of data to process using Origin that I was doing manually. It is basically copying a data set from a worksheet and inserting them in a column and plot them. Please see the attached image for example.

However, it takes a lot of time when I have to do it for more than 50 worksheets that have thousands of rows at once and it is something that I feel could be automated using a script.

But, I am very bad at scripting mainly because I dont know any programming language.

So I was wondering if someone could kindly help me create a script to do that? It would be really great given the time constraint I have.

Sincerely,
Shashank


Origin Pro 2018b, b9.5.5.409
Operating System:Windows 10

YimingChen

1685 Posts

Posted - 08/01/2019 :  2:28:36 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi,

Use LT script to append ranges:

	range r1 = col(A)[1:17];
	range r2 = col(C);
	copy -a r1 r2;
	range r1 = col(D);
	copy -a r1 r3;

	
	range r1 = col(A)[18:33];
	range r2 = col(E);
	copy -a r1 r2;
	range r2 = col(F);
	copy -a r1 r2;


James

Edited by - YimingChen on 08/01/2019 2:31:16 PM
Go to Top of Page

shashank.vasudevan

Germany
4 Posts

Posted - 08/02/2019 :  11:04:11 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Dear James,

Thank you so much. That was a good start for me and I modified it to suit my application.

Best,
Shashank
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