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 GlobalVariablesNamespace GlobalConstantsNamespace System.Collections.ObjectModel System.Reflection System.ComponentModel System.Runtime.Serialization System.Xml.Serialization UiPath.Excel UiPath.Excel.Activities 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 UiPath.Studio.Constants System.Private.CoreLib System.ObjectModel System.Reflection.DispatchProxy System.Reflection.TypeExtensions System.Reflection.Metadata System.Private.Xml UiPath.Workflow NPOI System.Memory.Data System.ComponentModel.TypeConverter System.Console System.Configuration.ConfigurationManager System.Security.Permissions System.ComponentModel System.Memory System.Private.Uri System.Private.ServiceModel System.Collections System.ComponentModel.EventBasedAsync Microsoft.Win32.Primitives System.ComponentModel.Primitives System.Runtime.Serialization.Formatters System.Private.DataContractSerialization System.Runtime.Serialization.Primitives System.Data.Common UiPath.System.Activities.Design UiPath.Excel.Activities.Design UiPath.Excel.Activities UiPath.Excel True True [arrTriggerIndex] [(From i In Enumerable.Range(0, dtData.Rows.Count) Where dtData.Rows(i)(0).ToString.Trim.Equals(strSplitTrigger) Select x = i).toArray] [arrSkippers] [arrTriggerIndex.Select(Function (x) x +1).toArray] [ListSkipTakePairs] [arrSkippers.Zip(arrSkippers.Skip(1).Append(dtData.Rows.Count + 1), Function (x,y) new Int32(){x,y - x - 1}).ToList] [strSplitTrigger] Line True True [GroupMemberRows] [dtData.AsEnumerable]