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.
Hey!
Try this:
- Read the excel using Read range->Output as dt
- Take one for each row in data table->Pass the dt
- 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