How to add data in datatable columns

Help Activities
, ,
2

Hi @vinjam_likitha

  1. Read the input excel using read range to a datatable say dt_data

  2. Filter the data to a datatable say dt_result
    dt_result = dt_data.AsEnumerable().Where(Function(row) row("LOCKBOX NBR").ToString.Equals("200")).Select(Function(x) dt_data.Clone.Rows.Add(x.ItemArray.Take(5).Concat({"Completed",transactionNumber}).ToArray) ).CopyToDataTable
    Give the necessary condition in the where clause .

  3. Write the dt_result data to a new output sheet using write range

Thank you !
Hope this helps!