365525_en-US

liliconcom

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

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

 

 

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

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.

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

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.