topic Re: Saving Multiple Data Tables to an Excel Workbook in Discussions

Saving Multiple Data Tables to an Excel Workbook

uProf — Sun, 11 Jun 2023 11:49:42 GMT

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!

Re: Saving Multiple Data Tables to an Excel Workbook

Thierry_S — Sun, 26 Sep 2021 01:22:40 GMT

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,

Re: Saving Multiple Data Tables to an Excel Workbook

uProf — Mon, 27 Sep 2021 02:38:38 GMT

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