Save data table in existing Excel spreadsheet as a new tab

[#1]

Hi,

I have a data table and save it with the "save" command

dt1<< Save( Path||".xlsx" );

Now I would like to save another data table dt2 into the same Excelsheet but in a different worksheet tab

Is there a way to realize this?

Thanks

[#2 · Accepted solution]

Please see JMP Help > JMP Documentation Library > Scripting Guide > Data Tables chapter. There is a section called Create Excel Workbooks. It provides information such as: "You can save open data tables in a new or existing Excel workbook by using the Create Excel Workbook() function."

[#3]

Hi,
Thanks for the hint, that is exactly what I need!