Subscribe Bookmark RSS Feed

Set Excel Open Method to "Select Individual Worksheets" in JMP 11.1.1

jeff3928

Community Trekker

Joined:

Jun 29, 2012

In JMP 10 I could use the argument "Excel Selection(1)" with the "Set Preferences()" function to override the user preferences and prompt the user for which Excel worksheets should be imported from an Excel workbook. According to the JMP 11.1.1 Help this argument should still exist as a boolean but I have determined that it no longer functions to change the preferences. Does anyone know if there is a new argument I can use to change this preference in JMP 11.1.1?

1 ACCEPTED SOLUTION

Accepted Solutions
Solution

From JMP Technical Support:

If you compare the General tab preference from JMP 10 to JMP 11, you will see that the preference changed from a checkbox to a menu of choices; 

    Excel Open Method:

{Open All Sheets, Select Individual Worksheets, Use Excel Wizard}

To specify "Select Individual Worksheets" using JSL in JMP 11, use the following syntax:

    Set Preferences( Excel Open Method( "Select Individual Worksheets" ) );

1 REPLY
Solution

From JMP Technical Support:

If you compare the General tab preference from JMP 10 to JMP 11, you will see that the preference changed from a checkbox to a menu of choices; 

    Excel Open Method:

{Open All Sheets, Select Individual Worksheets, Use Excel Wizard}

To specify "Select Individual Worksheets" using JSL in JMP 11, use the following syntax:

    Set Preferences( Excel Open Method( "Select Individual Worksheets" ) );