Export data in .xls format rather than tab delimited

Question

HI i am exporting some data from database in .xls format but when i try to save my file it alerts me that file type is not .xls format. I need to store it in excel 97-2003 Workbook. when i pretend for save as option, default file type is in as tab delimited.. how can i overcome it?? below is my code..

if ( $_POST["frmDownload"] == "Excel") {
        header("Content-disposition: attachment; filename=employee_details.xls");
        header("Content-Type: application/vnd.ms-excel");
        header("Content-type: application/x-msexcel");
    }

Answer 1

use phpExcel which is excellent for all excel manipulation.

Here is the list of examples.

use the method fromArray to write excel from array which is fetched from persistent data.

use the method toArray to form a php array from excel sheet.

The learning curve is very simple first try first example only from official site. Then try the fromArray and toArray its very easy and also phpExcel have lots of functionality like gradient background for a cell, border size increasing, formula manipulation and new worksheet also easy to create.

Important: read documentation on when ever you get free time