Remove the row in data table

Can any one tell how to remove the row (Total) in the data table which is in the last row of the sheet. Following is the screenshot,


Use Filter DataTale

check Remove radio btn after that provide first ColumnName in column textbox and select Contains after that put Total in the Value textbox.


Please Update

1 Like

Sorry @Himanshu.joshi, didn’t understand , can you once explain what your approach is!!

Use the filter dataTable Activity

column provide your data table first “column name” and in value write “Total”

1 Like


bro this filter datatable activity is not working fine in my case
please have a look


DataTableAutomation2.xaml (11.7 KB)
strData1.xlsx (13.4 KB)