php export complex header header is malformed
$Head = array(
array("value" => $year."","col" => 19,"row" => 3,
"children" =>
array(
array("value" => $date,"col" => 4,"row" => 1,
"children" =>
array(
array("value" => "","col" => 1,"row" => 3),
array("value" => "","col" => 1,"row" => 3,"width" => 25),
array("value" => "","col" => 6,"row" => 1,
"children" =>
array(
array("value" => "","col" => 1,"row" => 2),
array("value" => "","col" => 1,"row" => 2),
array("value" => "","col" => 1,"row" => 2,"width" => 25),
array("value" => "","col" => 1,"row" => 2,"width" => 25),
array("value" => "","col" => 1,"row" => 2,"width" => 25,),
array("value" => "","col" => 1,"row" => 2,"width" => 25)
)
),
array("value" => "","col" => 3,"row" => 1,
"children" =>
array(
array("value" => "","col" => 1,"row" => 2,"width" => 25),
array("value" => "","col" => 1,"row" => 2,"width" => 25),
array("value" => "","col" => 1,"row" => 2,"width" => 25)
)
),
array("value" => "","col" => 7,"row" => 1,
"children" =>
array(
array("value" => "","col" => 1,"row" => 2,"width" => 25),
array("value" => "","col" => 1,"row" => 2),
array("value" => "","col" => 1,"row" => 2,"width" => 25),
array("value" => "","col" => 1,"row" => 2),
array("value" => "","col" => 1,"row" => 2),
array("value" => "","col" => 1,"row" => 2,"width" => 25),
array("value" => "","col" => 1,"row" => 2,"width" => 25)
)
),
array("value" => "","col" => 1,"row" => 3)
)
),
array("value" => "","col" => 13),
array("value" => ":","col" => 2),
)
)
);
$arr = array();
$data = array();
while ($row = sqlsrv_fetch_array($result,SQLSRV_FETCH_ASSOC)) {
$data["rownum"] = $row["rownum"];
$data["companyname"] = $row["companyname"];
$data["unitspec"] = $row["unitspec"];
$data["unitprop"] = $row["unitprop"];
$data["fundspychannels"] = $row["fundspychannels"];
$data["officepostnum"] = $row["officepostnum"];
$data["staffnum"] = $row["staffnum"];
$data["retirednum"] = $row["retirednum"];
$data["quotacar"] = $row["quotacar"];
$data["availcar"] = $row["availcar"];
$data["scrapcar"] = $row["scrapcar"];
$data["brand"] = $row["brand"];
$data["cartype"] = $row["cartype"];
$data["output"] = $row["output"];
$data["num"] = $row["num"];
$data["oneprice"] = $row["oneprice"];
$data["price"] = $row["num"]*$row["oneprice"];
$data["afundfrom"] = $row["afundfrom"];
$data["remark"] = $row["remark"];
array_push($arr,$data);
}
$phpExcelCore = new PHPExcelCore();
$fn = $phpExcelCore::RecursionCreateExecl($Head,$arr);
$head
?
how do you put these two lines in the head header?