Hi,

This can be done. Try the following VF page and controller.

The below example is used to download the vf page as Excel sheet  for the contact redords details created from today and upto today+7 days. The key thing here is contentType="application/x-excel.xls" and action="{!getcontact}", Should be specified in the page tag.

VF page

<apex:page contentType="application/x-excel.xls" controller="excelcontrol"  action="{!getcontact}">

 <apex:DataTable value="{!results}" var="tsk"  >

             <apex:column >

                         {!tsk.Name}

              </apex:column>

             <apex:column >

                         {!tsk.Phone}

            </apex:column>  

            <apex:column >

                         {!tsk.Email}

             </apex:column>   

    </apex:DataTable>

</apex:page>

Controller

public class excelcontrol {

public excelcontrol( ) { }

 public  List<Contact> results{get;set;}

 Public List<Contact> getResults() {    

              return results;

  }

 public PageReference getContact()   {

            //Querying the values using those values we got through param    

               results=[Select Name,Email,Phone from Contact where createdDate >=:System.Now() and createdDate <=: System.Now() + 7 ];

return null;            

         }

}

Hope so this helps you...!

Please mark this answer a Solution and please give kudos by clicking on the star icon, if you found this answer as helpful.