I have four columns in a excel with the values, I want to filter the excel with known 2 values of a column, where one value present in one column and other value is on other column and check whether they present in the excel or not, if it is present then I want filter the whole matched row and put it to the datatable , write it to the new excel ?
hope this expression would help you
yourdatatablename.Select("[yourcolumnname1] = ‘value’ AND [yourcolumnname2] = ‘value’ ").copytodatatable()
coming some error saying that value is not present.
I gave the proper column names and values.
can i see your expression been used may be with a screenshot
dataTable.Select("[Item Number] = ‘10101404’ AND [Business Unit] = ‘370220’ ").copytodatatable()
Data.xlsx (9.1 KB)
above are the excel sheet and the code that I used.
Thank You, It’s Working.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.