I want to extract a specific character from excel using foreach activity

I want to import from A7 (fixed cell range) to END character (A10-flexible cell range) through a loop through a foreach activity. The Excel format is like this.


HI @111398,

I’ll suggest you to use Lookup Range activity with value "end---" to get expected cell location. And create o/p var for this activity —> EndLoc (String)
Then you can simply use Read Range with range "A7:"+EndLoc (o/p var DT - of type datatable)
Now you can use For Each Row activity on DT, to iterate through all values by using assign
Value = row(0).ToString