Split excel/csv file

[Aishwarya_Bhargava]

i have excel file that i want to split
like i have a file with 1051 records and i want to split this file into excel files having maximum 500 records each and the header in the master files should be copied in all the children files
so how to do it?

[ppr (Peter Preuss)]

@Aishwarya_Bhargava
find some starter help here:
ForEach_Segment_RowSets.xaml (11.8 KB)

refer to the dtRowset, which you can use for the slicing. The for each - RowSet you can remove if it is not needed.

[Aishwarya_Bhargava]

Can you please explain the script?

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