cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
TWE
TWE
Level III

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

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

View solution in original post

2 REPLIES 2

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

TWE
TWE
Level III

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

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