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

How we can close an opened excel file using JSL?

ram — Fri, 09 Jun 2023 23:24:02 GMT

How we can close an opened excel file using JSL?

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

ian_jmp — Wed, 14 Jun 2017 18:28:53 GMT

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

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

ram — Wed, 14 Jun 2017 18:36:40 GMT

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

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

Craige_Hales — Wed, 14 Jun 2017 20:58:48 GMT

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.

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

ram — Thu, 15 Jun 2017 02:19:53 GMT

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

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

txnelson — Thu, 15 Jun 2017 03:10:07 GMT

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.

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

ram — Thu, 15 Jun 2017 14:08:28 GMT

we can use function web()

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

Craige_Hales — Thu, 15 Jun 2017 17:22:34 GMT

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

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

ram — Fri, 16 Jun 2017 14:53:12 GMT

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.