The JMP17 version uses the normal reading program of the previous 15 version, and the result is a null value. For example, the row in the first table has values such as 1, 2, and 3, and the series in the second table is this column. When ML1 and R1 are spliced together, L1, R1, and M1 will automatically change the deficit value. How to solve it?
dir = Pick Directory( "Select a directory" );
//得到所有文件名，注意要确保所有表格字段名一致，且表格样式一样，否则会得到非预期结果。
files = Files In Directory( dir, Recursive );
If( Contains( files, ".DS_Store" ),
files = Remove( files, Contains( files, ".DS_Store" ) )
);
For( i = 1, i <= N Items( files ), i++,
fullfile = dir || files[i];
dt = Open(
fullfile,
Worksheets( "HGS" ),
Use for all sheets( 1 ),
Concatenate Worksheets( 0 ),
Create Concatenation Column( 0 ),
Worksheet Settings(
1,
Has Column Headers( 1 ),
Number of Rows in Headers( 1 ),
Headers Start on Row( 1 ),
Data Starts on Row( 2 ),
Data Starts on Column( 1 ),
Data Ends on Row( 0 ),
Data Ends on Column( 0 ),
Replicated Spanned Rows( 1 ),
Replicated Spanned Headers( 0 ),
Suppress Hidden Rows( 1 ),
Suppress Hidden Columns( 1 ),
Suppress Empty Columns( 1 ),
Treat as Hierarchy( 0 ),
Multiple Series Stack( 0 ),
Import Cell Colors( 0 ),
Limit Column Detect( 0 ),
Column Separator String( "-" )
)
);
dt << New Column( "文件名", character, width( 8 ), <<SET each="" value=""> 1,
dt1 << Concatenate( dt, "Append to first table" );
);
);</SET>