I am working on an excel sheet. I need to check if any cell of the sheet has value starting with “#”. I am reading the entre sheet data in a data table. Using for each data row will take too much time. Hence I am looking for LINQ query. Please guide for the query.

Hi, Do you need True or False as a result? If so, the following will work. dt.AsEnumerable.Any(Function(r) r.ItemArray.Any(Function(item) item.ToString.StartsWith("#"))) If there is cell which starts with “#”, the above returns True. Regards,

LINQ query for value search

Help Studio

ppr (Peter Preuss) February 18, 2022, 11:09am 4

@pandeypriyanka1312
have a look here:

Topic		Replies	Views
Need To filter excel column by using LINQ query Activities excel , activities , question	10	3240	February 13, 2022
Linq Query to Filter datatable - Contains Studio datatable , uiautomation , data_manipulation , linq , linq-query , linq-quey	10	1098	May 16, 2023
How to check if certain values are not found in specific column? Studio datatable , question	11	2003	December 21, 2021
Linq query to filter line items not starts with particular value Studio excel , studio , question	4	665	February 8, 2023
Need a linq query to solve this issue Studio studio , question , activities_panel , linq , linq-quey	10	443	September 8, 2023

Most Active Users - Yesterday
Anil_G
ashokkarale
jinal.shah
Gautham_Pattabiraman
postwick
chandreshsinh.jadeja
vrdabberu
Ajay_Mishra
sven.wullum1
Vyshnavi_Nalumachu
More details...

LINQ query for value search

Related Topics