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
 Origin Forum
 Working with multiple worksheets		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

nix199

Lithuania
2 Posts
Posted - 01/12/2016 :  11:21:05 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Origin Ver. 8.6 (Select Help-->About Origin):
Operating System: Win 7

Hello. I' m new in origin and forum as well. The problem is:

I have 200 measurement files of two columns each. The first column is the same for all files. I need to take one row (for example row No 100- the same for all files) from each file. I need to form new worksheet where the column is formed from all 200 values of 100th rows from all 200 files.

Could you please suggest how to do this in the simpliest and fastest way.

Thank you very much in advance.

snowli

USA
1385 Posts
Posted - 01/12/2016 :  11:36:58 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Origin supports multiple ascii import.
Also Origin supports partial import.

So choose File: Import: Multiple ASCII... and select files to import.
Then in the dialog that comes next,
Choose Import mode to start new row.
Check partial import and specify from row and to row to be 100.



Just FYI: In Origin 2016, we support partial import from 2nd file on. In your case of all 1st column is the same, you can easily skip all 1st columns from 2nd file on so data will be imported into XYYY.... form.

Thanks, Snow Li
OriginLab Corp.
Edited by - snowli on 01/12/2016 11:40:55 AM
Go to Top of Page

nix199

Lithuania
2 Posts
Posted - 01/12/2016 :  3:12:05 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Thank you very much for quick response. I will try this.
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