How to used JSL JMP tables into a multi-tabbed Excel workbook？

[#1]

I would like to ask JMP community to help me out on a custom way to export JMP table to excel.

Thanks!

dt = Open( "$SAMPLE_DATA/Big Class.jmp" );

[#2 · Accepted solution]

I am not sure exactly what all you need with your code, but here is a simple script that creates your required subsets and saves them to an Excel workbook.  If you need to save the jmp tables as separate tables, in addition to the workbook, you can do that with a simple loop after the workbook is created.

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );

cNa = dt << get column names;
xF = {};
For( c = 2, c <= N Col( dt ), c++,
	d2 = dt << Subset(
		All rows,
		columns( dt:name, Column( dt, c ) ),
		output table( Char( cNa[c] ) )
	);
	Insert Into( xF, d2 << get name );
);

close( dt, nosave );

Create Excel Workbook( "c:\TheWorkBook.xlsx", Eval( xF ), Eval( xF ) );

[#3]

That's exactly what's needed.

Thank Jim!