topic Save data table in existing Excel spreadsheet as a new tab in Discussions

Save data table in existing Excel spreadsheet as a new tab

TWE — Sat, 10 Jun 2023 23:14:06 GMT

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

Re: Save data table in existing Excel spreadsheet as a new tab

Mark_Bailey — Mon, 18 May 2020 11:00:41 GMT

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."

Re: Save data table in existing Excel spreadsheet as a new tab

TWE — Wed, 20 May 2020 12:41:23 GMT

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