cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Discussions

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

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

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

2 ACCEPTED SOLUTIONS

Accepted Solutions

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

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");

View solution in original post

Craige_Hales
Super User

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

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

save-as dialog for csvsave-as dialog for csv

Craige

View solution in original post

3 REPLIES 3

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

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");
Sburel
Level IV

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

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

Craige_Hales
Super User

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

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

save-as dialog for csvsave-as dialog for csv

Craige

Recommended Articles