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
kuanaunwei
Level III

Saving Data Table to Excel format

Hi,

Is there any way to save a data table into Excel (.xlsx) format with scripting?

 

1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User

Re: Saving Data Table to Excel format

The Save() function.  Documentation and examples are at

     Help==>Scripting Index==>Save

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
dt << Save( "C:\Big Class.xlsx" );
Jim

View solution in original post

2 REPLIES 2
txnelson
Super User

Re: Saving Data Table to Excel format

The Save() function.  Documentation and examples are at

     Help==>Scripting Index==>Save

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
dt << Save( "C:\Big Class.xlsx" );
Jim
kuanaunwei
Level III

Re: Saving Data Table to Excel format

Hi txnelson, thanks for the info. Didnt know it was so simple.