Datatable column

[sowmya (Sowmya Ravichandran)]

Remove data column is not deleting the column in excel datatable.
I want remove the column values in existing datatable. Given column name property.

[ddpadil (Dilip)]

Hi,
Remove data column works within an Excel data table not sheet.
You may use shortcut keys though.
example

[sowmya (Sowmya Ravichandran)]

not deleting the column I have tried using invoke method.

[ovi (Viorela Preda)]

Hi @sowmya

Why don’t you try with Delete Column activity directly?
In the example provided by Dilip the column is deleted from datatable, but not from the Excel sheet.

[aksh1yadav (AKSHAY YADAV)]

@ovi

Why don’t you try with Delete Column activity directly?

Hey @ovi

That activity will delete column from excel sheet if that excel is containing a table inside that excel sheet.

Activities

@ovi

is deleted from datatable, but not from the Excel sheet.

Well the Title of the Question is related with Datatable and question as well. I don’t know either she is edited or it was same

and an excel without table then you have to owerride the existing contain with new modified Datatable or a custom code will help in such case

Regards…!!
Aksh

[sowmya (Sowmya Ravichandran)]

Thank you