Split excel file with dynamic row count

[ppr (Peter Preuss)]

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: …

And also:

Split the output data table into smaller data table which contain 50 rows per data table

can be done with skip take: in the combination with copytodatatable split results are datatables: In Additiona to above find a compacted variation: Assign Activity: SegmentSize | Int32 = 50 Assign Activity: NoOfSegments | Int32 = Convert.ToInt32(Math.Ceiling(dtData.Rows.Count / SegmentSize)) Assign Activity: TableList | List(Of DataTable) = Enumerable.Range(0,NoOfSegments).Select(Function (x) dtData.AsEnumerable.Skip(x*SegmentSize).Take(SegmentSize).CopyToDataTable).ToList() For each…