Jump to content

PHP EXCEL HEADER HELP PLEASE


ZoorBIS

Recommended Posts

Hi,

Can someone please help.

I am trying to export mysql to excel, I have completed the tutorial and all works fine except for the end the headers. I get no errors or warning just the contents of the file is diplayed in the browser.

I have tried many different headers for excel from google. However none seem to work.

Here is a simple file i have been trying to get to work

<?
$filename = "aaa";
$ctype="application/vnd.ms-excel";
header("Pragma: public"); // required
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Cache-Control: private",false); // required for certain browsers
header("Content-Type: $ctype");
header("Content-Disposition: attachment; filename=extraction.xls" );
header("Content-Transfer-Encoding: binary");
Echo"Car Type,Car Model,Number of Cars\n";
Echo"Mazda,323,5\n";
Echo"Mazda,6,4\n";
Echo"Mazda,MPV,6\n";
?>
Link to comment
https://forums.phpfreaks.com/topic/11980-php-excel-header-help-please/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.