i want to delete specific column from excel sheet by using their header
lets assume your datatable is dtTable1, please try this
give this in the column names
mark as solution if it is useful , lets other take advantage
happy automation …!!!
Delete column activity can be used to delete column from excel sheet
if we use that activity then what can i write in table name field?
Delete column activity from excel application scope activities.
Use excel process scope and use excel file activity inside the delete column activity should be used.These are workbook activity.I am talking about excel activity
To remove specific column in Datatable then use “Remove Data column” activity by mentioning column name or column index.
i’m using excel activities not workbook
& activity is inside excel scope
workbook dont have this activity
I am talking about the above activity
Delete column is a modern activity …please check from activities → filter incon if the show modern option is checked or not…
Then you can view modern activities
You can use the Delete column activity to delete a column in a datatable.
Refer this Link: