Search
 
SCRIPT & CODE EXAMPLE
 

JAVASCRIPT

convert json data to a html table

var _table_ = document.createElement('table'),
  _tr_ = document.createElement('tr'),
  _th_ = document.createElement('th'),
  _td_ = document.createElement('td');

// Builds the HTML Table out of myList json data from Ivy restful service.
function buildHtmlTable(arr) {
  var table = _table_.cloneNode(false),
    columns = addAllColumnHeaders(arr, table);
  for (var i = 0, maxi = arr.length; i < maxi; ++i) {
    var tr = _tr_.cloneNode(false);
    for (var j = 0, maxj = columns.length; j < maxj; ++j) {
      var td = _td_.cloneNode(false);
      cellValue = arr[i][columns[j]];
      td.appendChild(document.createTextNode(arr[i][columns[j]] || ''));
      tr.appendChild(td);
    }
    table.appendChild(tr);
  }
  return table;
}

// Adds a header row to the table and returns the set of columns.
// Need to do union of keys from all records as some records may not contain
// all records
function addAllColumnHeaders(arr, table) {
  var columnSet = [],
    tr = _tr_.cloneNode(false);
  for (var i = 0, l = arr.length; i < l; i++) {
    for (var key in arr[i]) {
      if (arr[i].hasOwnProperty(key) && columnSet.indexOf(key) === -1) {
        columnSet.push(key);
        var th = _th_.cloneNode(false);
        th.appendChild(document.createTextNode(key));
        tr.appendChild(th);
      }
    }
  }
  table.appendChild(tr);
  return columnSet;
}

document.body.appendChild(buildHtmlTable([{
    "name": "abc",
    "age": 50
  },
  {
    "age": "25",
    "hobby": "swimming"
  },
  {
    "name": "xyz",
    "hobby": "programming"
  }
]));
Comment

convert json data to a html table

var myList = [
  { "name": "abc", "age": 50 },
  { "age": "25", "hobby": "swimming" },
  { "name": "xyz", "hobby": "programming" }
];

// Builds the HTML Table out of myList.
function buildHtmlTable(selector) {
  var columns = addAllColumnHeaders(myList, selector);

  for (var i = 0; i < myList.length; i++) {
    var row$ = $('<tr/>');
    for (var colIndex = 0; colIndex < columns.length; colIndex++) {
      var cellValue = myList[i][columns[colIndex]];
      if (cellValue == null) cellValue = "";
      row$.append($('<td/>').html(cellValue));
    }
    $(selector).append(row$);
  }
}

// Adds a header row to the table and returns the set of columns.
// Need to do union of keys from all records as some records may not contain
// all records.
function addAllColumnHeaders(myList, selector) {
  var columnSet = [];
  var headerTr$ = $('<tr/>');

  for (var i = 0; i < myList.length; i++) {
    var rowHash = myList[i];
    for (var key in rowHash) {
      if ($.inArray(key, columnSet) == -1) {
        columnSet.push(key);
        headerTr$.append($('<th/>').html(key));
      }
    }
  }
  $(selector).append(headerTr$);

  return columnSet;
}
Comment

convert json data into html table

<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script>

<body onLoad="buildHtmlTable('#excelDataTable')">
  <table id="excelDataTable" border="1">
  </table>
</body>
Comment

json to html table

Convert JSON to HTML Table
Step 1: Select your input. Option 1 - Choose JSON file Encoding. Option 2 - Enter an URL. ...
Step 2: Choose output options (optional) Output Field Separator: , ; : Bar-| Tab Other-Choose. Include header in first row. ...
Step 3: Generate output. Result Data: Save your result: .htm Download Result EOL:
Comment

PREVIOUS NEXT
Code Example
Javascript :: javascript export default 
Javascript :: e.target.value to image url in javascript 
Javascript :: groubbykey js 
Javascript :: stykesheet create 
Javascript :: how to check provided value is in array in javascript 
Javascript :: delete request from the script to html 
Javascript :: hincrby nodejs 
Javascript :: jquery xpath 
Javascript :: convert base64 to pdf file javascript 
Javascript :: jquery select input value empty and hasclass 
Javascript :: javascript traversing 
Javascript :: defining functions in react 
Javascript :: check if computer online js 
Javascript :: vue dispatch action at tab close 
Javascript :: hover javascript 
Javascript :: how to push array 
Javascript :: nodejs get appdata path 
Javascript :: switch case statement in javascript 
Javascript :: react native websocket useSession 
Javascript :: how to get a bot online on discord 
Javascript :: jq click with trigger load data 
Javascript :: bootstrap 4 form validator with jquery 
Javascript :: reverseString / Palindrome / Split string / Reverse Array 
Javascript :: install svelte routing 
Javascript :: use params in Class based component 
Javascript :: intellij debugger export object as json 
Javascript :: js startswitch 
Javascript :: javascript add item by index 
Javascript :: javascript object declaration 
Javascript :: ionicActionSheet decorator example 
ADD CONTENT
Topic
Content
Source link
Name
2+4 =