Excel Export with header and footer

How to set header and footer in excel export , Urgent please give method or suggestions