@ppr , Thanks for helping me out on solving. I went save the XML file as mention above While writing on the same XML file :
- Read XML and deserialized it saved in the xDoc variable.
- Read range and iterated on for each row in data table.
- On Assign statement I called node and its value : docx.Element(“SBDetails”).Element(“SBDocuments”).Element(“SBDocument”).Element(“Sender”).Value and on value side I mentioned changing value from excel Row(“Sender”).ToString.
- Write text file value xDoc.tostring and location path of xml mentioning the same file to update the value.