March 24, 2012
PHP Excel Header
Question by user794624
header("Content-Type: application/vnd.ms-excel; charset=utf-8");
header("Content-type: application/x-msexcel; charset=utf-8");
header("Content-Disposition: attachment; filename=abc.xsl");
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Cache-Control: private",false);
echo "Some Text"
Here is code to write and download xsl file using php,
my problem is when i open excel file MS-Excel show warning before opening file says
The file you are trying to open is in different format than specified by the file extension…Blah blah
What’s to do with PHP code to remove this warning. Contents are written correctly.
i know this is because content written in file are txt file content and file extension is incorrect, that is, xls. Solution???
Please don’t suggest to use any library.
Answer by Starx
You are giving multiple Content-Type headers. application/vnd.ms-excel is enough.
And there are couple of syntax error too. To statement termination with ; on the echo statement and wrong filename extension.
header("Content-Type: application/vnd.ms-excel; charset=utf-8");
header("Content-Disposition: attachment; filename=abc.xls"); //File name extension was wrong
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Cache-Control: private",false);
echo "Some Text"; //no ending ; here
