+ Start a Discussion
satishch_sfdcsatishch_sfdc 

How to export bulk records to excel from visual force page

Hi,

I have requirement to display and export around 30,000 records in around 30 columns  (from 3 objects having relationship).I am able to display records in the visual force page using pagination(10 per page). But i am not able to export the records.I am able to export the records using list<list> concept but it is taking time around 4-5 min to download the excel file (perfomance slow).I tried with future method and batch,but no luck.please give me any better solution to overcome this obstacle.Thanks in advance

Thanks,
Satish
 
Leslie  KismartoniLeslie Kismartoni
Youre requirements sound specific, but here are two ideas off the top of my head:
  1. For smaller sets, I like Enabler (I use the version with Google Sheets) (https://appexchange.salesforce.com/listingDetail?listingId=a0N3000000B3GBzEAN)
  2. For really large sets, you can backup/export all SFDC data, then use the CSV data it generates. (https://help.salesforce.com/apex/HTViewHelpDoc?id=admin_exportdata.htm)
tggagnetggagne
I would checkout Enabler for Excel (https://www.enabler4excel.com/).  It's an incredibly smooth and easy-to-use plugin for Excel -- as long as you're on Windows.  I don't think there's a version available for Macs.
Leslie  KismartoniLeslie Kismartoni
(Hence why I use Google Sheet - Enabler works well for the Mac on there...)