Delete columns using workbook activity in UiPath Studio

[Karunamurthy (Karunamurthy Narasimhan)]

Hi,

I want to delete multiple columns (B and D to M)in an Excel file using Workbook activity. There is no option like “Delete Range, Delete column” as in Excel Application Scope.

[Pallavi_Shirodkar1 (Pallavi Shirodkar)]

Hi,

We have the activity called as Insert/Delete Columns you can try using that.

[Shiva_Nikhil]

@Karunamurthy

if you are required columns are few then use the below query to get the columns

dt1.DefaultView.ToTable(False,"Member ID#","Last Name")

use it in the assign activity

[AJ_Ask]

Hi @Karunamurthy

You can use the Delete column activity to delete a column in a datatable.

Hope this helps

[Karunamurthy (Karunamurthy Narasimhan)]

@Shiva_Nikhil

Do I have to set any argument? It is not working. Error - Member ID# not found.

[Shiva_Nikhil]

@Karunamurthy

dt1.Columns(0).ColumnName

before to the query use assign activity and rename the column name

after that use the query

dt1.DefaultView.ToTable(False,"Member Id","Last Name")