How to retrieve data from each rows in a datatable? I don`t want in csv or excel..I want to see via writeline activity


#1

how to retrieve data from each rows in a datatable? I don`t want in csv or excel…I want to see via writeline activity


#2

HI @debashishforyou,
You can have a look at these following activities:

  1. Excel applications cope: To set the target (Your excel file’s path).
  2. Read range activity: To read the data from excel file and get them in a data table.
  3. For Each Row Activity: To iterate through the data table.
  4. Assign the row to each variable: Value1=row(0).tostring and so on.
  5. Write Line activity to show your data in output pane.

You can take the help of get row item activity also. Just do some experiments so that you can learn more.

Regards,
Jiban