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.