Try adopting the following steps:
Read the Excel file to a data table.
for each row the data table and put the row value to 1. new data table
check if your row number ( counter ) is > than datatable.rows.count/2. If yes, put the res on 2. new datatable.
Save both new datatable in 2 difference Excels files