Solved: Re: Saving Data Table to Excel format

kuanaunwei · Jun 13, 2017 11:49 PM

Hi,

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

txnelson · Jun 14, 2017 02:42 AM

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

txnelson · Jun 14, 2017 02:42 AM

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 · Jun 14, 2017 02:59 AM

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