Read Username & Date and modify date at end of script datatable

Help
, , , ,
2

Hi @Munish_Jain,

This is doable in a small workflow. Your approach should be:

  1. Reading the excel file and store the values in a datatable
  2. Use the For Each Row activity (datatable activity) and within it we loop until we find the “RequiredUser”
  3. When we find the “RequiredUser”, we update the corresponding value in the Date column to the “RequiredDate/Time”
  4. Finally, write the processed datatable either in the same input file or in generate a new modified.xslx file using Write Range activity in the excel scope.

I have attached a solution EditUserRecords.zip (35.4 KB), which peforms these following steps. Since my input data was in Date format, I used the solution from this thread to update the date column to datetime type.
Hope this helps!

1 Like