Filtering Excel using Select method

[Palaniyappan (Palaniyappan P)]

Hi
Kindly add this assembly reference to your main.xaml by opening that in notepad and then try mentioning copytodatatable once on opening studio

Also ensure that eligibleExcelData is variable of type System.Data.Datatable

AsEnumerable is not a member of 'System.Data.Datatable'

When trying to use the AsEnumerable() method on a data table, i receive a error stating that AsEnumerable is not a member of ‘System.Data.Datatable’. I’ve seen someone else with this problem and their solution was to use temporary data table activities in their project to load in the System.Data.DataSetExtension library. However this has not worked for me. Any help would be greatly appreciated. Thank you.

Cheers @Saikat_Chowdhury