Php export complex header excel header format is incorrect?

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

clipboard.png

clipboard.png
$head

clipboard.png
?
clipboard.png

clipboard.png
how do you put these two lines in the head header?

Mar.16,2022

briefly draw the table. Sort it out.

clipboard.png

:$head, $excel->mergeCells('D2:F2');

3.

:: 5 2 8 $excel->mergeCells('B8:K8');,

clipboard.png

office


:

clipboard.png
head:
$year = date('Y');


data:

clipboard.png

clipboard.png

Menu