Change xml value from excel sheet

@ppr , Thanks for helping me out on solving. I went save the XML file as mention above While writing on the same XML file :

  1. Read XML and deserialized it saved in the xDoc variable.
  2. Read range and iterated on for each row in data table.
  3. 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.
  4. Write text file value xDoc.tostring and location path of xml mentioning the same file to update the value.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.