How do I save (overwrite) a JMP file to Excel and maintaing the Excel file formatting from te orignal Excel File?

[#1]

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

[#2]

I don't think that JMP has a way of inserting values into an existing worksheet, thereby retaining the formatting in the workbook. @briancorcoran may be able to confirm.

[#3]

You can let JMP write a plain Excel File, and let Excel in the formatted Worksheet take the data from that plain file via link. Hope this helps.

[#4]

When JMP writes an Excel file, the old file is completely overwritten.  Values are not inserted into it.  That is, JMP creates a brand new Excel file in its place.  So, there is no way to maintain the previous formatting.

Brian Corcoran

JMP Development

[#5]

Brian - JSL will not save over an opened excel file. I can ask users to close it for a time, so that I can save the xlsx as 'read only'. But I'm having trouble finding the code that will do that. If my excel file is at \\Server\Eng\egfile.xlsx, how can I save it as 'read-only' or 'read-only recommended' ?  Thanks!