Remove the row in data table

Help
1

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,

Capture2
Capture21028Ă—107 5.13 KB

Thanks.

2

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.

Regards

Please Update

1 Like
3

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

4

Use the filter dataTable Activity

5

Screenshot%20(13)
Screenshot%20(13)1366Ă—768 74.4 KB

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

1 Like
6

Hi,

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

thanks

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