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))
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
Thanks Chandhinir, that has resolved the problem.
© 2021 Appian. All rights reserved.