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 System.Windows.Markup UiPath.Core UiPath.Core.Activities Microsoft.VisualBasic.CompilerServices System.Activities.DynamicUpdate System.Collections.ObjectModel System.ComponentModel System.Runtime.Serialization System.Xml.Serialization UiPath.Excel UiPath.Excel.Activities System.Reflection System.Runtime.InteropServices UiPath.DataTableUtilities AttendedRobotStatus.Activities Microsoft.Activities.Expressions System.Globalization Microsoft.Activities UiPathTeam.XLExcel UiPathTeam.XLExcel.Activities 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.System.Activities.Design System.ValueTuple Microsoft.Bcl.AsyncInterfaces System.Memory UiPath.Excel UiPath.Mail UiPath.OCR.Activities.Design UiPath.UIAutomationCore System.ServiceModel UiPath.Excel.Activities AttendedRobotStatus Microsoft.Activities System.Collections.Immutable UiPathTeam.XLExcel UiPathTeam.XLExcel.Activities True 290,2.4 60,75.2 320,77.6 320,127.6 710 720.8 __ReferenceID0 220,127.6 200,68.8 True True True True [col.ColumnName] [col.ColumnName.Trim.ToString] True False [ZnaDate] 2018-02-07 True [row("ETB/NTB")] [row("Account Opening Date").ToString.Trim] [DateFormats] [{"MM/dd/yyyy HH:mm:ss","dd-MM-yyyy","MM/dd/yyyy","dd/MM/yyyy"}] [row("ETB/NTB")] ["Account Opening Date is Missing"] True True [row("ETB/NTB")] [DateTime.ParseExact(row("ETB/NTB").ToString.Trim, DateFormats, System.Globalization.CultureInfo.InvariantCulture, DateTimeStyles.None).ToString] [row("Account Opening Date")] [row("ETB/NTB")] True False True [row("ETB/NTB")] [DateTime.FromOADate(Cdbl(row("ETB/NTB").ToString.Trim)).ToString("MM/dd/yyyy HH:mm:ss")] [row("Account Opening Date")] [row("ETB/NTB")] [row("ETB/NTB")] ["ETB"] [row("ETB/NTB")] ["NTB"]