nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

421071_en-US

liliconcom

Saving Multiple Data Tables to an Excel Workbook

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!

Data Table

Re: Saving Multiple Data Tables to an Excel Workbook

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

Re: Saving Multiple Data Tables to an Excel Workbook

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.