Spreadsheet
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/v9/jspreadsheet.js"></script>
<script src="https://jsuites.net/v5/jsuites.js"></script>
<link rel="stylesheet" href="https://jspreadsheet.com/v9/jspreadsheet.css" type="text/css" />
<link rel="stylesheet" href="https://jsuites.net/v5/jsuites.css" type="text/css" />
<link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Material+Icons" />
<div id="spreadsheet"></div>
<div id='console'></div><br>
<input type='button' value='Get the content of the data variable' id="consolelog" />
<script>
let data = [
{
"id":1,
"name":"Jorge",
"img":"img/nophoto.jpg",
"department":"Marketing",
"extension":"3120",
},
{
"id":2,
"name":"Antonio",
"img":"img/nophoto.jpg",
"department":"Marketing",
"extension":"3121",
},
{
"id":3,
"name":"Manoel",
"img":"img/nophoto.jpg",
"department":"Marketing",
"extension":"3123",
},
{
"id":4,
"name":"Pedro",
"img":"img/nophoto.jpg",
"department":"Marketing",
"extension":"3124",
},
{
"id":5,
"name":"Carlos",
"img":"img/nophoto.jpg",
"department":"Marketing",
"extension":"3125",
},
];
// Set your JSS license key (The following key only works for one day)
jspreadsheet.setLicense('Y2Q0ZjM4M2MxYmI0OGJhOTg5MGRiNmY3Y2I3ZWY1MDcxZGNjNjhkYTU2NzNhYjgwM2M4YjUxNGJiNThhMDQ3ODgwYTQ3MGMzOTI1MDQ1NDJhZTJlOGIzZDIyMzk3NjM2YjRjYTIwMDA4NTE5MzMwYWQ2NzRiNWEyYzBlNDkwMGIsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpZd01qUTRNelE0TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2liRzlqWVd4b2IzTjBJbDBzSW5Cc1lXNGlPaUl6TkNJc0luTmpiM0JsSWpwYkluWTNJaXdpZGpnaUxDSjJPU0lzSW5ZeE1DSXNJbll4TVNJc0ltTm9ZWEowY3lJc0ltWnZjbTF6SWl3aVptOXliWFZzWVNJc0luQmhjbk5sY2lJc0luSmxibVJsY2lJc0ltTnZiVzFsYm5Seklpd2lhVzF3YjNKMFpYSWlMQ0ppWVhJaUxDSjJZV3hwWkdGMGFXOXVjeUlzSW5ObFlYSmphQ0lzSW5CeWFXNTBJaXdpYzJobFpYUnpJaXdpWTJ4cFpXNTBJaXdpYzJWeWRtVnlJaXdpYzJoaGNHVnpJaXdpWm05eWJXRjBJbDBzSW1SbGJXOGlPblJ5ZFdWOQ==');
// Create the spreadsheet
jspreadsheet(document.getElementById('spreadsheet'), {
worksheets: [{
data: data,
minDimensions: [5, 5],
worksheetName: 'employees',
columnDrag: false,
}]
});
document.getElementById("consolelog").onclick = function() { document.getElementById('console').innerHTML = JSON.stringify(data) }
</script>
</html>