Import of 3 sheets from the same Excel file

Sebastienlg — Mon, 18 Mar 2024 16:07:20 GMT

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

Re: Import of 3 sheets from the same Excel file

txnelson — Mon, 18 Mar 2024 18:25:49 GMT

Try specifying all 3 spreadsheets in the single input

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

Re: Import of 3 sheets from the same Excel file

Sebastienlg — Tue, 19 Mar 2024 11:02:48 GMT

Great, it works!

Thanks a lot for you reply,

Sébastien

topic Import of 3 sheets from the same Excel file in Discussions

Import of 3 sheets from the same Excel file

Re: Import of 3 sheets from the same Excel file

Re: Import of 3 sheets from the same Excel file