267351_en-US

liliconcom

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

Content OrganizationData Blending and CleanupMass CustomizationSharing and Communicating ResultsRe: Save data table in existing Excel spreadsheet as a new tabHi,
Thanks for the hint, that is exactly what I need!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."