Sign Up ›

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

Problem in Exporting the data to CSV

hii

 i wanted to export my data to csv 

anyone who can help me in this task.

 

this is my page when i click on export button  '/apex/googleChartsCSV 

 

<td><input id="exportCSV" type="button" onclick="window.open('/apex/googleChartsCSV?nam=' + Name + '&was=' + Waste + '&day=' +Days);" value="Export to CSV" style="display: none;"></input></td>

 

for(var i=0; i<result.length;i++){
var finalBean1= result[i];
if(finalBean1.AccName != null && finalBean1.WasteName != null && finalBean1.DaysTotal != null)
{
Names.push(finalBean1.AccName);
Wastes.push(finalBean1.WasteName);
Day.push(finalBean1.DaysTotal);

}
}
if (Names.length > 0) {
Name = Names.join(',');
Waste = Wastes.join(',');
Days = Day.join(',');
document.getElementById('exportCSV').style.display = 'block';
}

 

but the problem is when the page opens '/apex/googleChartsCSV it is having a very large query string with 1000 of values in Name variable 

 

any idea how can i use query string for showing all the values in excel

MagulanDuraipandianMagulanDuraipandian

http://infallibletechie.blogspot.in/2012/08/export-using-apex-code-in-salesforce.html

 

Check the above link.

 

Regards,

Magulan D

Salesforce.com certified Force.com Developer.

SFDC Blog

 

If this post is your solution, kindly mark this as the solution.
NishaCNishaC

actually i have used javascript remoting functionality in my controller code and wrapper class 

if u have any idea regarding this

then i can send you full code 
Anil MeghnathiAnil Meghnathi

Hi Nisha

i am not getting your point .please send me the full code of page and controller class.

 

 

Thanks

Anil