Change xml value from excel sheet

Help Studio
, ,
21

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

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