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";?> Quote 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. Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.