For each excel row, fill up to cell 15th if cell is empty

[Sudharsan_Ka]

HI @Ben_siu

Check with this expression

Before using this expression
you need to assign another dt

Dt2 = dt.Clone

(From r In dt.AsEnumerable
Let ra = r.ItemArray.Select(Function (x)  If(String.IsNullOrEmpty(x.tostring),"you can give whatever string you need",x.ToString)).toArray()
Select Dt2.Rows.Add(ra)).CopyToDataTable()

It will replace all the empty value to whatever string you need

Screenshots

Hope This Helps

Regards
Sudharsan