Hi everyone, I made a consult from excel to obtain the cell value of certain row with linq, I built this expression “(From row In dtVariable.AsEnumerable() Where row (“Column4”).ToString.Contains(“TOTAL”) Select row (“Column10”))(0).ToString” and it works, this gives me the value of the total i…

Hi @marquezd Can you try below totalRow = (From row In dtVariable.AsEnumerable() Where row("Column4").ToString.Contains("TOTAL") Select row).FirstOrDefault() totalRowDataType: System.Data.DataRow rowIndex = dtVariable.Rows.IndexOf(totalRow) cellValue = totalRow("Column10"…

GET NUMBER OF ROW

Help Studio

marquezd (Marquezd) May 30, 2024, 6:06pm 5

Tnks both of you, it works with the solutions

2 Likes

Forum Engagement Daily Reports

Topic		Replies	Views
Finding row count Help datatable , excel	12	3120	November 2, 2019
How to get the number of rows in a particular Column in Datatable Activities excel , activities , question	11	2379	April 27, 2023
How to get the value for each row Studio studio , question , tools	8	4157	April 25, 2021
How get specific value from an excel sheet (part 3) included my working example, pls advise Studio studio , question , activities_panel	7	992	June 30, 2022
What if I don't use foreach to get the row number that the cell value in which row Help studio	4	1277	October 29, 2018

Most Active Users - Yesterday
Anil_G
Shakib
ashokkarale
sharu_priya
sven.wullum1
Babjee.Vangipurapu
Prathamesh_Trimurti_Hulav
riley
sharazkm32
A_Learner
More details...

GET NUMBER OF ROW

Related topics