Excel Sheet Data Updatation in LINQ

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

image

Thanks
Shyam

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

Cheers @Shyam_Pragash