How to download to particular employee details using custom object to excel sheet using visualforce page

Question

I am trying like this but its not getting exact output.

Visualforce page:

<apex:page controller="MyControlleremployee" tabStyle="employee__c">

<apex:form >
  <apex:pageBlock id="blockId" title="Employee Details">
    <apex:pageblocktable value="{!myemployees}" var="emp">
         <apex:column >
         <apex:facet name="header">{!$ObjectType.employee__c.fields.name.label}</apex:facet>
             <apex:inputField value="{!emp.name}" rendered="{!tobeEdited == emp.id}"/>
             <apex:outputField value="{!emp.name}"  rendered="{!!(tobeEdited == emp.id)}"/>
         </apex:column>
         <apex:column >
         <apex:facet name="header">{!$ObjectType.employee__c.fields.email__c.label}</apex:facet>
             <apex:inputField value="{!emp.email__c}"  rendered="{!tobeEdited == emp.id}"/>
             <apex:outputField value="{!emp.email__c}"   rendered="{!!(tobeEdited == emp.id)}"/>             
         </apex:column>
         <apex:column >
         <apex:facet name="header">{!$ObjectType.employee__c.fields.max_pay__c.label}</apex:facet>
             <apex:inputField value="{!emp.max_pay__c}"  rendered="{!tobeEdited == emp.id}"/>
             <apex:outputField value="{!emp.max_pay__c}"   rendered="{!!(tobeEdited == emp.id)}"/>             
         </apex:column>
         <apex:column >
         <apex:facet name="header">{!$ObjectType.employee__c.fields.min_pay__c.label}</apex:facet>
             <apex:inputField value="{!emp.min_pay__c}"  rendered="{!tobeEdited == emp.id}"/>
             <apex:outputField value="{!emp.min_pay__c}"   rendered="{!!(tobeEdited == emp.id)}"/>             
         </apex:column>
         <apex:column >
              <apex:commandbutton value="Edit" rerender="blockId" rendered="{!!(tobeEdited == emp.id)}" >
                  <apex:param assignTo="{!tobeEdited}" value="{!emp.id}" name="ittobeedited"/>
              </apex:commandbutton>
                <apex:commandbutton value="save" rerender="blockId" rendered="{!!(tobeEdited == emp.id)}" />
              <apex:commandButton value="save" action="{!saveRecord}" reRender="blockId" rendered="{!tobeEdited == emp.id}"/>
               <apex:commandButton action="{!Deleted}" value="Deleted" />
                   <apex:commandButton action="{!Download}" value="Download"/>
  </apex:column>
   </apex:pageblocktable>
</apex:pageBlock>   
</apex:form>
</apex:page>

Apex class:

public class MyControlleremployee {




    public PageReference Download() {
      PageReference nextpage = new PageReference('/apex/ExcelReportPage?recordID');
            return nextpage;
}




    public List<employee__c> myemployees;
    public id tobeEdited{get; set;}     

    public MyControlleremployee(){

    }

    public List<employee__c> getMyemployees(){
        myemployees = [select Id,name,email__c,max_pay__c,min_pay__c from employee__c WHERE (owner.id =: userinfo.getuserid()) ];            
        return myemployees;           
    }  
 public void saveRecord(){
        employee__c tobeupdated;
        for(employee__c temp:myemployees){
            if(temp.id==tobeEdited){
                tobeupdated = temp;   
                break;
            }
        }
        update tobeupdated;
        tobeEdited = null;
    }
    public void Deleted(){
    employee__c tobedeleted;
    for(employee__c tmp:myemployees){
    tobedeleted = tmp;
    delete tobedeleted;
    tobedeleted = null;
    }

        }
        }

Pagereference page:

<apex:page contentType="application/x-excel#reRenderAsTestFile.xls" Controller="MyControlleremployee">
    <apex:pageBlock >
        <apex:pageblockTable value="{!myemployees}" var="v" border="1" 
                      columnsWidth="100px,200px,150px" cellspacing="0" cellpadding="8">
            <apex:column headerValue="name">{!v.name}</apex:column>
            <apex:column headerValue="email__c">{!v.email__c}</apex:column>
            <apex:column headerValue="max_pay__c">{!v.max_pay__c}</apex:column>
            <apex:column headerValue="min_pay__c">{!v.min_pay__c}</apex:column>
        </apex:pageblockTable>
    </apex:pageBlock>    
</apex:page>

can anybody help me.

Answer 1

Using a VF page exporting data is very easy.

Here is sample for you. Compere this with you code and you should be all set.

VF Page:

<apex:page controller="contactquery" contentType="application/vnd.ms-excel#SalesForceExport.xls" cache="true">
<apex:pageBlock title="Export Results" >
    <apex:pageBlockTable value="{!cs}" var="contact">
        <apex:column value="{!contact.ID}"/>
        <apex:column value="{!contact.Name}"/>
    </apex:pageBlockTable>
</apex:pageBlock>

Here is Controller:

public class contactquery{
public List<Contact> cs{get; set;}
public contactquery()
{
cs = new List<Contact>();
   for (Contact c : [Select id, Name from Contact])
   {       
       cs.add(c);
   }
}
}