Import of 3 sheets from the same Excel file

[#1]

Hello all,

I would like to import 3 sheets from the same Excel file in JMP.

My Excel fil is encrypted with a password.

If I import the 3 sheets (AAA, BBB, and CCC) with the following code (written 3 times), I need to write 3 times the password:

Open(
      "/P:/XXX/TEMPLATE.xlsx",
      Worksheets( "AAA" ),
      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( "-" )
      )
) ;

Is there a way to import the 3 Excel sheet (AAA, BBB, CCC) from the same Excel file without opening the Excel file each time ?

Thanks a lot for your answer,

Sébastien

[#2 · Accepted solution]

Try specifying all 3 spreadsheets in the single input

Worksheets( { "AAA", "BBB", "CCC" }),

[#3]

Great, it works! 

Thanks a lot for you reply,

Sébastien