Examples

Lazy loading

Jspreadsheet Pro implements a smart virtual DOM management that brings a greater performance. In the example below, the spreadsheet handles 2 million cells (200K x 10 columns).

Source code

<html>
<script src="https://jspreadsheet.com/v7/jspreadsheet.js"></script>
<link rel="stylesheet" href="https://jspreadsheet.com/v7/jspreadsheet.css" type="text/css" />
<script src="https://jsuites.net/v4/jsuites.js"></script>
<link rel="stylesheet" href="https://jsuites.net/v4/jsuites.css" type="text/css" />

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

<script>
var data = [];
document.addEventListener('DOMContentLoaded', function() {
    for (var j = 0; j < 500000; j++) {
        data[j] = [];
        for (var i = 0; i < 10; i++) {
            data[j][i] = jspreadsheet.helpers.getColumnNameFromCoords(i, j);
        }
    }

    var spreadsheet = jspreadsheet(document.getElementById('spreadsheet'), {
        data: data,
        tableOverflow: true,
        lazyLoading: true,
        lazyColumns: true,
        onlazyloading: function(el, addedRows, removedRows) {
            // Related events
        },
        license: 'M2RiZjdmY2MyMmIzM2JlMGQxZjZkODg5YzcxNjIxN2IxZWUzZjI3MDJlNTAyNDhkZTk1YzM1NTRiN2NkN2UyOTA5NzRmOWVkOWNlYmJkMmVkMjI4MzE0MzU1YTViZWQ2OGMwNDlkYmRkOTc5ZGYzOGExN2YwZGI2ZDYyMTU5YmYsZXlKdVlXMWxJam9pY0dGMWJDNW9iMlJsYkNJc0ltUmhkR1VpT2pFMk5EWXdPVEk0TURBc0ltUnZiV0ZwYmlJNld5SmpjMkl1WVhCd0lpd2lhbk5tYVdSa2JHVXVibVYwSWl3aWQyVmlMbUZ3Y0NJc0ltcHpjSEpsWVdSemFHVmxkQzVqYjIwaUxDSnFaWGhqWld3dWJtVjBJaXdpYkc5allXeG9iM04wSWwwc0luQnNZVzRpT2lJekluMD0='
    });
});
<script>

</script>
</html>

How the jspreadsheet lazy loading works

A brief visualization on how the lazy loading works on a jspreadsheet table.