Choose Language Hide Translation Bar
TWE
TWE
Level I

Save data table in existing Excel spreadsheet as a new tab

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

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

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

Learn it once, use it forever!

View solution in original post

2 REPLIES 2
Highlighted

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

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

Learn it once, use it forever!

View solution in original post

Highlighted
TWE
TWE
Level I

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

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