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

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

dfusco923 — Fri, 09 Jun 2023 22:07:37 GMT

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

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

Jeff_Perkinson — Sat, 06 Mar 2021 14:53:03 GMT

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?

Georg — Sat, 06 Mar 2021 19:30:53 GMT

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.

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

briancorcoran — Mon, 08 Mar 2021 12:45:22 GMT

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

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

Devin — Wed, 27 Jul 2022 16:56:58 GMT

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!