How to convert xml fille to html table using jquery

JavaScript
1

I am trying to convert this to a html table using jquery. Is this possible? Here is my xml file.

<?xml version="1.0" encoding="utf-8"?>

 
  1243
  3355
  2312
 
 
  4455
  7898
  5232
 
  
  6541
  3214
  9874
 
 
  7894
  4561
  3212
2

It should be pretty easy using $.parseXML().

// just removed the line breaks
var rawXML = '<?xml version="1.0" encoding="utf-8"?><document><row><Col0>1243</Col0 > <Col1>3355</Col1 > <Col2>2312</Col2 > </row> <row> <Col0>4455</Col0 > <Col1>7898</Col1 > <Col2>5232</Col2 > </row> <row> <Col0>6541</Col0 > <Col1>3214</Col1 > <Col2>9874</Col2 > </row> <row> <Col0>7894</Col0 > <Col1>4561</Col1 > <Col2>3212</Col2 > </row></document>';

// Parse it
var xmlParsed = $.parseXML(rawXML);

// find the <document> tag
var xmlDoc = $(xmlParsed).find('document');

// find the <row> tag
var xmlRow = xmlDoc.find('row');

// loop over <row> tags
$(xmlRow).each(function() {
    for(var i=0; i < 3; i++) {
      // find the Col + i and append it's text to the #xmlstuff div
      $('#xmlstuff').append($(this).find('Col' + i).text()).append('<br/>');   
    }
});

This will loop over it. Adding the table is trivial from here.

Here’s a working JS Fiddle

1 Like
3

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