cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • DownloadSemiconductor Toolkit: Tools to create wafer maps, add wafer geometry to graphics, explore die defects & compare wafers.
  • Discovery Summit 2026: Early User Edition - September 23-24.Register. It's free.
  • Use JMP Clinical with CDISC-compliant data. Review studies, ID safety and efficacy signals & communicate findings with interactive graphics. Register to see how. Aug. 27, 2 pm US ET.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
GroupSquareWolf
Level III

Scripting: open all sheets from an Excel file

What is the syntax to open all sheets from an excel file without naming all the sheets?

 

This is the script log I got after clicking "Select all" in Excel Wizard. The specific excel file had 2 sheets name "Sheet1" and "Sheet2".

Worksheets( {"Sheet1", "Sheet2"} ),

I could not find help from Scripting Index either 

Open( excelFilePath,
     <Worksheets( "sheet name" | {"sheet name", "sheet name", ...} | "n" )>,

Thanks

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Scripting: open all sheets from an Excel file

This simple syntax should work:

 

 

dt = Open( "Path\Workbook Name.xlsx" );

 

 

 

The variable dt will store a list of data table references when there is more than one sheet.

View solution in original post

1 REPLY 1

Re: Scripting: open all sheets from an Excel file

This simple syntax should work:

 

 

dt = Open( "Path\Workbook Name.xlsx" );

 

 

 

The variable dt will store a list of data table references when there is more than one sheet.

Recommended Articles