| T O P I C R E V I E W |
| achu6393 |
Posted - 06/26/2017 : 07:23:38 AM
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! |
| 2 L A T E S T R E P L I E S (Newest First) |
| achu6393 |
Posted - 06/28/2017 : 08:01:56 AM
Thanks yuki! That helped a lot. 
such coding! much wow! |
| yuki_wu |
Posted - 06/26/2017 : 11:21:07 PM
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
|
|
|
