how to download html table to excel format in php

i am displaying mysql data in html table.

How can i download it in mse开发者_C百科xcel format by using php. I am using pagination also. The download should be complete table.

Look at this component. You must do the same select which you do to display a table in html, and then to fill the component structure. The comoponent contains a lot of examples of.

try giving these headers: header("Content-Disposition: attachment; filename="my_excel_file.xls"); and header("Content-Type: application/vnd.ms-excel;"); and then output normal HTML with table in it