Export Data in CSV or Excel In Apex Salesforce

Hello guys ,
This articles lets you know how to export data in csv or excel.

See Example Below .
Copy paste code according to your data structure.

For Excel :
Note : Make sure if you are on MAC then do not use pageBlock and pageBlockTable other wise you get an issue with extra content on visualforce page like if(!window.sfdcPage){ window.sfdcPage = new ApexPage(); }
So to avoid this issue just use DataTable instead of pageBlock and PageBlockTable.

<apex:page controller="exportExcel" action="{!exportToExcel}" readOnly="true" contentType="application/vnd.ms-excel#ConsignmentSearchData.xls">

    
    <apex:pageBlock >
        <apex:pageBlockTable value="{!lstwrapper}" var="x">
           <apex:column headerValue="shipTo">
                {!x.shipTo}
            </apex:column>
             <apex:column headerValue="searchNumber">
                {!x.searchNumber}
            </apex:column>
             <apex:column headerValue="accountName">
                {!x.accountName}
            </apex:column>
             <apex:column headerValue="businessUnit">
                {!x.businessUnit}
            </apex:column>
             <apex:column headerValue="dateval">
                {!x.dateval}
            </apex:column>
            <apex:column headerValue="expirationDate">
                {!x.expirationDate}
            </apex:column>
             <apex:column headerValue="expirationEndDate">
                {!x.expirationEndDate}
            </apex:column>
            <apex:column headerValue="expirationStartDate">
                {!x.expirationStartDate}
            </apex:column>
             <apex:column headerValue="groupval">
                {!x.groupval}
            </apex:column>
             <apex:column headerValue="implantDate ">
               {!x.implantDate}
            </apex:column>
             <apex:column headerValue="invoiceDate">
                {!x.invoiceDate}
            </apex:column>
             <apex:column headerValue="invoiceNumber">
                {!x.invoiceNumber}
            </apex:column>
        </apex:pageBlockTable>
    </apex:pageBlock>   

</apex:page>

For CSV :

<apex:page controller="exportExcel" action="{!exportToExcel}" readOnly="true" contentType="application/vnd.ms-excel#ConsignmentSearchData.csv">{!header}
  <apex:repeat value="{!lstwrapper}" var="x">
       {!x.shipTo},{!x.searchNumber},{!x.accountName},{!x.businessUnit},{!x.dateval},{!x.expirationDate},{!x.expirationEndDate},{!x.expirationStartDate},{!x.groupval},{!x.implantDate},{!x.invoiceDate},{!x.invoiceNumber}
  </apex:repeat>
</apex:page>

Class Code :

public class exportExcel {
  
    public string header{get;set;}
    public List<wrapper> lstwrapper {get; set;}
    public class wrapper{
        public string shipTo {get; set;}
        public string searchNumber{get; set;}
        public string accountName{get; set;}
        public string businessUnit{get; set;}
        public string dateval{get; set;}


        public string expirationDate{get; set;}
        public string expirationEndDate{get; set;}
        public string expirationStartDate{get; set;}
        public string groupval{get; set;}
        public string implantDate {get; set;}
        public string invoiceDate{get; set;}
        public string invoiceNumber{get; set;}         
    }
  
    public string Filetype{get;set;}
    public boolean isExcel {get;set;}
    public boolean isCsv {get;set;}   
  




    public exportExcel(){
            Filetype = '';
            lstwrapper = new List<wrapper>();
            header = 'Ship To,Search Number,Account Name,Business Unit,Date,Expiration Date,Expiration End Date,Expiration Start Date,Group,Implant Date ,Invoice Date,Invoice Number\r\n';                     
    }

  
    public void exportToExcel(){
          string queryString = 'Select c.Account_Name__c, c.Business_Unit__c, c.Date__c, c.Expiration_Date__c,c.Expiration_End_Date__c, c.Expiration_Start_Date__c, c.Group__c, c.Id, c.Implant_Date__c, c.Invoice_Date__c, c.Invoice_Number__c, c.Location__c, c.Name, c.Order_Number__c, c.OwnerId, c.Physician_ID__c, c.PO_Number__c, c.Product_Group__c, c.Product_ID__c, c.Search_ID__c, c.Serial_Number__c, c.Ship_To__c, c.Type__c, c.User_ID__c, c.User_Name__c from Consignment_Search_Data__c c where User_ID__c=\''+UserInfo.getUserId()+'\''; 
          List<Consignment_Search_Data__c> lstConsignmentSearchData = DataBase.Query(queryString);
          system.debug('lstConsignmentSearchData :'+lstConsignmentSearchData.size());
          if(lstConsignmentSearchData.size()>0){
              for(Consignment_Search_Data__c csd :lstConsignmentSearchData){
                  wrapper w = new wrapper();
                  w.shipTo = csd.Ship_To__c ;
                  w.searchNumber = csd.Search_ID__c;
                  w.accountName = csd.Account_Name__c;
                  w.businessUnit = csd.Business_Unit__c ;
                  w.dateval = string.valueof(csd.Date__c);
                  w.expirationDate = string.valueOf(csd.Expiration_Date__c);
                  w.expirationEndDate = string.valueOf(csd.Expiration_End_Date__c);
                  w.expirationStartDate = string.valueOf(csd.Expiration_Start_Date__c);
                  w.groupval = csd.Group__c;
                  w.implantDate = string.valueOf(csd.Implant_Date__c);
                  w.invoiceDate = string.valueOf(csd.Invoice_Date__c) ;
                  w.invoiceNumber = string.valueOf(csd.Invoice_Number__c);
                  lstwrapper.add(w);               
              }             
          }
          system.debug('lstwrapper :'+lstwrapper.size());
    }

  

}

Note : Using the same class code for both page :