Reading rows which are empty

[mmishal001 (Mohammed Mishal)]

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!

[Sugumar8785 (Sugumar Ramachandran)]

@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.

[mmishal001 (Mohammed Mishal)]

Thank you for your quick response!

My For Each seems to be giving an error now,

[mmishal001 (Mohammed Mishal)]

This is the error message,

[supermanPunch (Arpan)]

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

[mmishal001 (Mohammed Mishal)]

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?

How to write to next empty cell on excel?

Hi all, I am looking to write a URL that I get from a website to the next empty cell in a column on excel. I have the below formula however this overwrites the URL from the second cellonwards, [image] Any guidance is appreciated!