excel文件内容 读取

前台体检excel文件   后台获取
//获取提交文件的数据
$filename=$_FILES['file']['tmp_name'];
$batch= Helper::excelOrderCreateImport($filename)
//将提交的文件传过去  获取文件内容
public function excelOrderCreateImport($filename){
        include Yii::$app->basePath . '/../../library/PHPExcelLib/PHPExcel/Writer/IWriter.php';
        include Yii::$app->basePath . '/../../library/PHPExcelLib/PHPExcel.php';
        include Yii::$app->basePath . '/../../library/PHPExcelLib/PHPExcel/Writer/Excel2007.php';
        include Yii::$app->basePath . '/../../library/PHPExcelLib/PHPExcel/IOFactory.php';

        $objPHPExcelReader = \PHPExcel_IOFactory::load($filename);
        $sheet = $objPHPExcelReader->getSheet(0);     // 读取第一个工作表(编号从 0 开始)
        $highestRow = $sheet->getHighestRow();           // 取得总行数
        $highestColumn = $sheet->getHighestColumn();   // 取得总列数
        //可定义excel的列  取到哪一列
        $arr = array('A','B','C','D','E','F','G','H','I','J','K','L','M', 'N','O','P','Q','R','S','T','U','V','W','X','Y','Z','AA','AB');
        // 一次读取一列
        $res_arr = array();
        for ($row = 21; $row <= $highestRow; $row++) {
            $row_arr = array();
            for ($column = 0; $arr[$column] != $highestColumn; $column++) {
                $val = $sheet->getCellByColumnAndRow($column, $row)->getValue();
                $row_arr[] = trim(html_entity_decode($val),chr(0xc2).chr(0xa0));
            }
            $res_arr[] = $row_arr;
        }
        return $res_arr;
    }

输出二维数组  每一列数据组成数据的一个元素