how can i check if an entire column has same value or an entire row has same value from a datatable.

Hi @SRASHTI_PATIL If you want to check the entire column with the same value you can use the below LINQ Expression, -> Bool_SameValue = If(dt_ExcelData.AsEnumerable().Select(Function(x) x("Column name").ToString()).Distinct().Count() > 1, False, True) Bool_SameValue is the boolean datatype variab…

Excel Automat

Help Studio

system (system) Closed January 23, 2025, 3:18am 5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.

Topic		Replies	Views
How can i check if an Excel column contains the same value in every cell? Activities datatable , excel , orchestrator , robot , activities , studio , studiox , question , linq	1	859	August 2, 2022
How to check all the values in a particular column is similar StudioX studiox , question	7	2258	October 20, 2021
A certain column contains a same value it should returns a boolean StudioX studiox , question	2	1062	October 19, 2021
Check if all the cells in a column have the same value Help datatable , studio , question	3	3862	September 15, 2020
How to check if there any duplicate data in a row from data table then output as Yes or No Activities question , system	8	623	August 29, 2023

Excel Automat

Related topics