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.
| A | B | C | D | E | F | G | |
| 1 | 1 | Jorge | 1 | 0 | img/nophoto.jpg | 1 | 3120 |
| 2 | 2 | Antonio | 2 | 1 | img/nophoto.jpg | 2 | 3121 |
| 3 | 3 | Manoel | 3 | 1 | img/nophoto.jpg | 2 | 3123 |
| 4 | 4 | Pedro | 4 | 3 | img/nophoto.jpg | 2 | 3124 |
| 5 | 5 | Carlos | 4 | 3 | img/nophoto.jpg | 3 | 3125 |
| 6 | 6 | Marcos | 5 | 2 | img/nophoto.jpg | 3 | 3126 |
| 7 | 7 | Ana | 6 | 2 | img/nophoto.jpg | 3 | 3127 |
| 8 | 8 | Nicolly | 7 | 2 | img/nophoto.jpg | 4 | 3128 |
| 9 | 9 | Paulo | 5 | 7 | img/nophoto.jpg | 4 | 3129 |
| 10 | 10 | Iris | 5 | 7 | img/nophoto.jpg | 4 | 3130 |
<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('NmYyMWY5NjY2NDc2NzExZTI4MTEyZjJmMDc4N2ZlOTU1ODg3MGQwOWJiNDUzZWFlZTIwNTY1YWRmNzRhMGQyZDM2ZGU4MmRjMDEyZGUyNmIwMWE4OWJiNTdjNjRhNGJkNTBhOWE5MTgyMzFjMWU2YWNmMzA4MjNhYjQxNDhlYTIsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpRME1qYzVPVGM0TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0ozWldJaUxDSnNiMk5oYkdodmMzUWlYU3dpY0d4aGJpSTZJak0wSWl3aWMyTnZjR1VpT2xzaWRqY2lMQ0oyT0NJc0luWTVJaXdpZGpFd0lpd2lkakV4SWl3aVkyaGhjblJ6SWl3aVptOXliWE1pTENKbWIzSnRkV3hoSWl3aWNHRnljMlZ5SWl3aWNtVnVaR1Z5SWl3aVkyOXRiV1Z1ZEhNaUxDSnBiWEJ2Y25SbGNpSXNJbUpoY2lJc0luWmhiR2xrWVhScGIyNXpJaXdpYzJWaGNtTm9JaXdpY0hKcGJuUWlMQ0p6YUdWbGRITWlMQ0pqYkdsbGJuUWlMQ0p6WlhKMlpYSWlMQ0p6YUdGd1pYTWlYU3dpWkdWdGJ5STZkSEoxWlgwPQ==');
// 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>