@uday_guntupalli there is an alternative to editing XML to edit Excel and save formatting and functions: use JMP functions to treat Excel as a database. I have only done this with sheets that have database layout, that is, columns are fields and rows are records.
I am not an SQL expert, but you can find documentation on updating many database records with a table. I will provide a simple example.
Below is a picture of a simple Excel file with two sheets and with formatting. The file is called suppliers.xlsx and the sheet to be updated is named suppliers. The book JSL Companion, 2nd Edition, documents three JMP ODBC methods: Open Database(), New SQL Query() and one the authors named a 3-step method.
This method can be used to execute any valid SQL statement. Below is the script to change one record using the SQL UPDATE syntax.
dbc = create database connection("DSN=Excel Files; DBQ=c:\temp\suppliers.xlsx");
Execute sql(dbc, "SELECT * FROM `suppliers$` WHERE supplier_name = 'Google' ", "READIT"); //example extraction
Execute sql(dbc, "UPDATE `suppliers$`
SET supplier_id = 150,
supplier_name = 'Apple',
city = 'Cupertino'
WHERE supplier_name = 'Google'");
close database connection(dbc);
Before the SQL scriptAfter the SQL Update - red box drawn
Note that the formatting is unchanged. I cannot attest to the performance of a database UPDATE with another table, but system updates are typically pretty fast. You can do a web search for the proper SQL syntax. Note if you are interested in this method and have 32bit Microsoft Office, it takes a couple steps to complete the onetime setup of the Machine File connection (my machine connection to Excel is named Excel Files ).
This is not the forum to discuss all of that. We (authors) wrote a supplementary document if you request it.
From your last post, it seems you have an R method to do waht you want, so I was not going to reply, but decided for closure/alternatives to add another method into the mix.