phpExcel合并行数据整理

    /**
     * @param $uploadfile   文件路径
     * @param int $original 从哪一行开始获取
     * @return array
     * 获取Excel文件合并行数据获取
     */
    public static function importExcelCell($uploadfile,$original = 0){
        $inputFileType = IOFactory::identify($uploadfile); # 获取该文件的类型
        $excelReader   = IOFactory::createReader($inputFileType);
        $PHPExcel      = $excelReader->load($uploadfile); // 载入excel文件
        $sheet         = $PHPExcel->getSheet(0); # 读取第一個工作表
        $sheetData     = $sheet->toArray();      # 获取数据

        $mergeCells    = $sheet->getMergeCells(); # 合并行
        $data = [];
        $Fields = [];
        $resource = [];
        if ($mergeCells){
            $highestRow = $sheet->getHighestRow();   # 取得总行数
            # 循环合并行
            foreach ($mergeCells as $key => $val){
                $explode =  explode(':',$val);
                $data[$explode[0]] = substr($explode[1],1);
                array_push($Fields,substr($explode[1],0,1));
                $Fields = array_unique($Fields);
            }
            # 数据整合
            $true = 0;      # 结束行号
            $startSign = 0; # 获取值的行号
            for ($i = $original; $i < $highestRow; $i++){
                foreach ($Fields as  $val){
                    $key = $val.($i+1);
                    if (isset($data[$key])){
                        $true = $data[$key];
                        $startSign= $i;
                    }else if ( $true != 0 && $true > $i){
                        $startVal = ord($val)-65;
                        $sheetData[$i][$startVal] = $sheetData[$startSign][$startVal];
                    }else{
                        $true = 0;
                        $startSign = 0;
                    }
                }
                array_push($resource,$sheetData[$i]);
            }
            $sheetData = $resource;
        }
        return $sheetData;
    }

获取后的数据

[["\u751f\u6210\uff09","\u6536\u4ef6\u4eba\u59d3\u540d\uff08\u5fc5\u586b\uff09","\u6536\u4ef6\u4eba\u624b\u673a\uff08\u4e8c\u9009\u4e00\uff09","\u6536\u4ef6\u4eba\u7535\u8bdd\uff08\u4e8c\u9009\u4e00\uff09","\u6536\u4ef6\u4eba\u5730\u5740\uff08\u5fc5\u586b\uff09","\u5b9d\u8d1d\u6807\u9898","\u5b9d\u8d1d\u89c4\u683c","\u5546\u5bb6\u7f16\u7801","\u5355\u4ef7","\u5546\u54c1\u6570\u91cf","\u91cd\u91cf(kg)","\u4f53\u79ef(m\u00b3)","\u4f18\u60e0","\u5b9e\u4ed8","\u4e70\u5bb6\u7559\u8a00","\u5356\u5bb6\u5907\u6ce8"],
[null,"A",1760068992312,855415215,"\u6536\u4ef6\u4eba\u5730\u5740\uff08\u5fc5\u586b\uff09","\u5b9d\u8d1d\u6807\u9898","\u5b9d\u8d1d\u89c4\u683c","\u5546\u5bb6\u7f16\u7801","\u5355\u4ef7","\u5546\u54c1\u6570\u91cf","\u91cd\u91cf(kg)","\u4f53\u79ef(m\u00b3)","\u4f18\u60e0","\u5b9e\u4ed8","\u4e70\u5bb6\u7559\u8a00","\u5356\u5bb6\u5907\u6ce8"],
[null,"B",17600689921,3954100,"\u6536\u4ef6\u4eba\u5730\u5740\uff08\u5fc5\u586b\uff09","\u5b9d\u8d1d\u6807\u9898","\u5b9d\u8d1d\u89c4\u683c","\u5546\u5bb6\u7f16\u7801","\u5355\u4ef7","\u5546\u54c1\u6570\u91cf","\u91cd\u91cf(kg)","\u4f53\u79ef(m\u00b3)","\u4f18\u60e0","\u5b9e\u4ed8","\u4e70\u5bb6\u7559\u8a00","\u5356\u5bb6\u5907\u6ce8"],
[94515211524,"C",17600689921,851452152,"\u6536\u4ef6\u4eba\u5730\u5740\uff08\u5fc5\u586b\uff09","\u5b9d\u8d1d\u6807\u9898","\u5b9d\u8d1d\u6807\u9898",null,null,null,null,null,null,null,null,null],
[94515211524,"D",854152152,5815202,"\u6536\u4ef6\u4eba\u5730\u5740\uff08\u5fc5\u586b\uff09","\u5b9d\u8d1d\u6807\u9898","\u5b9d\u8d1d\u6807\u9898",null,null,null,null,null,null,null,null,null],[94515211524,"E",17600689921,3954100,"\u6536\u4ef6\u4eba\u5730\u5740\uff08\u5fc5\u586b\uff09","\u5b9d\u8d1d\u6807\u9898","\u5b9d\u8d1d\u6807\u9898",null,null,null,null,null,null,null,null,null],
[94515211524,"F",17600689921,851452152,"\u6536\u4ef6\u4eba\u5730\u5740\uff08\u5fc5\u586b\uff09","\u5b9d\u8d1d\u6807\u9898","\u5b9d\u8d1d\u89c4\u683c",null,null,null,null,null,null,null,null,null],
[null,"G",17600689921,3954100,"\u6536\u4ef6\u4eba\u5730\u5740\uff08\u5fc5\u586b\uff09","\u5b9d\u8d1d\u89c4\u683c","\u5b9d\u8d1d\u89c4\u683c",null,null,null,null,null,null,null,null,null],
[695151521,"H",584152152,851452102,null,null,null,null,null,null,null,null,null,null,null,null],
[695151521,"I","895641285641252","96+6521052",null,null,null,null,null,null,null,null,null,null,null,null]]