After adding all the data to datatable you can use write range to write the data in the Excel sheet
Regards Sudharsan