I am facimg this error If: Object reference not set to an instance of an object

[VENKATESH2 (VENKATESH)]

this is image A1value is Null B value is Number check the condition put the colour. i was gave this condition in IF activity…“IsNothing(CurrentRow(“BUTERFLY”)) OrElse String.IsNullOrEmpty(CurrentRow(“BUTERFLY”).ToString.Trim)”…after run the bot i am getting this error. but some BUTTERFLY coloumn is NULL.

[lrtetala (Lakshman Reddy)]

Hi @VENKATESH2

Can you try this

String.IsNullOrEmpty(CurrentRow("BUTTERFLY").ToString) Or String.IsNullOrWhiteSpace(CurrentRow("BUTTERFLY").ToString)

Regards,

[VENKATESH2 (VENKATESH)]

same error throwing. please give another one

[Yoichi]

Hi,

If possible, can you share screenshot of the IF activity and the expression?

Regards,

[VENKATESH2 (VENKATESH)]

[Yoichi]

Hi,

Can you try the following expression?

CurrentRow("sample") is Nothing OrElse String.IsNullOrEmpty(CurrentRow("sample").ToString().Trim()) OrElse CurrentRow("venky") is Nothing OrElse String.IsNullOrEmpty(CurrentRow("venky").ToString().Trim())

Regards,

[sarvesh.b (Sarvesh)]

Hi @VENKATESH2

Try using this in if condition

Currentrow(“sample”).tostring=“” or Currentrow(“venky”).tostring=“”

[singh_sumit (Sumit Singh Tariyal)]

Hie @VENKATESH2 are you trying to paint on that cells which are empty in the excel
if yes can you check this

finally your output

cheers happy automation