Excel to get the results in continuous rows

Help
1

Hi Karthik
As u said by doing the Append range activity, it is displaying the result as expected but later few runs of execution it is just taking gap bw the rows and executing the result in excel how to over come this, I jus wanna get the result in continuing rows not to get any gaps bw each run of exection

2

Hi @sushma1
we can validate before appearing with append range activity with a assign activity like this
Yourdatatable = Yourdatatable.AsEnumerable().Where(Function(x) x.ItemArray.Any(Function(a) Not string.IsNullOrEmpty(a.ToString))).ToArray()…CopyToDatatable()

Cheers

1 Like