local!excelFormatFromFile: readexcelsheetpaging( excelDocument: ri!excelFile, sheetNumber: 0, paginginfo: a!pagingInfo(1,1), numberOfColumns: 11 ).data.values[1]
Hi,
How can i achieve same result using index function instead of using ".data.values[1]"
Discussion posts and replies are publicly visible
Use index instead of a square-bracket positional indicator (i.e. "[1]") when you assume the ".values" array may be empty sometimes (but will always at least exist).
That would look like, roughly,
index( readexcelsheetpaging(...).data.values, 1, {} )
Thanks! Its working