Updating a DataTable in UiPath

[Asiri (Asiri Gamage)]

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!

[lakshman (Ganta lakshman)]

@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.