as the Excel Column Names and the XML Element names are not allways the same (less effort if we could rely), so we take care about this mapping.
also is not confired if only 1 record is to update or multiple records can be present and needs updated.
Prototype: 1 recored update case
-
read range - read in Excel | dtData
-
Read Text activity - read in XML file
-
Deserialize the XML into a XDoxument . - xDoc
-
Build datatable - Set up a mapping config - dtMapConfig
retrieve first Header Element:
Update Values:
xeHeader.Element(row(“XMLElementName”).toString).Value = dtData.Rows(0)(row(“EXCELColName”).toString).toString
