Scripting: save multiple data table to multiple sheets in Excel

Question

I like to save multiple datatables, each to an individual sheet, in a single Excel file?

What is the script to achieved that?

I tried "append", but it did not work

dt<< Save as("$DESKTOP/Untitled73.xlsx", append);

Thanks!

txnelson · Accepted Answer

The answer to your question comes from the Scripting Indes

Here is one of the examples from that entry

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

txnelson · Accepted Answer

This issue you are having is with 2 of the elements that you are attempting to pass to the Create Excel Workbook

The  third element in Create Excell Workbook function, need to be a list.  In your case,  the specification is not a list.

Element 2 documentation indicates that what is required is "List of open tables".  While your specification of

While the returned element from the Summarize() function, GroupBy, is a list, GroupBy[1] is a string variable.  You need to do something like

tempList = {};
insert into( tempList, GroupBy[1]);
Create Excel Workbook ("$DESKTOP/Untitled1.xlsx", {dt2}, tempList);