Object reference not set to instance of an object

Automation Studio
1

Hi,

I have 18.0 community edition. I have a process which has excel loop. Even though i set parameters, am continuously getting below error -

ExcelError
ExcelError1283×98 4.06 KB

2

Hi,

Check that the excel file that you are using do not have any blank row

Regards,
Amit Anand

3

Hi Amit,

Excel doesn’t have any blank row. There are 1-2 columns with no values.

4

Hi,

If you want to use columns with no value then use try catch block in your process and handle null exception while reading data accordingly as per your use case

Regards
Amit

5

Same process is working in 17.5 without any issue. But in 18.0, if the column used in process has some blank value then it is giving mentioned issue.

6

Hi,

There has been change in product behavior for performance enhancement. Earlier empty string was returned but now null object is returned, that is why you are getting mentioned error. Kindly handle the same by using try catch block in your process

Regards,
Amit Anand

7

Okay. Will try this. Thanks for help :slight_smile: