topic Re: Do Not Open CSV File after 'Save As' when scripting in Discussions

Do Not Open CSV File after 'Save As' when scripting

Sburel — Wed, 04 Oct 2023 16:13:33 GMT

Hi,

I need to save tables by scripting both as .csv and then as .jmp.

When the .csv table is saved, it is automatically opened in excel (Win 11, JMP17Pro). Is there a way to set an option (or preference) to prevent the behavior?

Thanks

Sebastien

Re: Do Not Open CSV File after 'Save As' when scripting

Jed_Campbell — Thu, 05 Oct 2023 15:11:08 GMT

This script does not open the .csv file in Excel on my machine (Win11, JMP17Pro). Does it on yours?

dt = open ("$SAMPLE_DATA/Big Class.jmp");
dt << save as ("$DESKTOP/Big Class.csv");

Re: Do Not Open CSV File after 'Save As' when scripting

Craige_Hales — Thu, 05 Oct 2023 15:40:39 GMT

As far as I know, that behavior only happens when saving via the GUI

save-as dialog for csv

Re: Do Not Open CSV File after 'Save As' when scripting

Sburel — Sun, 08 Oct 2023 20:40:52 GMT

It does not open excel. I ran another test for obviously it's working fine. Not sure why I was experiencing that issue. Thanks for the help nonetheless