0 Replies Latest reply on Nov 11, 2010 3:44 PM by John Sieber

    Comparing an excel file to and xml file and appending data to the xml file

    John Sieber Level 1

      I have an xml file (mapsource) and an excel file. One of the columns in the excel file matches up with a node in the xml file. I want to be able to loop through both files and add a new node to the xml file where the one of the columns in the excel file matches a node in the xml file.

       

      I can create a query object out of the excel dosument using the cfspreadsheet tag.

      I'm able to use xmlparse to create a xml document object from the xml file.

       

      What I would like to do is add col_3 from the excel spreadsheet as a new node when col_2 is equal to gpx.wpt.name.xmltext of the xml object.

       

      Any help or direction would be very helpful!