Separate excel file if data have > 200 rows?

[prasath17 (Guru)]

@fairymemay - I have found another thread where PPR provided different approach …

Split_Datatable_Rows.zip (48.1 KB)

Run this workflow as is, you will see 3 files will be created in the project folder…I have just added couple of steps and created the output…

Here is the reference to the post…

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