CODEWITHSUNDEEP
phpmysqlexcelexport-to-excel
Syed Ibrahim
Syed Ibrahim

Reputation: 583

Export data in .xls format rather than tab delimited

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");
    }

Upvotes: 0

Views: 732

Answers (2)

gvgvgvijayan
gvgvgvijayan

Reputation: 2506

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

Upvotes: 1

RichardBernards
RichardBernards

Reputation: 3097

The format is tab delimited... You are just 'naming' it excel in this way... Look at gvgvgvijayan's answer for the solution to your problem.

Upvotes: 0

Related Questions