BookmarkSubscribeRSS Feed
Choose Language Hide Translation Bar
David_Burnham

Super User

Joined:

Jul 13, 2011

Importing an Excel Worksheet using JMP on MAC

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
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
ms

Super User

Joined:

Jun 23, 2011

Solution

Re: Importing an Excel Worksheet using JMP on MAC

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")));

 

2 REPLIES 2
Highlighted
ms

Super User

Joined:

Jun 23, 2011

Solution

Re: Importing an Excel Worksheet using JMP on MAC

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")));

 

David_Burnham

Super User

Joined:

Jul 13, 2011

Re: Importing an Excel Worksheet using JMP on MAC

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

-Dave