PHPExcel读取数据之数据排列

//核对返回数据

  public function actionChecking()
    {
        if(Yii::$app->request->isPost){
            $post = Yii::$app->request->post();
            if (isset($_FILES['batchFile']) && $_FILES['batchFile']['error'] == 0) {
                spl_autoload_unregister(array('YiiBase', 'autoload'));  //注销YII的自动加载，采用手动导入，PHPexcel有自己的加载功能
                $files        =  $_FILES['batchFile']['tmp_name'];
                $objPHPExcel  =  new \PHPExcel();
                $fileType     = \PHPExcel_IOFactory::identify($files); //文件名自动判断文件类型
                $excelReader  = \PHPExcel_IOFactory::createReader($fileType);
                $phpexcel    = $excelReader->load($files)->getActiveSheet();//载入文件并获取活动表
                $total_line   = $phpexcel->getHighestRow();//总行数
                $total_column = $phpexcel->getHighestColumn();//总列数
                $_arr = ['市场管理','线索录入','销售部门','技术方案','飞行部','项目实施','硬件研发','软件研发'];
                $hardRate = 0;//硬件占比
                $softRate = 0;//软件占比
                //三维数组取出数值
                if($total_line > 1) {
                    $dataArr = array();
                    $rowNum = 0;
                    $oneKey = '';
                    for ($row = 6; $row <= $total_line; $row++) {
                        $rowNum++;
                        $data = array();
                        //取每一列的值
                        for ($column = 'A'; $column <= $total_column; $column++) {
                            $val = trim($phpexcel->getCell($column . $row)->getValue());
                            if (in_array($val, $_arr)) {
                                $val == '硬件研发' ?  $hardRate =  trim($phpexcel->getCell('F' . $row)->getValue()) : '';
                                $val == '软件研发' ?  $softRate =  trim($phpexcel->getCell('F' . $row)->getValue()) : '';
                                $oneKey = $val;
                                break;
                            } else {
                                if(!empty($val))
                                    $data[$val] = trim($phpexcel->getCell(++$column . $row)->getValue());
                            }
                        }
                        if(!empty($data))
                            $dataArr[$oneKey][] = $data;
                    }
                }
                //软硬件综合占比 == 100%（1）
                $totalRate = $hardRate + $softRate;
                if(intval($totalRate) == 1){
                    return ['code'=>-1,'status'=>'fail','message' => '软硬件研发占比不等于100%'];
                }

            }
        }
    }

数据排列方式：