I am using excel which contain column name “marks”. I am using for each row activity to iterate to each row.
My requirement is, I need to store all values from column “Marks” into the single variable using “,”
Eg. 10,20,30
How to do that.
Use excel read column activity, this will give you result as IEnumerable datatype.
Then using string.Join(“,”, yourEnumObject") will give your the result as you are looking for.
Here yourEnumObject is my out value of read column activity.
If you do not need the column header then read from A2 or B2 instead of from header row.