Remove lines from datatable until its empty

[ppr (Peter Preuss)]

Have a look here:

Process repeated for each multiple rows

@christine.tzenghy let me introduce a general approach that can be also adopted to more case specific details. Assumptons: DataTable with 8 Rows Segmentsize: 3 Following Building Blocks are used Calculation of the numbers of segments: [grafik] with the Ceiling method the fractions are uprounded to the next Integer with the Skip() and Take() Method the Rows for a segment can be retrieved. the different segments are bult by following [grafik] and do fetch the different segment rows by: …

Adding Sheets till specific value

@Daniyal_Tahir Logic is same a described in the links. It is just modified to write out the Excel Sheets Variables: [grafik] Flow: [grafik] Statements: NoOfSegments = Convert.ToInt32(Math.Ceiling(dtData.Rows.Count / SegmentSize)) segment = Enumerable.Range(0,NoOfSegments).ToList RowSet = dtData.AsEnumerable.Skip(segment*SegmentSize).Take(SegmentSize).toList Find starter Help: SplitTable_BySegmentSize_ToTable_WriteSheet.xaml (13.0 KB)