Jump to content

[SOLVED] Excel File Error


sseeley

Recommended Posts

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

Link to comment
https://forums.phpfreaks.com/topic/168533-solved-excel-file-error/
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.