Opening a specific XLS Workbook within a JMP Script

whom

I have an XLS (BigData.xls) that has workbook tabs named "US", "Canada", and "Ireland".

I have a script that needs to only open/read the Canada tab.  Is there a JMP script command to do that?  I'm trying to avoid using the manual dialogs to pull in the Canada tab.

Thanks!

Jeff_Perkinson

You can use the Worksheets() keyword:

 

open("C:\data\cars.xlsx", Worksheets("small"));

Import multiple worksheets by including the worksheet names in brackets:

 

 

open("C:\data\cars.xlsx", Worksheets( {"small", "medium", "large"} ));