topic Importing an Excel Worksheet using JMP on MAC in Discussions

Importing an Excel Worksheet using JMP on MAC

David_Burnham — Fri, 08 Feb 2019 17:22:05 GMT

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?

Re: Importing an Excel Worksheet using JMP on MAC

ms — Sat, 09 Feb 2019 13:46:33 GMT

I can confirm I see the same thing in JMP 13.2 and 14.2 on Mac (OS X 10.11.6). Really strange.

Possible workaround: I have no idea why, but pressing the button does not launch the Excel Wisard if the Open() function is run via Include().

Save Text File(
    "/Users/ms/Desktop/test6.jsl",
    "Open(\!"/Users/ms/Desktop/test.xlsx\!", Worksheets( \!"Sheet1\!" ))"
);
						
New Window("Test", Button Box("import", Include("/Users/ms/Desktop/test6.jsl")));

Re: Importing an Excel Worksheet using JMP on MAC

David_Burnham — Sat, 09 Feb 2019 19:03:50 GMT

Thanks - I appreciate the confirmation. I'll take a look to see whether I can implement a workaround based on using an include file.