I have a requirement where I want to render page as excel file with maximum 50000 records. I have tried all the below approaches but none of below are working. As a result now we need to create an admin process where support team person is going to download records using standard report.We have a sales force site, where visual force pages are added.On one of such page, there is some button on click which we need to achieve this functionality. Approaches already tried: 1. Wrapper class to display the records 2. Read Only attribute set to TRUE on Visual force page 3. List of List of Sobject in order to reduce the size of list on page(within limit on Sales force) 4. Displaying records in .csv format. 5. Calling the method returning required records using remote action.
If any one has worked on such requirement, kindly help me.