How to convert the following table to JSON with javascript?

by

Update: There’s a slightly improved fork of the solution (below) on jsFiddle.

You just need to walk the DOM of your table reading it out… this is not even close to optimized but will give you the result you want. (jsFiddle)

// Loop through grabbing everything
var myRows = [];
var $headers = $("th");
var $rows = $("tbody tr").each(function(index) {
  $cells = $(this).find("td");
  myRows[index] = {};
  $cells.each(function(cellIndex) {
    myRows[index][$($headers[cellIndex]).html()] = $(this).html();
  });    
});

// Let's put this in the object like you want and convert to JSON (Note: jQuery will also do this for you on the Ajax request)
var myObj = {};
myObj.myrows = myRows;
alert(JSON.stringify(myObj));​

And the output…

{"myrows":[{"Column 1":"A1","Column 2":"A2","Column 3":"A3"},{"Column 1":"B1","Column 2":"B2","Column 3":"B3"},{"Column 1":"C1","Column 2":"C2","Column 3":"C3"}]}

More Related Contents:

  1. Loading local JSON file
  2. Converting JavaScript object with numeric keys into array
  3. Convert array to JSON
  4. Post data to JsonP
  5. How to send JSON instead of a query string with $.ajax?
  6. jQuery.parseJSON throws “Invalid JSON” error due to escaped single quote in JSON
  7. Unexpected token colon JSON after jQuery.ajax#get
  8. Parsing JSON objects for HTML table
  9. Why is it a bad practice to return generated HTML instead of JSON? Or is it?
  10. jQuery.getJSON – Access-Control-Allow-Origin Issue
  11. Uncaught TypeError: Cannot use ‘in’ operator to search for ‘length’ in
  12. How to search JSON tree with jQuery
  13. Load local JSON file into variable
  14. Javascript search inside a JSON object
  15. How to get json key and value in javascript?
  16. How do I encode a JavaScript object as JSON?
  17. Defining a HTML template to append using JQuery
  18. Nested JSON objects – do I have to use arrays for everything?
  19. Jquery getJSON populate select menu question
  20. JS Object this.method() breaks via jQuery
  21. Error “Uncaught SyntaxError: Unexpected token with JSON.parse”
  22. Convert js Array() to JSon object for use with JQuery .ajax
  23. Passing JSON data from php to html-data attribute and then to Javascript
  24. Convert JSON string to Javascript array [duplicate]
  25. How to loop through JSON array?
  26. How to send parameter json array when modal open?
  27. SyntaxError: JSON.parse: unexpected character at line 1 column 1 of the JSON data
  28. Updating a JSON object using Javascript
  29. How to convert selected HTML to Json?
  30. How to return an array from an AJAX call?

Leave a Comment