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 UiPath.BAF.Enums UiPath.Swagger.Models UiPath.CodeGen.Models.Connection UiPath.Smartsheet.Models UiPath.BAF.Models.Connection UiPath.BAF.Models.Connection.APIConnection System.Reflection System.Runtime.InteropServices UiPath.BAF.Telemetry UiPath.BAF.Activities.ContextModel UiPath.BAF.Models UiPath.BAF.ServiceInterfaces System.Collections.ObjectModel UiPath.Smartsheet.Activities System.Activities.DynamicUpdate UiPath.CodeGen.Activities UiPath.BAF.Activities System.ComponentModel System.Runtime.Serialization System.Xml.Serialization UiPath.Excel UiPath.Excel.Activities Microsoft.VisualBasic.CompilerServices System.Activities Microsoft.VisualBasic mscorlib System.Data System.Data.DataSetExtensions System System.Drawing System.Core System.Xml System.Xml.Linq PresentationFramework WindowsBase PresentationCore System.Xaml UiPath.System.Activities UiPath.UiAutomation.Activities UiPath.Smartsheet System.Memory UiPath.Smartsheet.Activities System.ServiceModel Microsoft.Bcl.AsyncInterfaces System.ValueTuple System.ComponentModel.Composition UiPath.Excel UiPath.Mail UiPath.OCR.Activities.Design UiPath.UIAutomationCore UiPath.Word System.Runtime.Serialization UiPath.Excel.Activities.Design UiPath.Excel.Activities System.Collections.Immutable System.Runtime.WindowsRuntime True [list_1] [New List(Of Int32)] True [dt1] [dt.clone] [dt2] [dt.clone] [list] [dt.AsEnumerable.Where(Function (x)x(0).ToString ="Subject: [YCS] Shift Summary Report").ToList] True [index] [dt.Rows.IndexOf(item)] [list_1] [index] [dt1] [dt.AsEnumerable.Take(list_1(1)).Skip(list_1(0)).CopyToDataTable] [dr] [dt1.AsEnumerable.SingleOrDefault(Function (x) x(0).ToString.Contains("Individual PM Container done"))] [index] [dt1.Rows.IndexOf(dr)] [dt2] [dt1.AsEnumerable.Skip(index + 2).CopyToDataTable] True [dt1] [dt.AsEnumerable.Skip(list_1(1)).CopyToDataTable] [dr] [dt1.AsEnumerable.SingleOrDefault(Function (x) x(0).ToString.Contains("Individual PM Container done"))] [index] [dt1.Rows.IndexOf(dr)] [dt2] [dt1.AsEnumerable.Skip(index + 2).CopyToDataTable]