Split excel files based on Size or count

[sbxr]

Hi ,

i want to split an excel file based on count or size. how to achieve this scenario. the excel which i have is having 500000 records and i want to divide the files into 100000 records per file with headers.

Regards