Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
ShrutiShruti 

Export to Excel using Visualforce page

Hi,

 

Is there any way we can export more than 2000 records using Visualforce page to excel sheet?

 

Thanks,

Shruti

Best Answer chosen by Admin (Salesforce Developers) 
ShrutiShruti

Hi,

 

I was able to do this by creating list of list and using the list of list in Visualforce page.

 

Thanks

All Answers

kiranmutturukiranmutturu

firstly u can'y handle more than 1000 records in a vf page.. as datatable or repeat will take max 1000 only...

 

yes u can render as a excell by using content tyepe in apex page component ....
ShrutiShruti

I was able to export 2000 records using StandardSetController.. but I need to export more than that which I am not able to do
ShrutiShruti

Hi,

 

I was able to do this by creating list of list and using the list of list in Visualforce page.

 

Thanks

This was selected as the best answer
Raj_ThaparRaj_Thapar

Hi Shuruti,

 

Could you please share sample code how you have achieved this ?

 

Thanks
jrobbinsjrobbins

Open, scan, read, export excel files with the aid of following utility http://www.recoverytoolbox.com/repair_excel.html
s_k_as_k_a

Hi shruti,

 

I am unable to export more that 2000 records  into excel. Could you explain how to creat list of list  in VF page.
mark torresmark torres
Advanced and graphical user interface tool to recover corrupt or damaged Excel (.xls & .xlsx) files. Its scan corrupt or inaccessible excel files and recover your spreadsheets data.

Try:- http://www.recoverydeletedfiles.com/excel-file-recovery-tool.html