System.Activities
System.Activities.Statements
System.Activities.Expressions
System.Activities.Validation
System.Activities.XamlIntegration
Microsoft.VisualBasic
Microsoft.VisualBasic.Activities
System
System.Collections
System.Collections.Generic
System.Data
System.Diagnostics
System.Drawing
System.IO
System.Linq
System.Net.Mail
System.Xml
System.Xml.Linq
UiPath.Core
UiPath.Core.Activities
System.Windows.Markup
System.ComponentModel
System.Runtime.Serialization
System.Xml.Serialization
System.Reflection
System.Runtime.InteropServices
System.Runtime.CompilerServices
System.Activities
Microsoft.VisualBasic
mscorlib
System.Data
System
System.Drawing
System.Core
System.Xml
System.Xml.Linq
PresentationFramework
WindowsBase
PresentationCore
System.Xaml
UiPath.System.Activities
UiPath.UiAutomation.Activities
System.Data.DataSetExtensions
System.Runtime.Serialization
System.Collections.Immutable
System.Linq.Async
System.Linq.Async.Queryable
System.ServiceModel
Microsoft.Bcl.AsyncInterfaces
System.ValueTuple
System.ComponentModel.Composition
System.Memory
NPOI
System.Memory.Data
UiPath.UIAutomationCore
UiPath.OCR.Activities.Design
OfficeDevPnP.Core
UiPathTeam.SharePoint
System.Runtime.WindowsRuntime
True
[arrBlockColInfo]
[arrBlockIDX.Select(Function (x) Tuple.Create(x,"")).toArray]
[arrColInfo]
[dtData.Rows(1).ItemArray.Select(Function (x,i) Tuple.Create(i,x.ToString.ToUpper.Trim)).Where(Function (t) Not arrBlockIDX.Contains(t.Item1)).ToArray]
[arrDupColInfo]
[(From t In arrColInfo
Group t By k=t.Item2 Into grp=Group
Where grp.Count > 1
Select x = grp.First()).toArray]
[arrUniqueColInfo]
[(From t In arrColInfo
Group t By k=t.Item2 Into grp=Group
Where grp.Count = 1
Select x = grp.First()).toArray]
[arrUniqueColSet]
[(From t In arrUniqueColInfo.Concat(arrBlockColInfo)
Order By t.Item1
Select n = dtData.Columns(t.Item1).ColumnName).toArray]
[arrDupColSet]
[(From t In arrDupColInfo.Concat(arrBlockColInfo)
Order By t.Item1
Select n = dtData.Columns(t.Item1).ColumnName).toArray]
[dtUnique]
[dtData.DefaultView.ToTable(False,arrUniqueColSet)]
[dtDuplicated]
[dtData.DefaultView.ToTable(False,arrDupColSet)]