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
 Import .csv files with specified rows		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

achu6393

India
38 Posts
Posted - 06/26/2017 :  07:23:38 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Hello all,

I am have a folder of csv files to import to Origin as worksheets. The problem is that, the first 35 lines of the csv file is status messages(with 2 columns of data) and the actual data is from the 37th line(with 7 columns of data). So, what i want is an imported worksheet with 2 columns from rows 1-36 (other can be null) and the rest 7 columns with the data. But, when I import with the delimiter option with comma, so origin assumes the whole csv file just to have 2 colummns.

I have tried importing with worksheet template but the result is a worksheet with 2 columns of data nad rest null.

Is there a possible way to do this?

Origin Ver. and Service Release (Select Help-->About Origin): 9.3
Operating System: win 7

such coding! much wow!
Edited by - achu6393 on 06/26/2017 07:24:17 AM

yuki_wu

896 Posts
Posted - 06/26/2017 :  11:21:07 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi,

Have you tried Import Wizard? I think Import Wizard is very helpful when you are importing a file with many lines of header.

Please take a look at this tutorial and see if this applies to you:
http://www.originlab.com/doc/Tutorials/ImportWizard

Regards,
Yuki
OriginLab
Go to Top of Page

achu6393

India
38 Posts
Posted - 06/28/2017 :  08:01:56 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Thanks yuki! That helped a lot.

such coding! much wow!
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