Skip to main content
prashantm206
New Participant
Jun 8, 2021 6:57 AM UTC
Question

ExcelReadbycellnumber breaks

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

3 replies

mairisb2806
New Participant
May 8, 2023 1:19 PM UTC

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.

New Participant
May 16, 2023 9:16 AM UTC

My columns and rows also cannot to be bordered. I also want to find a solution like you.

time shooter 2

mairisb2806
New Participant
May 16, 2023 10:03 AM UTC

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.