Excel Sheet Data Updatation in LINQ

[Shyam_Pragash]

Hi…

i have a excel sheet of Employee details try to update the value

if user is leave fill the value on empty has 00.00.00

Input file attached.

Attendance.xlsx (8.4 KB)

Expected Output

Thanks
Shyam

[Palaniyappan (Forum Leader)]

Hi

Use a assign activity like this

dt = (From r In dt.AsEnumerable
let ra = r.ItemArray.Select(Function (x) x.ToString.Trim.Replace(“”,“00:00:00”)).toArray()
Select dtCorrected.Rows.Add(ra)).CopyToDataTable()

For more details and discussions

LINQ query to update(replace)datatable in uipath

dt.Select(“[Col2] like ‘% %’”) This will give you list of data rows then use for each then check if condition row[Col2]=“” then take assign activity and give like this dt.Rows(dt.Rows.IndexOf(row))(“Col2”)=“NA”

Cheers @Shyam_Pragash