Saving Multiple Data Tables to an Excel Workbook

[#1]

Hi -
I have a jsl script made with Jmp 12 that processes huge data table and generates 9 data tables with different summaries.

I am saving these off currently as 9 csv files. I would like to condense it to ONE Excel workbook with 9 tabs.

I understand saving each data table to excel (xlsx) is an option. How can I have 9 sheets saved to one excel via Jmp 12?

Appreciate any inputs/pointers. Thanks!

[#2]

Hi,

I am not sure if this command is available in JMP 12, but in more recent version, you can use the following:

Names Default To Here( 1 );
dt1 = Open( "$SAMPLE_DATA/Big Class.jmp" );
dt2 = Open( "$SAMPLE_DATA/Abrasion.jmp" );
Create Excel Workbook(
	"$TEMP/MyWorkbook.xlsx",
	{dt1, dt2},
	{"Big", "Abrasive"}
);

With the first List being the data tables you need to aggregate and the second list being the names of the worksheets.

Let us know if this helps?

Best,

TS

[#3]

Thanks Thierry. This does not work on Jmp 12. I do look forward to using this feature once I upgrade to newer Jmp version.