Hello, I have datatable. I want find last row column ID and column Name by not user loop Please guide me for solve it. Thank you

@Stef_99 , This should give you Last Non-Empty Row Number for Column “ID” dt.AsEnumerable().Select(Function(row, index) New With {Key .Index = index, Key .Row = row}).Reverse().First(Function(x) Not String.IsNullOrWhiteSpace(x.Row("ID").ToString)).Index + 2 This will give you Last Non-Empty Row Nu…

Find last row by refer column name

Help Activities

V_Roboto_V (V Roboto V) March 3, 2025, 7:15am 3

Hi @Stef_99

I am a bit confused, you want the last row based on Column Name??

Topic		Replies	Views
Get last column with row value Studio	6	7016	March 21, 2022
How do I get the last value in Column A? Learning Hub excel	17	6305	June 22, 2020
How to get the last row index of a Specific column in a DT? Studio datatable , excel , studio , question	6	1996	October 24, 2022
Get the data from last column from an excel sheet when the column number is not known Help datatable , excel	5	3551	April 27, 2018
Find last column in excel? Activities excel , activities , question	5	4389	June 28, 2021

Find last row by refer column name

Related topics