How to delete specific column?

[prasath_S]

Hi @Dorothy_lee

Remove data column will remove column from datatable and not the excel file, if you want to delete columns from excel refer this post,

Delete multiple CSV or Excel columns and column range

You can use invoke VBA activity for this, Do this one time on excel, In order for this activity to work, Trust Access to the VBA project object model must be enabled from Excel (File > Options > Trust Center > Trust Center Settings > Macro Settings > Select the Trust Access to the VBA project object model check box). Put the code on text file, Sub macro() Range(“AC1”).entirecolumn.delete Range(“CM1”).entirecolumn.delete Range(“CO1”).entirecolumn.delete Range(“CQ1”).entirecolumn.delete R…

If you want to remove multiple columns from datatable , please use this package (use Remove Particular columns activity)

DataTable Manipulation - RPA Component | UiPath Marketplace | Overview

Thanks