Force Open() to Use Excel Wizard Without Changing Preferences

cwillden — Fri, 09 Jun 2023 23:28:05 GMT

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.

Any ideas?

Thanks,

Cameron

Re: Force Open() to Use Excel Wizard Without Changing Preferences

cwillden — Wed, 03 Jun 2020 18:13:51 GMT

Of course, I immediately found the answer after posting. In Chapter 9 of the Scripting Guide:

"Note: To use the Excel Wizard, you must specify the Excel Wizard option in the argument as in Open( "$SAMPLE_IMPORT_DATA/Team Results.xlsx", "Excel Wizard" );."

Instead of deleting the post, I figured I'd leave the answer here if anyone else ever needs it.

topic Re: Force Open() to Use Excel Wizard Without Changing Preferences in Discussions

Force Open() to Use Excel Wizard Without Changing Preferences

Re: Force Open() to Use Excel Wizard Without Changing Preferences