My scripts that I made before using the "Open" command is JSL is now way too slow. My script takes 12 minutes to execute now.
How should I import excel sheets now or please fix this but in JMP
I used to import my excel files using this code below but it takes too long:
Open(
"/Z:/Shared/R&D/Runsheet.xlsx",
Worksheets(
{"Thickness"}
),
Use for all sheets( 1 ),
Concatenate Worksheets( 1 ),
Create Concatenation Column( 0 ),
Worksheet Settings(
1,
Has Column Headers( 1 ),
Number of Rows in Headers( 1 ),
Headers Start on Row( 2 ),
Data Starts on Row( 3 ),
Data Starts on Column( 1 ),
Data Ends on Row( 0 ),
Data Ends on Column( 33 ),
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( "-" )
)
);
dt1 = Current Data Table();
dt1 << Set Name( "Thickness");
// I do this for a few different tables and then combine the tables together using the code below. What is taking so long to run this code?
Data Table( "Thickness" ) << Join(
With( Data Table( "dt2" ) ),
Merge Same Name Columns,
Match Flag( 0 ),
By Matching Columns( :Run # = :Run #),
Drop multiples( 0, 0 ),
Include Nonmatches( 1, 1 ),
Preserve main table order( 1 ),
Output Table( "OutputTable" )
);
