Export vf page:


<apex:page controller=”ExportCtrlr”>

<!– Javascript –>
<script type=”text/javascript”>
function callFetchFields()
{
Fetch();
}
</script>
<!– Javascript –>

<!– CSS –>
<style type=”text/css”>
td
{
text-align:center;
}
</style>
<!– CSS –>

<apex:form >

<apex:actionFunction name=”Fetch” action=”{!fetchFields}” reRender=”entire”/>
<apex:pageblock id=”entire”>
<table cellspacing=”15″ cellpadding=”10″>
<tr>
<td><apex:outputLabel value=”Select Object”/></td>
<td colspan=”2″>
<apex:selectList size=”1″ value=”{!obj}” onChange=”callFetchFields();”>
<apex:selectOptions value=”{!objs}”/>
</apex:selectList>
</td>
</tr>
<tr>
<td>
<apex:selectList size=”6″ multiselect=”true” value=”{!selFieldNames}” >
<apex:selectOptions value=”{!soFieldNames}”/>
</apex:selectList>
</td>
<td>
<br/><apex:commandButton value=”>>” action=”{!addFields}” reRender=”entire”/><br/><br/><br/>
<apex:commandButton value=”<<” action=”{!removeFields}” reRender=”entire”/>
</td>
<td>
<apex:selectList size=”6″ multiselect=”true” value=”{!selAvaFieldNames}” >
<apex:selectOptions value=”{!soAvailablefieldNames}”/>
</apex:selectList>
</td>
</tr>
<tr>
<td colspan=”3″><apex:commandButton value=”Export” action=”{!exportFun}”/></td>
</tr>
</table>
</apex:pageblock>
</apex:form>
</apex:page>


ExportCtrlr apex code:


public class ExportCtrlr 
{
public Map<String, Schema.SObjectType> objs {get; set;}
public String obj {get;set;}
public List<String> objFields {get;set;}
public List<String> selFieldNames = new List<String>();
public List<String> selAvaFieldNames = new List<String>();
public List<String> availableFieldNames = new List<String>();
public String sql = ”;

public ExportCtrlr()
{
objs = Schema.getGlobalDescribe();
List<Schema.Sobjecttype> temp = objs.values();
obj = String.valueOf(temp.get(0));
System.debug(‘First Object is ‘ + obj);
fetchFields();
}

public void fetchFields()
{
availableFieldNames.clear();
Map<String , Schema.SObjectType> globalDescription = Schema.getGlobalDescribe();
Schema.sObjectType objType = globalDescription.get(obj); 
Schema.DescribeSObjectResult r1 = objType.getDescribe(); 
Map<String , Schema.SObjectField> mapFieldList = r1.fields.getMap();
objFields = new List<String>();
        for(Schema.SObjectField field : mapFieldList.values())  
        {  
            Schema.DescribeFieldResult fieldResult = field.getDescribe();
            System.debug(‘Field Name is ‘ + fieldResult.getName());  
            if(fieldResult.isAccessible())  
            {  
                objFields.add(fieldResult.getName());
            }  
        }
        System.debug(‘Fields are ‘ + objFields);
}

public pageReference exportFun()
{
Integer i =0;
Integer len = availableFieldNames.size() – 1;
sql = ‘SELECT ‘;
for(i = 0; i < availableFieldNames.size(); i++)
{
if(i != len)
{
sql = sql + availableFieldNames[i] + ‘,’;
}
else
{
sql = sql + availableFieldNames[i] + ‘ FROM ‘ + obj;
}
}
System.debug(‘Selected Object is ‘ + obj);
pageReference pg = new pageReference(‘/apex/ExportAsCSV?objName=’+obj+’&soql=’+sql);
pg.setRedirect(true);
return pg;
}

public List<SelectOption> getsoFieldNames()    
    {          
         List<SelectOption> options = new List<SelectOption>();
         for(String temp:objFields)
         {     
         options.add(new SelectOption(temp,temp));
         }      
         return options;    
    }
    
public List<SelectOption> getsoAvailablefieldNames()    
    {          
         List<SelectOption> options = new List<SelectOption>();
         for(String tmp:selFieldNames)
         {
          availableFieldNames.add(tmp);
         }
         for(String temp:availableFieldNames)
         {     
         options.add(new SelectOption(temp,temp));
         }      
         selFieldNames.clear();
         return options;    
    }   
    
     public List<String> getselFieldNames()     
     {      
         return selFieldNames;    
     }        
     public void setselFieldNames(List<String> selFieldNames)     
     {      
         this.selFieldNames = selFieldNames;    
     } 
     
     public List<String> getselAvaFieldNames()     
     {      
         return selAvaFieldNames;    
     }        
     public void setselAvaFieldNames(List<String> selAvaFieldNames)     
     {      
         this.selAvaFieldNames = selAvaFieldNames; 
     }
     
     public void addFields()
     {
      Integer i = 0;
      for(String tmp:selFieldNames)
         {
             selAvaFieldNames.add(tmp);
             for(i = 0; i<objFields.size(); i++)
             {
                 if(objFields[i] == tmp)
                 {
                     objFields.remove(i);
                 }
             }                          
         }    
     }
     
     public void removeFields()
     {
      Integer i = 0;
      for(String tmp:selAvaFieldNames)
         {
             objFields.add(tmp);
             for(i = 0; i<availableFieldNames.size(); i++)
             {
                 if(availableFieldNames[i] == tmp)
                 {
                     availableFieldNames.remove(i);
                 }
             }                          
         }
     }
}


ExportAsCSV vf Page:


<apex:page controller=”ExportAsCSV” action=”{!exportToCSV}” cache=”true” contentType=”application/vnd.ms-excel#export.csv” language=”en-US”>
{!fieldNames}{!newLine}<apex:repeat value=”{!objLst}” var=”object”><apex:repeat value=”{!flds}” var=”field”>{!object[field]}{!coma}</apex:repeat>{!newLine}</apex:repeat>

ExportAsCSV Apex Code:


public class ExportAsCSV 
{
public List<sObject> objLst {get;set;}
public String obj;
public String soql;
public String fieldNames {get;set;}
public List<String> flds {get;set;}
public String coma {get;set;}
public String newLine {get;set;}

public ExportAsCSV()
{
coma = ‘,’;
newLine = ‘n’;
obj = System.currentPageReference().getParameters().get(‘objName’);
soql = System.currentPageReference().getParameters().get(‘soql’);
System.debug(‘Selected Object is ‘ + obj);
}

public void exportToCSV()
{
fieldNames = soql.subString(7,soql.indexOf(‘ FROM’));
flds = fieldNames.split(‘,’);
  objLst = Database.Query(soql);
}