So maybe I'm just tired on a Friday afternoon, but I'm seeing a strange problem when scripting the Open function using JMP (14.2) on MAC.
Here is a simple script that does what you would expect - it creates a JMP table containing the contents of the sheet1 of the test spreadsheet.
Open(
"/Users/docs/test.xlsx",
Worksheets( "sheet1" )
)
But when I call it from a class method it launches the Excel wizard. I've simplified the problem by just popping the code onto a button and I still have the same problem i.e. the following code renders a window - when I click on the button it launches the Excel wizard.
New Window("Test",
ButtonBox("import",
Open(
"/Users/docs/test.xlsx",
Worksheets( "sheet1" )
)
)
)
For the sake of brevity I am not showing all the optional fields associated with the Open function - but even if I import the data manually then use the full source script as the basis of the import, the same problem happens. On Windows there's no problem.
It doesn't seem to be related to preference settings. Any ideas?
-Dave