Lazy loading

The following table is dealing with 2 million+ cells. The lazyloading method allows render up to 80 rows at the same time and will render other rows based on the scrolling.



Source code

<html>
<script src="https://jexcel.net/v5/jexcel.js"></script>
<link rel="stylesheet" href="https://jexcel.net/v5/jexcel.css" type="text/css" />
<script src="https://jexcel.net/v5/jsuites.js"></script>
<link rel="stylesheet" href="https://jexcel.net/v5/jsuites.css" type="text/css" />

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

<script>
var data = [];
for (var j = 0; j < 200000; j++) {
    data[j] = [];
    for (var i = 0; i < 10; i++) {
        data[j][i] = jexcel.helpers.getColumnNameFromCoords(i, j);
    }
}

mySpreadsheet = jexcel(document.getElementById('spreadsheet'), {
    data: data,
    tableOverflow:true,
    lazyLoading:true,
    loadingSpin:true,
    defaultColWidth: '80px',
    license: '39130-64ebc-bd98e-26bc4',
});

document.getElementById('download').onclick = function () {
    mySpreadsheet.download();
}
<script>

</script>
</html>

How the lazyloading affects the DOM