ZoorBIS Posted June 14, 2006 Share Posted June 14, 2006 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"); // requiredheader("Expires: 0");header("Cache-Control: must-revalidate, post-check=0, pre-check=0");header("Cache-Control: private",false); // required for certain browsersheader("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 More sharing options...
ZoorBIS Posted June 14, 2006 Author Share Posted June 14, 2006 FIXED ITSOLUTION WAS SIMPLEDo not not hit the refresh button, else it will not work. Link to comment https://forums.phpfreaks.com/topic/11980-php-excel-header-help-please/#findComment-45529 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.