i want to delete specific column from excel sheet by using their header

hi, lets assume your datatable is dtTable1, please try this {dtTable1.Columns(2).ColumnName.ToString,dtTable1.Columns(3).ColumnName.ToString,dtTable1.Columns(4).ColumnName.ToString,dtTable1.Columns(5).ColumnName.ToString} give this in the column names mark as solution if it is useful , lets othe…

Hi @pravin_bindage [image] How to delete specific column? Activities Hello:) I’d like to delete specific column as below(Yellow Remarked) which is C:F Could you please help for how to set properties? [image] [image] https://docs.uipath.com/lang-ru/activities/docs/…

if we use that activity then what can i write in table name field?

Delete column activity from excel application scope activities.

[Screenshot (346)] input - position i wants to delete column based on header name

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

Hi @pravin_bindage To remove specific column in Datatable then use “Remove Data column” activity by mentioning column name or column index. [image] thanks!

i’m using excel activities not workbook & activity is inside excel scope workbook dont have this activity

https://images.app.goo.gl/S1Mysj6jpqvum [Screenshot_20230110-222220] I am talking about the above activity

@pravin_bindage 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 Cheers

Delete specific column

Help Activities

sangeethaneelavannan1 (Sangeetha Neelavannan) January 10, 2023, 10:54am 3

Hi @pravin_bindage

https://docs.uipath.com/lang-ru/activities/docs/delete-column-x
Delete column activity can be used to delete column from excel sheet

Topic		Replies	Views
Delete columns in Excel based on Column Name Activities excel , activities , question	7	3319	April 1, 2021
Datatable column Help datatable , excel , activities	5	2881	September 18, 2017
How to delete columns by name in Excel? Help datatable , excel , studio , question	13	6300	November 19, 2020
Delete Column Studio uiautomation	19	1637	January 19, 2024
How to delete specific column? Activities excel , activities , question	7	2817	May 13, 2021

Delete specific column

Related topics