BookmarkSubscribeSubscribe to RSS Feed

How to open specific worksheets from one excel file using JMP script

Wrote a JMP script to open one excel file and do calculations.
However, there are 10+ worksheets in the file and I only want JMP to work on one sheet only.

Can anyone advise how to script? I know we can change Preference and prompt a dialog to choose which worksheet to work on. But it is manual and affect other excel files opened by JMP.


Super User


Jun 23, 2011

Searching the forum for "Excel sheet", among the hits I found these:䍿猜

The idea is to use ODBC to open the file which allows specifying a particular sheet.

Community Trekker


Jan 15, 2014

i happened to have what you are looking for:)

Open( "#path#\filename.xlsx" ,"invisible",Worksheets( {"Test module and parameter list","Bin_definition_table","Module vs Class"} ));