Large data to be exported to excel from datawindow

Hi I am new here and I will try my best to explain my question .

I have an issue where user is retrieving large data in the datawindow and trying to save it as excel sheet with SaveAs function. But the data is too large to save in one single excel sheet ,so I have to save it in multiple sheets with 50000 rows in each sheets ,can somebody help me with this approach ?