Jump to content


Photo

PHP EXCEL HEADER HELP PLEASE


  • Please log in to reply
1 reply to this topic

#1 ZoorBIS

ZoorBIS
  • New Members
  • Pip
  • Newbie
  • 5 posts

Posted 14 June 2006 - 01:55 PM

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";
?>


#2 ZoorBIS

ZoorBIS
  • New Members
  • Pip
  • Newbie
  • 5 posts

Posted 14 June 2006 - 02:06 PM

FIXED IT

SOLUTION WAS SIMPLE

Do not not hit the refresh button, else it will not work.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users