I have a piece of JMP script that saves a JMP file to Excel. The Excel file is overwritten with the new data.
CTZ = CT_1 << Summary(
Group(
:Rcd No., :Prog, :Pri, :No., :Matl_Desc, :Issue, :Cog Eng., :Status,
:Assign Date, :ECD, :Actionee
)
);
CTZ << delete columns( "N Rows" );
CTZ << save( "Daily Rpt Listing.xlsx" );
When the file is save the formatting of the Excel file that is being overwritten is lost. How can I overwrite the Excel file but maintain the original Excel file formatting? I have done this in the past but cannot find how I did it . . .