Error while reading a range


#1

While reading a range in excel it is displaying the error “cannot get a numeric value from a error cell”jbng


#2

@mhk15,Refer this link https://blog.csdn.net/yitonglizihao/article/details/79819456


#3

Hello Mhk,

Are you trying to read a xls file that contain any formulas?

If so, try to add the Excel-> Read Range activity in a Excel Application Scope.

Also, please check your values in the excel.

The error is simply saying that you have a error cell. To see exactly which cell is blocking the reading in range, you can add a read cell activity, in a for each activity, and add a log with the cell index, to see where it’s stopping.


#4

But while using whole range without specifying the range it is able to read and write while giving it a condition based on range there is problem with column 8 which doesn’t contain any formulae… how to resolve this issue?