Excel coloumn operations

After itrrating column how to fetch each column value and store it in different variable

hi @Bhagyashri
I hope you are getting data table from excel file afterwords follow the following steps.

  • Use For each row activity to iterate data from data table row by row.
  • Inside for each row use Get Row Item and mention column name or the Index of the column.
  • You can get the value in the variable using row(“Yourcolumname”).toString .
  • do all the above steps for every column this way you can get the values of columns in variable.
1 Like

I will try it and willet u know…is it working .thank you