Hi,
tried using this tool and whilst totalRows is correct, it is returning no data.
fn!readexcelsheetpaging( excelDocument: ri!spreadsheet, sheetNumber: 5, pagingInfo: a!pagingInfo(1,-1))
DataSubset
Has anyone else seen this behaviour or explain what I am doing wrong?
Discussion posts and replies are publicly visible
Please change the batchsize to 100 or any max limit , then the function will return results
Eg:a!paginginfo(1,100)
Thanks Chandhinir, that has resolved the problem.