Reading rows which are empty

Hi! I am looking to read rows from an excel file which are empty from the Opp Link column.

Here is the excel file,

This is the sequence I created however it throws an error,

Any guidance would be appreciated!

@mmishal001 Use filter datatable activity. Put column name in quotes “Opp Link” and choose Is Empty.
The output datatable will be with the rows you desired to have it.

Thank you for your quick response!

My For Each seems to be giving an error now,

This is the error message,

@mmishal001 You need to use For Each row Activity instead of For Each Activity :smiley:

Yes got it! Thank you for this!

I am also looking to write text to the next empty cell on excel. would you be able to guide with this please?