I have around 75000 rows of data to be displayed in Excel sheet, but the data is getting truncated after 65536 rows because of the limit on number of rows that Excel allows. Is it possible to remove the row limit in the excel? or is it possible to add a new worksheet dynamically whenever one worksheet is full with 65536 rows?

I am getting this large amount of data when I ran a nVision Report for Peoplesoft. In this, it runs a Query and outputs the result data to an excel sheet.

Thanks in advance for any help.