cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Don’t miss your chance to experience Discovery Summit Europe at our best available rate! Early bird registration through 31 Oct.
  • Graph Builder Toolbar streamlines interactive graphing. Creates shortcuts on Report and GraphBuilder Helpers toolbars. Download and install the extension.
  • JMP will suspend normal business operations for our Rest and Recharge Day on Friday, October 2, 2026.
    Regular business hours will resume on Monday, October 5, 2026.

Discussions

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

How we can close an opened excel file using JSL?

How we can close an opened  excel file using JSL?

8 REPLIES 8
ian_jmp
Level X

Re: How we can close an opened excel file using JSL?

NamesDefaultToHere(1);
dt = Open("$SAMPLE_IMPORT_DATA/Fill Weights.xlsx");
Wait(3);
Close(dt, NoSave);
ram
ram
Level IV

Re: How we can close an opened excel file using JSL?

when you open .xlsx, is it .jmp or .xlsx ? i like to close a .xlsx file not
.jmp
Craige_Hales
Super User

Re: How we can close an opened excel file using JSL?

You should see a JMP data table. If you are seeing excel opening a spreadsheet, something else is going on. If you open the .xlsx manually from JMP's file->open dialog, you'll land in JMP's import wizard which will help you do the first import. You can use the Source script in the JMP data table to repeat the process without going through the wizard.

Craige
ram
ram
Level IV

Re: How we can close an opened excel file using JSL?

hi ,
i do not want to open as jmp data table. how can i open as excel and close that excel using jsl?
txnelson
Super User

Re: How we can close an opened excel file using JSL?

When you Open() an Excel file in JMP, it is converted to a JMP file.  What is the reason you want the files to remain in Excel format?  The structure of a JMP data table is required for the various JMP Platforms to work with them.

Jim
ram
ram
Level IV

Re: How we can close an opened excel file using JSL?

we can use function web()
Craige_Hales
Super User

Re: How we can close an opened excel file using JSL?

web() launches excel as a separate program, independent of JMP. JMP does not have a way to close the excel spread sheet.

Craige
ram
ram
Level IV

Re: How we can close an opened excel file using JSL?

I was looking for both functiuons. i found web() to open excel file by a clickable link.
i guess no function to close the excel file using JSL.
Thanks all for your contribution.

Recommended Articles