php 导出 设置多表头,php 导出复杂表头excel表头格式错乱？

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