Loop through Data Table and Use Cell as Type Into Value


#1

I have a Data Table that is 1 column and X rows. I’d like to loop through the data table and use each cell (e.g. A1, A2…An) as a the value for a Type Into.

  1. Do I use a For Each Row?
  2. For Type Into, what do I use as the “value”?

Thank you


#2

hi @mnease

1.you can use the WriteRange Activity to write into excel sheet.

Regards
Balamurugan


#3

@balupad14

To clarify, I don’t want to write into an excel sheet. The Type Into will be used in a web app, so I want to type the cell value into the web app, do a few other processes, and then move to the next cell value and type into the web app.


#4

Hi @mnease,

Yes
1.you can use the for each row
2. Inside the loop you can assign the Type Into to the value “row(0).ToString”

Regards
Balamurugan


#5

Thanks, that worked. Simple solution!