I have a table in particular sheet of excel file and the cell are all bordered for them till next 50 cells but when i try to read cell after 50 in that column it breaks just because of the below cells are not bordered. Can you please help me with the same
excelreadcellsbynumber( excelDoc: ri!document, sheetNumber: { 2 }, columnNumbers: { 7 }, rowNumbers: { enumerate( 100 ) + 89 } )
Error: Expression evaluation error at function 'excelreadcellsbynumber' [line 36]:
above expression breaks and the below one works
excelreadcellsbynumber( excelDoc: ri!document, sheetNumber: { 2 }, columnNumbers: { 7 }, rowNumbers: { enumerate(50 ) + 89 } )
only difference i can spot is the cells after 50 from cell line are all bordered. and when i border all those extra cells it starts working.
Please suggest, if this is expected behavior or am i doing something wrong
Discussion posts and replies are publicly visible
Hi,
Did you ever resolve this issue? I'm currently experiencing something similar, where I get the same error message, when in truth, everything looks correct.
My columns and rows also cannot to be bordered. I also want to find a solution like you.
time shooter 2
While executing function “excelreadcellsbynumber” I noticed, that, if you are trying to read a cell that is empty, it will throw an error.
If, potentially, there is a list of rows(local variable), that needs reading, but in the excel file the row is empty, it can cause the error occur while testing. Make sure that the range or rows are not containing empty cells in the excel file.
Image of the Error, when reading empty cell:
Image of functioning function:
I have reported this to Appian. Hopefully there will be something they can do to prevent this error.