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.Excel System.ComponentModel System.Runtime.Serialization System.Xml.Serialization 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 System.Runtime.Serialization UiPath.Excel.Activities UiPath.Excel UiPath.Excel.Activities.Design System.Reflection.Metadata System.Memory UiPath.Word UiPath.Mail.Activities UiPath.UIAutomationCore UiPath.OCR.Activities UiPath.Word.Activities True True [SheetNo] [{0,1,2,3,4,5,6,7,8,9}] True [idxBlankRows] [(From i In Enumerable.Range(0,InputSheetOutput.Rows.Count) Where InputSheetOutput.Rows(i).ItemArray.All(Function (x) String.IsNullOrWhiteSpace(x.toString.Trim)) Select i).toList] [idxBlankRows] [{-1}.toList.Concat(idxBlankRows).toList] True True [tmpDataTable] [InputSheetOutput.AsEnumerable.Skip(idxBlankRows(idx)+1).Take(item - idxBlankRows(idx) - 1).CopyToDataTable] True