I have to know the number of rows in an uploaded excel sheet in order to give a validation based on number of rows in the excel sheet. Can anyone help in this please.
Thanks in Advance,
Pramod
Discussion posts and replies are publicly visible
Hi,
You can use the below expression to get the number of rows in the excel sheet.
if( document( ri!document, "extension" ) = "XLSX", count( a!flatten( index( readexcelsheet( excelDocument: ri!document, sheetNumber: 0, startRow: 1, numberOfColumns: 1 ), "result", null ) ) ), 0 )
https://community.appian.com/b/appmarket/posts/excel-tools
Thanks a lot. This works fine.
I just thought of using this one:
load( local!pramod: readexcelsheet( todocument(ri!document), 0, 1 ), local!pramodTest: a!forEach( items: local!pramod.result, expression: fv!index ), max(local!pramodTest))
I think yours looks more precise. Thanks again