Retrieve data from excel and filter column


#1

Hi,
I have created excel doc and converted to .csv.Suppose there is column called score,I want to perform filter on it(say score>50) and retrieve it,but I am getting column name score not found error,eventhough I checked Include Column Name.
What should I do?


#2

@Rashmi_Maliger There is syntax error

Try this once Assign = yourdatable.Select(“score>50”)

Refer attached file Filter.zip (2.2 KB)


#3

Hi @indra,
I referred to your attached file. When i try to do it in my project. There is an error showing under for each row:
Value of type -1-dimensional array of System.Data.datarow’ cannot be converted to ‘system.data.datatable.’.
However my variabble types are filiteredRow is DataRow[] and dt is DataTable which is the same as your above attached file.


#4

system.datarow is the TypeArgument in for each. can you please check