I have a step in my automation that pulls a range from a excel workbook. i then feed this dt into a for each row loop that pulls certain cell data from each row. the only problem is it’ll read the row item data regardless of if there is data in the cell or not. how can i get the for each loop to …

[image] JoshBurke: how can i get the for each loop to skip rows that don’t have any data in them? we can use a if condition inside the for each row loop and mention like this String.IsNullOrEmpty(row(“columnname”).ToString) this will validate whether that row and the column has null value o…

How to dynamically read a excel range in a for each row loop?

Help

Sasi.lalo (Sasikumar) September 25, 2019, 11:45am 4

Hi @JoshBurke

Kindly check this post.

Regads,
Sasikumar K

Topic		Replies	Views
Remove empty row in the excel Help	15	19203	October 29, 2018
Filter rows In Datatable Help	15	4175	October 29, 2018
If excel cell empty Help datatable , excel , uiautomation , activities	3	3601	June 22, 2018
Read only some rows in excel Help datatable , excel , activities , question	6	2490	February 13, 2020
Excel Read Row activity - check if blank/no data returned (ReFramework) Help	9	4000	July 23, 2019

How to dynamically read a excel range in a for each row loop?

Related topics