Iterate through HTML table using jQuery, converting the data in the table into JSON

Question

I came across a case where I have to convert an HTML table data into JSON. In this process I have to iterate through the table and convert one by one (row) into an array and then convert the whole array into JSON. How do I iterate through the table (each row and column)?

Answer 1

First as fredrik pointed out we need to include https://github.com/douglascrockford/JSON-js.

Second we can use jQuery.fn.map and jQuery.fn.get to create an array of arrays (the tr:s) which contains the jQuery.fn.text content of the td elements:

var AoA = $('table tr').map(function(){
    return [
        $('td',this).map(function(){
            return $(this).text();
        }).get()
    ];
}).get();
var json = JSON.stringify(AoA);

Answer 2

Something like this? Fetching the content of each td into a myTable[rowIx][tableIx] array.

var myTable = [];
$('#myTable tr').each(function (i, tr) {
    var myTr = [];

    $('td', tr).each(function(j, td) {
        myTr.push($(td).html());
    });

    myTable.push(myTr);
});

Answer 3

You also need to convert the JavaScript array (also work on objects, strings, etc.) into a JSON serialized string.

Add this to your page (will be added to jQuery soon):

<script type="text/javascript" src="http://json.org/json2.js"></script>

And then serialize your array:

JSON.stringify(myTable)