JMP will suspend normal business operations for our Winter Holiday beginning on Wednesday, Dec. 24, 2025, at 5:00 p.m. ET (2:00 p.m. ET for JMP Accounts Receivable).
Regular business hours will resume at 9:00 a.m. EST on Friday, Jan. 2, 2026.
We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.
Force Open() to Use Excel Wizard Without Changing Preferences
Created:
Jun 3, 2020 02:10 PM
| Last Modified: Jun 9, 2023 4:28 PM(2288 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.
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.
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.
