Split excel/csv file

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?

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.

1 Like

Can you please explain the script?