How to Automate Excel using LINQ Query in UiPath
Speaker - / pradeep-shiv-05562a190
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()
