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

[nilesh.mahajan]

I am getting the below error while filtering the excel and store the data into Datatable.I am not able to identify what type of erro is this.

Below is my Excel file from where I want to filter data as per COMP_ID and create seperate files.

I have Attached my workflow and excel file for more reference.

Main.xaml (262.8 KB)

Upload file 4 May.xlsx (12.4 KB)

[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!