Remove data column not removing anything


#1

Hello, i have some strange problem - remove data column activity doesn’t delete it content. dtb
i’m trying to delete column using only index. And somehow it’s not working. Any advice?


#2

How many columns do you have? Columns are zero based so if you only have 4 columns, column 4 will be 3 (not 4)

Alternatively, could you use the column name instead? This would be a more robust approach.

RD


#3

Hi,
It’s not working :stuck_out_tongue: strange isn’t it. :slight_smile:
Tried with column name,index and with excel 2007/2010 still nothing is being deleted.
@badita @andrzej.kniola can you guys check and confirm.


#4

There’s more columns, about 15 of it, to be exact. Well, there’s one strange behavior exists:


The data in red rectangle is cleared. But i need the whole column to be deleted. Don’t get how this works at all. Why only this selection cleared? Just because there’s two blank rows below?


#5

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


#6

I’m using datatable, deleting column there, and then - exporting whole dtb table to excel.


#7

Hey @AlexanderKor

Yes there is something not able to find but you can try the below attached way as well.

Remove_Data_col_from_dt.xaml (7.1 KB)

pass the index of column which you want to delete in below image reference :slight_smile:

Regards…!!
Aksh


Datatable column
Invoke Method Video Tutorial
Use of Invoke Method
#8

Thanks, that worked!