sseeley Posted August 2, 2009 Share Posted August 2, 2009 Hi, I have created the following code to try and create an excel file. However I am getting an error on line 4 'Parse error: syntax error, unexpected ':' in /home/mypcguy2/public_html/accounts/excelTest.php on line 4' Would anyone be able to help me with this error? Many thanks <?php require_once “excel.php”; $filename = “theFile.xls”; $export_file = “xlsfile://tmp/”.$filename; $fp = fopen($export_file, “wb”); if (!is_resource($fp)) { die(”Cannot open $export_file”); } // typically this will be generated/read from a database table $assoc = array( array(”First name” => “Mattias”, “IQ” => 250, array(”First name” => “Tony”, “IQ” => 100, array(”First name” => “Peter”, “IQ” => 100, array(”First name” => “Edvard”, “IQ” => 100); fwrite($fp, serialize($assoc)); fclose($fp); header (”Expires: Mon, 26 Jul 1997 05:00:00 GMT”); header (”Last-Modified: ” . gmdate(”D,d M YH:i:s”) . ” GMT”); header (”Cache-Control: no-cache, must-revalidate”); header (”Pragma: no-cache”); header (”Content-type: application/x-msexcel”); header (”Content-Disposition: attachment; filename=\”" . $filename . “\”" ); header (”Content-Description: PHP/INTERBASE Generated Data” ); readfile($export_file); exit; ?> Quote Link to comment https://forums.phpfreaks.com/topic/168533-solved-excel-file-error/ Share on other sites More sharing options...
Bricktop Posted August 2, 2009 Share Posted August 2, 2009 Hi sseeley, export_file = “xlsfile://tmp/”.$filename; appears to be the culprit here, you've essentially commented out the text after the //. Are you sure you need // in there? Would export_file = “xlsfile:/tmp/”.$filename; not work? Quote Link to comment https://forums.phpfreaks.com/topic/168533-solved-excel-file-error/#findComment-889045 Share on other sites More sharing options...
sseeley Posted August 2, 2009 Author Share Posted August 2, 2009 Thanks for your help, but still geting the same error...? Quote Link to comment https://forums.phpfreaks.com/topic/168533-solved-excel-file-error/#findComment-889053 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.