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.Collections.ObjectModel System.Activities.DynamicUpdate UiPath.Database UiPath.Database.Activities System.Runtime.Serialization System.ComponentModel System.Xml.Serialization UiPath.Excel UiPath.Excel.Activities UiPath.DataTableUtilities System.Reflection System.Runtime.InteropServices 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.ServiceModel Microsoft.Bcl.AsyncInterfaces System.ValueTuple System.ComponentModel.Composition UiPath.Excel UiPath.Mail System.Memory UiPath.OCR.Activities.Design UiPath.UIAutomationCore UiPath.Database UiPath.Database.Activities UiPath.Excel.Activities.Design UiPath.Excel.Activities System.Runtime.WindowsRuntime True ["containerno"] ["description"] ["amount"] ["invoicenocol"] ["amoutcol"] ["datecol"] [df_clone] [df.copy()] [intStart] 0 True True False [row("invoicenocol")] [str_tempinvoiceno] True [str_tempinvoiceno] [row("invoicenocol").ToString] True False True False [list_df] [(From d In df.AsEnumerable Group d By col1=d("invoicenocol").ToString.Trim Into grp=Group Select grp.CopyToDatatable).toList] True [strDate] [group_dt.AsEnumerable.where(Function(x) Not String.IsNullOrEmpty(x("datecol").ToString)).Select(Function(x) x("datecol").ToString).Distinct()(0).ToString] [strTotalAmount] [group_dt.AsEnumerable.Where(Function(x) Not String.IsNullOrEmpty(x("amoutcol").ToString)).Select(Function(x) x("amoutcol").ToString).Distinct()(0).ToString] [intSkipRows] [(from x in group_dt where (Not String.IsNullOrEmpty(x("datecol").ToString)) select group_dt.Rows.IndexOf(x)).FirstOrDefault+1] [group_dt_copy] [group_dt.AsEnumerable.Skip(intSkipRows).CopyToDataTable] [str_tempcontainerno] True True False [row("containerno")] [str_tempcontainerno] True [str_tempcontainerno] [row("containerno").ToString] True False ["amount"]