Replace Excel Cell value

[Tarif_Mohammad (Parth)]

Hello Every One ,

I have the following Excel Datatable:

Task is to check all the cell values and only if any of them is empty i have to replace them with a Zero ‘0’.

Can anybody help me with this please

thanks in advance

[hasib08 (Motiwala Hasib)]

Refer this Post

LINQ query to update(replace)datatable in uipath

@Rachel7 this is maybe a too quick shot as it replace any space in any column to NA and returns a datatable. But you can give a try (From r In dtData.AsEnumerable Select ia = r.ItemArray.toList Select ic = ia.ConvertAll(Function (e) e.ToString.Trim.Replace(" ","NA")).toArray() Select dtCorrected.Rows.Add(ic)).CopyToDataTable() NEW VERSION, simplified: (From r In dtData.AsEnumerable let ra = r.ItemArray.Select(Function (x) x.ToString.Trim.Replace(" ","NA")).toArray() Select dtCorrected.Rows.…