cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
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