Separate excel file if data have > 200 rows?

[fairymemay (noona)]

I want to check data if data have >200 row —> separate sheet data 1-200 row , 201-400 ,until end.

But if data <200. not change file

input.xlsx (11.8 KB)

output :
input_1.xlsx (9.3 KB)
input_2.xlsx (9.3 KB)
input_3.xlsx (7.9 KB)

[prasath17 (Guru)]

@fairymemay - Please check this post…and try as mentioned…

Split Datatable into 4 different tables

@thomasb82 lets assume following variables: [grafik] NoOfSegments is indicating how many splits we do want have Doing an integer division to find out how many rows will be in a split (we cannot fetch a rows count with fractions e.g. 14.25 rows [grafik] with following LINQ we can produce a list of datatables with the splits: [grafik] (From i In Enumerable.Range(0,NoOfSegments) Let opart = dtData.AsEnumerable.Skip(i*FullSegmentSize).toList Let spart = If(i = (NoOfSegments - 1), opart, opa…

[fairymemay (noona)]

@prasath17 How to apply this code?

[prasath17 (Guru)]

@fairymemay - Have you downloaded the xaml file?

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