Loop through rows

as I have an excel sheet which has some rows. I need to print all the rows name
I don’t know how to do it.

Hi,

Refer to the video below

Or

Compelete the course to understand more about this topic

Hey!

Try this:

  1. Read the excel using Read range->Output as dt
  2. Take one for each row in data table->Pass the dt
  3. Use one Assign Activity and pass the expression like this
CurrentRow("ColumnName").ToString.Trim

Now use message box to display the Rows one by one…

Regards,
NaNi

Hello.

Read the file/sheet with the read range, store that information in an output data table.
Then use the “For each row” activity where you will insert the data table obtained above.
From there, inside the for each row, you can get whatever you want. (example: CurrenRow(“ColumnName”).ToString)

Hug

please use output datatable activity and its output is string and you can directly write entire table in single attempt