How to delete the specified ranged columns from excel?

Hi All,

I need to delete some specified columns from the excel i.e I need to delete column A,B,C and also from column J to column Z and remaining column should be remains as it is.
Please guide me how achieve this??


Please use this activity


Hi @Vrishchik

Try using delete column activity in the excel scope.


Use read range activity to convert it into datatable and use linq query
dt_name = dt_name.DefaultView.ToTable(False,“A”, “B”, “C”).copytodatatable()


use filter datatable activity

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.