Examples
Data persistance
With the persistance directive, each change in the data will be sent to a remote URL.
Source code
<html> <script src="https://jspreadsheet.com/v7/jspreadsheet.js"></script> <script src="https://jsuites.net/v4/jsuites.js"></script> <link rel="stylesheet" href="https://jspreadsheet.com/v7/jspreadsheet.css" type="text/css" /> <link rel="stylesheet" href="https://jsuites.net/v4/jsuites.css" type="text/css" /> <div id="spreadsheet"></div> <script> var mySpreadsheet = jspreadsheet(document.getElementById('spreadsheet'), { url:'/jspreadsheet/books.json', columns: [ { type: 'autonumber', width: '50px', title: 'Code', name: 'id', readOnly: true, primaryKey: true }, { type: 'text', width: '80px', title:'Image', name:'thumbnailUrl' }, { type: 'text', width: '200px', title:'Title', name:'title' }, { type: 'text', width: '55px', title:'Pages', name:'pageCount' }, { type: 'calendar', width: '90px', title:'Published', name: 'publishedDate' }, { type: 'text', width: '200px', title:'Author', name:'authors' }, { type: 'dropdown', width: '180px', title:'Categories', name:'categories', source:['Internet','Web Development', 'Java', 'Mobile', 'Open Source'], multiple:true }, ], allowComments:true, persistance: '/jspreadsheet/save', updateTable: function(instance, cell, col, row, val, label, cellName) { if (col == 1) { if (! val) { cell.innerHTML = '<img src="https://images-na.ssl-images-amazon.com/images/I/21%2Bwfxx2lyL._SX319_BO1,204,203,200_.jpg" style="width:60px;">'; } else { cell.innerHTML = '<img src="' + val + '" style="width:60px;">'; } } cell.style.overflow = 'hidden'; }, onevent:function() { console.log(arguments); }, license: 'M2U4YjhlY2Q3OTM4YWFiOWFlZDM3MjRlY2U4OGJhMjFiODIwNjZmYzhiZjFlNDk5ZWEyYWVmZDM4NGJhN2UyZTE4M2Q2MjJhODFhZGRlZmY0NzU0ZTJjMTVlYzI3YmIyYTM2YzY0MTA4NjBhYzU2ZGQ0Y2I3YmYyNTk5ZDM3YWEsZXlKdVlXMWxJam9pU25Od2NtVmhaSE5vWldWMElpd2laR0YwWlNJNk1UWTNOakF3TVRRMU55d2laRzl0WVdsdUlqcGJJbXB6Y0hKbFlXUnphR1ZsZEM1amIyMGlMQ0pqYjJSbGMyRnVaR0p2ZUM1cGJ5SXNJbXB6YUdWc2JDNXVaWFFpTENKamMySXVZWEJ3SWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpJaXdpYzJOdmNHVWlPbHNpZGpjaUxDSjJPQ0lzSW5ZNUlpd2lZMmhoY25Seklpd2labTl5YlhNaUxDSm1iM0p0ZFd4aElpd2ljR0Z5YzJWeUlpd2ljbVZ1WkdWeUlpd2lZMjl0YldWdWRITWlMQ0pwYlhCdmNuUWlMQ0ppWVhJaUxDSjJZV3hwWkdGMGFXOXVjeUlzSW5ObFlYSmphQ0pkTENKa1pXMXZJanAwY25WbGZRPT0=', }); </script> </html>