How to delete the specified ranged columns from excel?

[Vrishchik (Naveenkumar Shivaraju)]

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??

@vishal.kp
@Anil_G
@ushu
@ppr
@Yoichi
@supermanPunch

[Anil_G (Anil Gorthi)]

@Vrishchik

Please use this activity

https://docs.uipath.com/activities/docs/delete-column-x

cheers

[supriya117 (Supriya Allada)]

Hi @Vrishchik

Try using delete column activity in the excel scope.

or

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

or

use filter datatable activity