How to Delete Multiple Column Heading in Uipath

[Naga_Pradeep]

[shanmukh_pothamsetty]

you have insert/delete column activity or delete column activity

regards

[Naga_Pradeep]

Sorry @shanmukh_pothamsetty i want to delete (Name, Postion, Office, Age, etc…) delete one “Name”, “Postion”, etc…

[Madhavi (K)]

You want to delete only column headers or the columns itself?
If its deleting entire column, please refer,

Copy selected columns from one Excel file to another

@Paulissen What @Lahiru.Fernando said is correct. Just one change in it, if there are too many columns in excel and you want very few columns to be copied, then using remove datatable column will be an expensive process. Instead, use Filter data table. Using read range activity, read data from excel. Use Filter data table activity. In the Filter Wizard, Do not specify anything in Filter Rows tab. In output columns tab, Mark column selection mode to “Keep” and Under columns, add the colu…

[supermanPunch (Arpan)]

@Naga_Pradeep Check this Workflow:
RemoveRepeatingColumnNames.zip (8.3 KB)

Before Executing the Workflow, Check the Excel File Sheet1 which is the Input and Sheet2 which is the Output.
Delete the Sheet2.

Execute the Workflow. Check the Sheet2. Try with your Excel File. It Should work the same.

[Bhavik_Solanki]

Welcome to the community @Naga_Pradeep.

Can you please provide more information about what you want to achieve?
Because most of activities has option to exclude or include header so you may not require to delete it manually.
E.g. While using Read Range activity, just tick “AddHeader” option and it will convert header into column name and rest of data will be considered as rows.

Cheers