Get the error while filtering Excel file and assign to Data Table

[KM1996 (Kavita)]

Hi @nilesh.mahajan, please check this whole thread. It seems your issue has a relatively easy solution. Please let me know if it works:

Exception:Assign : Min (114) must be less than or equal to max (-1) in a Range object

Hi, all! If anyone is still getting this error, it is caused by type mismatch in the Column and the Select expression. It looks like your column is of type different than String and you have used the “'” to search for string in the Select statement. Try converting the Column data type in the select statement: dt1.Select("Convert([Column1], ‘System.String’) = ’ " + sSearchString + " ’ ") Cheers!