Imports data from remote CSV/TXT files into the spreadsheet.
(function() { function LoadFile() { $.ajax({ url: 'your url', dataType: 'text', }).done(successFunction); } function successFunction(data) { var arrAllRows = data.split(/\r?\n|\r/); var oWorksheet = Api.GetActiveSheet(); //reference point var i = 1; var j = 1; for (var singleRow = 0; singleRow < arrAllRows.length; singleRow++) { var rowCells = arrAllRows[singleRow].split(','); for (var rowCell = 0; rowCell < rowCells.length; rowCell++) { oWorksheet.GetCells(i,j).SetValue(rowCells[rowCell]); j = j + 1; } i = i + 1; j = 1; } } LoadFile(); let reload = setInterval(function(){ Api.asc_calculate(Asc.c_oAscCalculateType.All); }); })();
Methods used: GetActiveSheet, GetCells, SetValue