Loading from JSON
Loading from json and keep the references
Source code
<html> <script src="https://jspreadsheet.com/v7/jspreadsheet.js"></script> <script src="https://jsuites.net/v5/jsuites.js"></script> <link rel="stylesheet" href="https://jsuites.net/v5/jsuites.css" type="text/css" /> <link rel="stylesheet" href="https://jspreadsheet.com/v7/jspreadsheet.css" type="text/css" /> <div id="spreadsheet"></div> <script> var data = [ { name:'Jorge', id:'3', age:'40', gender:'Male' }, { name:'Rogerio Sergio', id:'4', age:'48', gender:'Male' }, { name:'Jorgina Santos', id:'5', age:'32', gender:'Female' }, { name:'Arnaldo Antunes', id:'6', age:'63', gender:'Male' }, ]; jspreadsheet(document.getElementById('spreadsheet'), { json: data, columns: [ { type:'text', width:'300', name:'id' }, { type:'text', width:'200', name:'name' }, { type:'text', width:'100', name:'age' }, { type:'hidden', name:'gender' }, ], license: 'ZmRjMTQzZWM2MDgwZjY5YzRjNWUyYjkzMTgzOTY2MjRmMGUyMWYyZTg5Mzg1YWNjNDVjYzQzNDhiNDhkNDM1YmZmMmIyM2U4NTM2NGU1MGVkMjIzNDEyNTcxZGE2ZmViNzQyMTNjOTg3ODM0MTJjZjY3ZGYxNmEyZmIwNGRlMzMsZXlKdVlXMWxJam9pU25Od2NtVmhaSE5vWldWMElpd2laR0YwWlNJNk1UWTROVGczTkRrNE1Td2laRzl0WVdsdUlqcGJJbXB6Y0hKbFlXUnphR1ZsZEM1amIyMGlMQ0pqYjJSbGMyRnVaR0p2ZUM1cGJ5SXNJbXB6YUdWc2JDNXVaWFFpTENKamMySXVZWEJ3SWl3aWQyVmlJaXdpYkc5allXeG9iM04wSWwwc0luQnNZVzRpT2lJek5DSXNJbk5qYjNCbElqcGJJblkzSWl3aWRqZ2lMQ0oyT1NJc0luWXhNQ0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owSWl3aVltRnlJaXdpZG1Gc2FXUmhkR2x2Ym5NaUxDSnpaV0Z5WTJnaUxDSndjbWx1ZENJc0luTm9aV1YwY3lKZExDSmtaVzF2SWpwMGNuVmxmUT09', }); </script> <textarea id='log' style='width:400px;height:100px;'></textarea> <input type='button' onclick="document.getElementById('log').value = JSON.stringify(document.getElementById('spreadsheet').jexcel.getJson())" value='Get JSON'> </html>