I need to delete rows dynamically with “Contains” = systemexception not “equal to”. you can see in the attachment. [image]

[image] manipreethi410: error: no source due to we are removing all the rows of contains System.exception. Hi @manipreethi410 , Check out the below post which should help you on Handling that error : [image] ambulance sos [FirstAid] Handling of The source contains no DataRow…

How to delete particular row in excel?

Help Activities

sreejith.ss (Sreejith Ss) October 30, 2022, 6:33am 5

Hey @manipreethi410 please try this linq

datatable.asenumerable.where(function(row) not row(columnname or index).tostring.tolower.contains(“system.exception”)).copytoDataTable

Regards

Sreejith S S

Topic		Replies	Views
How to remove datatable data contains particular character and delete entire row using linq Help datatable , excel , activities , question	8	3521	December 6, 2019
Remove row from a particular string from data Table Studio studio , question , activities_panel	25	2863	September 4, 2022
Remove particular rows using LINQ Studio studio , question , activities_panel	17	1953	August 24, 2023
Unable to remove rows which contains zero from excel Studio excel , uiautomation , activities , studio , question , filter , filter-data-table	5	678	July 16, 2023
Using Linq to delete rows from datatable based on values in a list Studio datatable , linq	9	3427	August 12, 2023

How to delete particular row in excel?

Related topics