Updating a DataTable in UiPath

Hi,

I have a DataTable with StudentID and and age columns.I have all the Student IDs but have to update one StudentID with age only.How to do it?

Thanks!

1 Like

@Asiri

  1. use Read Range Activity to read Data from Excel file and will give you output as ‘DataTable’

  2. Then use For Each Row Activity to itreate that dataTable.

ForEach row in DT
If row(“StudentID”).Tostring = “requried Id”
Then:
row(“age”).Tostring = “ageValue”

Then finally use Write Range to write into Excel file and pass that DataTable.

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.