You can save open data tables in a new or existing Excel workbook by using the Create Excel Workbook() function. The first example adds all open data tables without changing the worksheet names:
dt1 = Open( "$SAMPLE_DATA/Big Class Families.jmp" );
dt2 = Open( "$SAMPLE_DATA/San Francisco Crime.jmp" );
Create Excel Workbook( "c:/MyWorkbook1.xlsx" );
The following example creates MyWorkbook2.xlsx by combining the open Big Class Families.jmp and San Francisco Crime.jmp sample data tables.
dt1 = Open( "$SAMPLE_DATA/Big Class Families.jmp" );
dt2 = Open( "$SAMPLE_DATA/San Francisco Crime.jmp" );
tableList = {"Big Class Families", "San Francisco Crime"};
// specify the data tables
sheetList = {"Families", "Crime"};
// specify the worksheets (optional)
Create Excel Workbook( "c:/MyWorkbook2.xlsx", tableList, sheetList );
dt1 = Open( "$SAMPLE_DATA/Big Class Families.jmp" );
dt2 = Open( "$SAMPLE_DATA/San Francisco Crime.jmp" );
Create Excel Workbook(
	"c:/MyWorkbook3.xlsx",
	{dt1, dt2}, // data table references
	{"Families", "Crime"}
);
Create Excel Workbook() also accepts a mix of data table references and data table names in the list. For example, {dt1, dt2} above can also be expressed as {dt1, "San Francisco Crime"}.
Notes: 
The saved file is an .xlsx file; the .xls format is not supported.

Help created on 10/11/2018