Selecting specific data from columns in xlsx excel spreadsheet

[SrenivasanKanna (Srenivasan kannan)]

Filter DataTable with multiple conditions

use ‘or’ instead of ‘and’ in your query… like below (from row in dt.Select() Where(row(“name”).ToString.Equals(“Siva”) or row(“name”).ToString.Equals(“Sai”) ) Select row).Count.ToString your query failed because no row in column ‘name’ can be “Siva” and “Sai” at the same time If there are more than 3 values for condition, I will suggest go for array check like below: (from row in dt.Select() Where({“A”,“B”,“C”}.contains(row(“name”).tostring)) Select row)