Just to clarify what you are asking - if you have multiple Excel workbooks to import that are pretty much identical in structure, you would like to be able to say 'for all of these files, import the sheet called 'Mfg Line 1' or something like that?
Exactly. When importing the data from many xls / xlsx / csv files, I would like to could specify which worksheets to import. Specify it in menu or jsl by their names or number if their names differ.
Important to me. I manually open excel worksheets but the source workbook contains critical information I need to enter manually for each file, which means I have a procedure that can not be readily deployed in my workplace.
The workbook name is natively stored within the source script in the data table but I'm unsure how to have that information be automatically referenced in the data table?
I found that this works in a way. By changing the Concatenate Worksheets value to 1, I am able to get a JMP file that is named after the workbook instead of the worksheet. I may only be importing a single sheet but it works regardless.
Slán
SpannerHead
Open(
Pick File("Select Excel File",
"$DOCUMENTS",
{"JMP Files|XLSX;TXT;CSV", "All Files|*"}),
Worksheets( "Sheet1" ),
Use for all sheets( 1 ),
Concatenate Worksheets( 1 ),
Create Concatenation Column( 1 ),
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( 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( "-" )
)
);