I am trying to import multiple XLSX files (which I know how to do), but I only need certain tabs with certain columns. I don't need everything being imported. Is there a way to do this?
Using JMP 17. Can recreate with steps or JSL code.
The settings for inputting an .xlsx file has the ability to specify the specific worksheets to be input. It also has the ability to specify the starting column and ending column
The Scripting Index has an entry that shows and example that has the input options displayed.
Thank you. This works if I am doing each file one by one, but not multiple files at once. Do you know how to do this for multiple files at once?
As long as each xlsx is set up the same way, just iterate over a list of the files:
FPlist = {"$DESKTOP/temp.xlsx", "$DESKTOP/temp1.xlsx"}; For Each( {val}, FPlist, Open( val, Worksheets( {"Sheet1", "Sheet3"} ), 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 ), Suppress Hidden Rows( 1 ), Suppress Hidden Columns( 1 ), Treat as Hierarchy( 0 ), Multiple Series Stack( 0 ), Import Cell Colors( 0 ), Column Separator String( "-" ) ) ) );
I have been trying to get that script to work and I cannot make it happen.
