How to Automate Excel using LINQ Query in UiPath

Sample LINQ queries used in the video

To Fetch Max and Min Value from DataTable:

dataTableVar.AsEnumerable().Select(Function(row) row("ColumnName")).Max || dataTableVar.AsEnumerable().Select(Function(row) row("ColumnName")).Min || (From Rows In dataTableVar.AsEnumerable()
Let minimum = dataTableVar.AsEnumerable.Select(Function(row) CInt(row("ColumnName").ToString.Trim)).Min
Let maximum = dataTableVar.AsEnumerable.Select(Function(row) CInt(row("ColumnName").ToString.Trim)).Max
Select {min, max}).First.ToArray()

To Group DataTable based on the condition:

(From row in dataTableVar.AsEnumerable() Where row("ColumnName").ToString.Equals("StringYouAreLookingFor") Select row).CopyToDataTable()

To Fetch Top Records from DataTable:

dataTableVar.AsEnumerable().Take(N).CopyToDataTable()

[prashantrai]

Brother can u make a separate playlist of LINQ query and upload atleast 6 video in which covers those query which asked mostly during the interview.and can u send your what's group where I can asked u my query in case I have any doubt