How to add value in excel row sequentially

Help Studio
, ,
5

Hi @rsr.chandu ,

Kindly check this

Xaml
15.xaml (11.3 KB)

list_ShipmentID

(From row In in_dt.AsEnumerable() Select Convert.ToString(row("ShipmentID").ToString)).ToArray.where(Function(x) Not String.IsNullOrWhiteSpace(x)).tolist

list_Status

(From row In in_dt.AsEnumerable() Select Convert.ToString(row("Status").ToString)).ToArray.where(Function(x) Not String.IsNullOrWhiteSpace(x)).tolist