@Tomer_Aminizar ,
There are multiple ways to do this, but you should select what makes sense for your user environment.
The script below provides one option using Pick File() . Note, select Team Results.xlsx when prompted
Names Default To Here( 1 );
//***Select the file Team Results.xlsx
xlfid = Pick File(
"Select the Excel File", //prompt
"$Sample_Import_Data", //starting path
{"Excel Files|xls;xlsx", "Excel Files|*"}, //file types
1,
0,
""
);
//xlfid is the use selected file path
dt = Open( xlfid, //file path
Use for all sheets( 1 ),
Concatenate Worksheets( 1 ),
Create Concatenation Column( 1 ),
Worksheet Settings(
Has Column Headers( 1 ),
Number of Rows in Headers( 1 ),
Headers Start on Row( 3 ),
Data Starts on Row( 4 ),
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( "-" )
)
);
There are options to use SQL database commands, but that might require your users to set up OBDC connections to Excel files.
If the Excel files are not HUGE, it might be easier to create the file and use JSL dt << Select Where( ) syntax to get the observations meeting certain criteria.
It seems you are new to the JMP Scripting Language (JSL) . Is that true? JMP will capture the script (JSL) for JMP platforms (Open, Sort, Fit YbyX, etc.) but it does not record the point and click steps you take. The onus is on scripter to find the equivalent JSL syntax.
If you are new, I suggest you get familiar with Help > Scripting Index > and search. The JMP Community can be helpful for finding the JSL function (object message) to achieve certain tasks.
A simple safe (no IP data) example would be useful.
Good Luck.
