Force Open() to Use Excel Wizard Without Changing Preferences
Jun 3, 2020 11:10 AM(521 views)
Hey JMP Community,
I'm building an application where a user can import data from Excel or from a JMP table. I'm getting the file path via Pick File(). If they select an Excel file, I want to coerce JMP to use the Excel Wizard without changing the user's preferences. In the Scripting Index, I found something called Excel Open Method() which has an option "Use Excel Wizard"; however, there is not an example. It is a message, but does not specify what type of object is compatible with that message.