|
<div id="Spreadsheet"></div>
var intervalId, response = [], newDataSource = [];
//Datasource for inital binding
for (var i = 1; i <= 100; i++)
response.push({ ProductID: "Item" + i, …UnitsInStock: (10 * i) });
//Datasource for updating range after 10 seconds
for (var i = 101; i <= 150; i++)
newDataSource.push({ ProductID: "Item" + i…UnitsInStock: (10 * i) });
$(function () {
$("#Spreadsheet").ejSpreadsheet({
sheets: [{ rangeSettings: [{ dataSource: response, startCell: "A1", showHeader: true }], }], /*response contain 100 records*/
//..
});
intervalId = setInterval(updateNewRecords, 10000);
});
updateNewRecords = function () {
var xlObj = $("#Spreadsheet").data("ejSpreadsheet");
settings = { dataSource: newDataSource, showHeader: false, startCell: "A102" };
// To update range of cells with the specified settings
xlObj.updateRange(1, settings); // 1 => Sheet Index
xlObj.refreshSpreadsheet();
//Clear the interval timer
clearInterval(intervalId);
}
| 
