The Origin Forum - import .dat files and del one column

The Origin Forum

Username:	Password:
Save Password
Forgot your Password? \| Admin Options

All Forums

Origin Forum for Programming

LabTalk Forum

import .dat files and del one column

New Topic

Reply to Topic

Printer Friendly

Author

Topic

Skaytex

Lithuania
7 Posts

Posted - 02/12/2014 : 12:58:37 PM

Origin Ver. 8,6

My folder name is 77. It has (12) R*.dat files and one excel file

Im imported 12 R*.dat files in 12 workbooks with 3 cols
with this command
string path$ = system.path.program$ + "samples\\script\77";
findfiles ext:=R*.dat;
impASC;

and then imported excel file impExcel fname:="C:\77\a.xlsx";

Is it possible to import 12 R*.dat files to one workbook wich has named folder name (77) in 12 worksheets with first two cols and their names and than import excel file in 13 worksheet with his name.

KF

lkb0221

China
497 Posts

Posted - 02/12/2014 : 1:53:04 PM

Hi,

you can try to use some control options to specify the import, for example:

impASC options.ImpMode:=4 options.FileStruct.NumericSeparator:=0 options.Cols.NumCols:=2 options.Names.FNameToBk:=0 orng:=[B77];
impExcel fname:="C:\77\a.xlsx" firstmode:=sheet desig:=<Unchanged> options.names.FNameToBk:=0 orng:=[B77]13!;

The first one will import only 2 columns to multiple worksheets in workbook called "B77". Notice that we cannot use pure numeric to be book name.
The second one will import a excel file to the 13th sheet.

Since I don't have your files, so these two command might not be exactly what you need.

To learn more about import X-functions, please see the following pages:
http://www.originlab.com/doc/X-Function/ref/impASC
http://www.originlab.com/doc/X-Function/ref/impExcel

Zheng
OriginLab

Edited by - lkb0221 on 02/12/2014 1:53:29 PM

Topic

New Topic

Reply to Topic

Printer Friendly

Jump To:

The Origin Forum

Snitz Forums 2000