header for excel file save as

Question

hello, im able to output an excel file by php and it opens correctly in excel. No problems there. When the user clicsk save as in Excel it comes with first option .txt How can i set the header so first option will .xls with save as. Headers im using now :

$filename="jaar.xls";
header("Content-Type: application/vnd.ms-excel");
header("Content-Disposition: attachment; filename=$filename");
header("Pragma: no-cache");
header("Expires: 0");

Thanks in advance

Answer 1

If your name has spaces in it, you should try quoting it:

header("Content-Disposition: attachment; filename='$filename'");

Answer 2

the solution is to use phpexcel http://phpexcel.codeplex.com/

if the xls file used is build with /t like a textfile it will be handled like a txt file by excel