I am trying to read and write data from excel, but there seems to be a Problem with variables. Read row is taking System,collections.Generic kind while For EACH ROW seems to take data table. I am unable to fix the error
use for each activity instead of for each row
The result from a read row ist mit a datatable. So it conflicts. Use a for each instead
Sorry, I didnot understand what you are trying to say!
Sorry, I didnot get what you are trying to say!
Read row contains value of 1 row and all the column details, use for each to loop all the column values in a particular row
1 2 3 this is one row result form read row
So read row takes this row values as collection, so you can loop through column values
If you want to loop through rows use read range activity which will store multiple rows
1 2 3
4 5 6
7 8 9
Multiple rows read from read range activity
For each row is a subset method of for each activity,
For each row is designed for looping through each rows in datatable, while for each can be used to loop through any element from any type of collections.
That is the reason
Hope you got it