Subscribe Bookmark RSS Feed

Saving Data Table to Excel format

kuanaunwei

Occasional Contributor

Joined:

Jun 12, 2017

Hi,

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

 

1 ACCEPTED SOLUTION

Accepted Solutions
txnelson

Super User

Joined:

Jun 22, 2012

Solution

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
2 REPLIES
txnelson

Super User

Joined:

Jun 22, 2012

Solution

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

Occasional Contributor

Joined:

Jun 12, 2017

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