Lazy loading
The following table is dealing with 60.000 columns. The lazy loading method allows render up to 130 rows at the same time and will render other rows based on the scrolling.
<html>
<script src="https://bossanova.uk/jspreadsheet/v3/jexcel.js"></script>
<link rel="stylesheet" href="https://bossanova.uk/jspreadsheet/v3/jexcel.css" type="text/css" />
<script src="https://jsuites.net/v3/jsuites.js"></script>
<link rel="stylesheet" href="https://jsuites.net/v3/jsuites.css" type="text/css" />
<div id="spreadsheet"></div>
<script>
jexcel(document.getElementById('spreadsheet'), {
csv:'/tests/demo1.csv',
csvHeaders:false,
tableOverflow:true,
lazyLoading:true,
loadingSpin:true,
columns: [
{
type:'text',
width:200,
title:'Name'
},
{
type:'dropdown',
width:100,
title:'Age',
source:[
{
id:1,name:'Male'
},
{
id:2,
name:'Female'
}]
},
{
type:'text',
width:200,
title:'City'
},
]
});
</script>
</html>