Delete Range (Columns) in Excel file

[Hulya_Cetinkaya (Hülya Çetinkaya)]

Hi, i want to delete D:N columns. I use Delete Range Activity, i write “D:N” to Range Property but it doesn’t work. When I write D1:N200 also doesn’t work. Do you have an idea?

[kirankumar.mahanthi1 (Kirankumar Mahanthi)]

Hi,

Use insert/delete column activity to delete the columns directly in excel.

Insert/Delete Columns

[Robinnavinraj_S]

hi @Hulya_Cetinkaya

please use remove data column activity

specific the column name

Thanks,

[Hulya_Cetinkaya (Hülya Çetinkaya)]

I have tried Delete Column Activity but same problem, it doesn’t work when i give range “D:N”. No format it accepts.

[kirankumar.mahanthi1 (Kirankumar Mahanthi)]

No you have to provide the number of columns you have to delete and position where you start delete. in our case number of columns should be 11 and position should be 4. you have to keep this activity inside of excel application scope.

Please refer the attached sample work flow. thanks.
ExcelColumn Delete Demo.zip (9.3 KB)

[balupad14 (Balamurugan (BalaReva))]

Hi @Hulya_Cetinkaya ,

Can you try this one ?

Delete last two columns data and write rest of it in excel

Hi @som17, To delete the column you can use the below activity . Video explanation . [Uipath | excel delete rows | excel delete columns | excel copy as picture (BalaReva)] To save as CSV. Use saveas activity . [image] Regards Balamurugan.S

Regards
Balamurugan.S

[NervYerem]

I have tried Delete Column Activity but same problem, it doesn’t work when i give range “D:N”. No format it accepts.

The ‘Delete column’ is a different activity. Try “Insert/Delete Columns”, starting on the 4th column, and remove 11 columns. Make sure to change the mode to “Remove”:

[Srini84 (Srinivas Kadamati)]

@Hulya_Cetinkaya

Also you can try as Filter datatable and you can list the column’s

Hope this help you

Thanks