Spreadsheet

Data Binding

In the following example, the data variable will be automatically updated when the cell value changes.
The following content will be the content of the data variable.
<html>
<script src="https://jspreadsheet.com/v8/jspreadsheet.js"></script>
<script src="https://jsuites.net/v5/jsuites.js"></script>
<link rel="stylesheet" href="https://jspreadsheet.com/v8/jspreadsheet.css" type="text/css" />
<link rel="stylesheet" href="https://jsuites.net/v5/jsuites.css" type="text/css" />

<div id="spreadsheet"></div><br/>

<div id='log'></div><br>

<input type='button' value='Get the content of the data variable' id="consolelog" />

<script>
let data = [
   {
      "id":1,
      "name":"Jorge",
      "role":"1",
      "parent":0,
      "img":"img/nophoto.jpg",
      "department":1,
      "extension":"3120",
   },
   {
      "id":2,
      "name":"Antonio",
      "role":"2",
      "parent":1,
      "img":"img/nophoto.jpg",
      "department":2,
      "extension":"3121",
   },
   {
      "id":3,
      "name":"Manoel",
      "role":"3",
      "parent":1,
      "img":"img/nophoto.jpg",
      "department":2,
      "extension":"3123",
   },
   {
      "id":4,
      "name":"Pedro",
      "role":"4",
      "parent":3,
      "img":"img/nophoto.jpg",
      "department":2,
      "extension":"3124",
   },
   {
      "id":5,
      "name":"Carlos",
      "role":"4",
      "parent":3,
      "img":"img/nophoto.jpg",
      "department":3,
      "extension":"3125",
   },
   {
      "id":6,
      "name":"Marcos",
      "role":"5",
      "parent":2,
      "img":"img/nophoto.jpg",
      "department":3,
      "extension":"3126",
   },
   {
      "id":7,
      "name":"Ana",
      "role":"6",
      "parent":2,
      "img":"img/nophoto.jpg",
      "department":3,
      "extension":"3127",
   },
   {
      "id":8,
      "name":"Nicolly",
      "role":"7",
      "parent":2,
      "img":"img/nophoto.jpg",
      "department":4,
      "extension":"3128",
   },
   {
      "id":9,
      "name":"Paulo",
      "role":"5",
      "parent":7,
      "img":"img/nophoto.jpg",
      "department":4,
      "extension":"3129",
   },
   {
      "id":10,
      "name":"Iris",
      "role":"5",
      "parent":7,
      "img":"img/nophoto.jpg",
      "department":4,
      "extension":"3130",
   }
]
// Set the JSS spreadsheet license
jspreadsheet.setLicense('MjU2YjJmYzg3MDY0ODFjZmFjZGQ0NmY1N2VhZDIwOTVlMzM0YTU4N2RjNWRmZGI0MWYxZDI0NDZlMDFlYTUxZGJjMzczNjZhNmU5OTMwMjhiMjFmNWIwYjZjYWQxYzFlNzk0ZGU1ZWYwOWE2ZmEwMzM5ZGI0MzdlYjY4ODZjMGEsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpZek9UZzRPVFkyTENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2liRzlqWVd4b2IzTjBJbDBzSW5Cc1lXNGlPaUl6TkNJc0luTmpiM0JsSWpwYkluWTNJaXdpZGpnaUxDSjJPU0lzSW5ZeE1DSXNJbll4TVNJc0luWXhNaUlzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

// Create the spreadsheet
jspreadsheet(document.getElementById('spreadsheet'), {
    worksheets: [{
        data: data,
        minDimensions: [6, 5],
        worksheetName: 'Employees',
        columnDrag: false,
    }]
});

document.getElementById("consolelog").onclick = function() { document.getElementById('log').innerHTML = JSON.stringify(data) }
</script>
</html>
Edit this page on GitHub