2.7.23 files2dc


Contents

Menu Information

Data: Connect Multiple Files

Brief Information

Connect to multiple data files

Additional Information

Minimum Origin Version Required: 2020b

Command Line Usage

1. string fname$="C:\examples\Gasoline 1.mat%(CRLF)C:\examples\Gasoline 2.mat%(CRLF)C:\examples\Gasoline 3.mat"; files2dc dc:=MATLAB;

2. files2dc dc:=CSV fname:="%Ytest2.csv%(CRLF)%Ytest1.csv" samebk:=1 dlg:=1;

3. files2dc dc:=CSV src:=1 path:=%YData samebk:=1;

4. files2dc dc:="Import Filter" fname:="%YS32-014-04.dat%(CRLF)%YS21-235-07.dat%(CRLF)%YS15-125-03.dat" samebk:=1;

Variables

Display
Name 		Variable
Name 		I/O
and
Type 		Default
Value 		Description
Data Connector dc

Input

string

Specify the file type of Data Connector you want to use to connect to data files. Multiple types are supported, e.g. Biologic, TDMS, XML,MATLAB, HDF, CSV, Excel, and you can also choose to import files by specified filter.
Source src

Input

int

0
 Specify the source of files to be imported. Two options are available:
  • 0:Specified Files: specify files to import in File Name below
  • 1:Files in Specified Folder: search in Folder (specified below) and import all files of data type specified in Data Connector
File Names fname

Input

string

fname$
 Availabel when Source = Specified Files. Specify the files to be imported. Full path should be included.
Folder path

Input

string

Availabel when Source = Files in Specified Folder. Specify the folder path.
Same Book samebk

Input

int

0
 Available if the selected Connector type supports importing multiple files in the same workbook, CSV Connector for example. Checking this checkbox means that the book is named with the name of the first file. If imported to separate books, each book will be name with the file name.
Append to Same Sheet samesheet

Input

int

0
 Available if Data Connector = CSV and Same Book is checked. Specify whether to import multiple files into the same worksheet and if yes, how to append the files. Three options are available:
  • 0:None: import each file to a separated sheet,
  • 1:As New Rows: import all files in the same sheet appending by rows,
  • 2:As New Column: import all files in the same sheet appending by columns.
Insert File Name addfn

Input

int

0
 Available when Append to Same Sheet = As New Row. Check this checkbox to insert a column to the very beginning to store the file name information.
File Name Option filename

Input

int

0
 Availble when Append to Same Sheet = As New Row/As New Column. Specify what information you want to extract from the file name. Three options are available:
  • 0:File Name Only: extract file name only, without file extension
  • 1:Name and Extension: extract both file name and extension
  • 2:Partial File Name: extract part of file name, and specify which part of the name to extract in Extract Part of File Name edit box below.
Extract Part of File Name parts

Input

String

When File Name Option = Partial File Name, specify which part of the file name to extract to the 1st column. Enter the character range in the form of From_Position:To_Position or From_Position+Count_Character_No. 1 refers to the first character and 0 the last one.

For example, suppose the import file name (with extension) is T325K.csv. To extract the temperature (including unit), that is, 325K, you can enter 2:0, or 2+4.

Partial File Name Label label

Input

String

Specify the file name column Long Name when Append to Same Sheet = As New Row, or label row header when Append to Same Sheet = As New Column.
Open Dialog for First File dlg

Input

int

0
 If you want to specify the import settings, check this checkbox to open the Import Options dialog before importing the first file. All remaining files will follow these settings.
Set Column Designations cols

Input

String

Specify the column designations on import. Refer to this document for the designation symbols used here. Note that repeated patterns (pattern enclosed in parentheses is repeated) and pattern with lading and trailing designation symbols are supported.

For example,
XY will set 1st column as X and 2nd column as Y. It didn’t set designations further on so the rest of the columns will be all Ys;
3(XY) will set the first 6 column as XYXYXY. If there are more than 6 columns in the worksheet, the rest will be all Ys;
N(XY) will set 1st column as no designation, then repeat XY pair for remaining columns;
NL(XY)Z will et 1st column as no designation, 2nd column as label, last column as Z, the middle columns will repeat XY pairs.

Description

This X-Function is used to connect to multiple files at a time. Currently limited connector types are supported: CSV, Excel, MATLAB, HDF, NetCDF Connectors, and Import Filter for workbook; Matlab, HDF, and NetCDF Connectors for matrix.

The dialog supports choosing specified files or all files in a specified folder. For some types like the CSV Connector, you can specify the import of multiple files into the same workbook. If you select Open Dialog for First File checkbox, the Import Options dialog will be opened allowing you to specify the import settings. All remaining files will follow these settings.

Refer to this document for more information.