I am trying to export data from SP to a .xlsx sheet. Total no of rows is more than 15000 with total of 13 columns.The data is generated with the help of SQL Server SP. Till this point it is working fine. However while exporting to excel I do not get any data , the excel has blank content.
If I have records less than 12000 it generated the excel report with relevant data. However as row increases the report is blank.
Also the excel is generated through the code but when I deploy to server and try to generate it generates a blank excel.
Please advice what needs to be done. I have tried multiple options but none works.
View Complete Post