I'm adding JavaScript to a SharePoint and trying to write a function that retrieves an Excel document or the data it contains from a library. I've already figured out how to do that, but the files in question are too big to be returned. I considered manually setting the size limit for Ajax, but I found no way for Plan B to send a query for each row
$("#button").click(function() {
readFileRow(libraryUrl, "FileName.xlsx", "Sheet1", 1, "E", ())
.done(function(cells) {
console.log(xmlToJson(cells.documentElement));
});
});
/**
* Reads a file in SharePoint Library via ExcelRest and returns the document
*
* @params string libraryUrl
* @params string fileName
* @params string sheetName
* @params int rowNum
* @params string lastColumn
* @params string()() finalResults
*
* @returns string()()
**/
function readFileRow(libraryUrl, fileName, sheetName, rowNum, lastColumn, finalResults) {
var fileUrl = libraryUrl + "/" + fileName + "/Model/Ranges('" + sheetName + "!A" + rowNum + "|" + lastColumn + rowNum + "')?$format=atom";
return $.ajax({
url: fileUrl,
type: "GET",
error: function (request, status, error) {
console.log(error);
},
}).done(function(data) {
jsonData = xmlToJson(data.documentElement);
cells = serializeRange(jsonData);
if(cells) {
finalResults.push(cells);
rowNum++;
finalResults = readFileRow(libraryUrl, fileName, sheetName, rowNum, lastColumn, finalResults);
}
return $.when(finalResults);
});
}
As you can see, I'm trying to work around the async problem by calling the function recursively when the request comes back with data, meaning it needs to be executed further. When I place a console.log () just before returning, I can see that it compiles the results the way I need it. However, the readFileRow () call is returned before the process completes and consists of the response of the very first Ajax query, which apparently did not run through the .done () function. I tried to remove the return before the Ajax call, but this results in only one exception, since the return is no longer executable and therefore has no .done () function.
Can someone recognize what's wrong with this feature? Asynchronous functions are not my strength and I am quite at a loss.
