Delete data row from data table

[aksh1yadav (AKSHAY YADAV)]

@Stefano_Skjupyter

thanks for the answer, i have a execution error saying, “Cannot perform ‘Like’ operation on System.Double and System.String”
What the reason for that? are all strings

Hey @Stefano_Skjupyter

The Column datatype is double in excel. Cross check please

Internally ReadRange gnerates DataTable with types set for all columns as Object, but individual cell types are determined by what type Excel assigned.
This means that a value of “aksh12” will be stored as a String, but “12” as a number (so Double).
You can check it by iterating and checking the Type of each object Too

so just try this : - dt.Select("Convert([ColName],System.String) like '%Forward:%'")

Reference Thread - DataTable Select function cannot perform “=” operation on System.Double and System.String - #12 by aksh1yadav

Regards…!!
Aksh