php使用phpexcel读取excel内容

/**
 * 获取上传excel中的数据
 * @return array
 */
private function action_get_excel_data()
{
    $passportArr = array();
    $passportFile = BASEPATH . '/card.xlsx';  //excel文件路径
    require_once TOOLS_Lib . 'phpexcel/PHPExcel/IOFactory.php';   //引入phpexcel中IOFactory文件
    $objPHPExcelReader = PHPExcel_IOFactory::load($passportFile);
    foreach($objPHPExcelReader->getWorksheetIterator() as $sheet)  //循环读取sheet
    {
        foreach($sheet->getRowIterator() as $row)  //逐行处理
        {
            foreach($row->getCellIterator() as $cell)  //逐列读取
            {
                $data = $cell->getValue(); //获取cell中数据
                if(!empty($data))
                {
                    $passportArr[] = $data;
                }
            }
        }
    }
    return $passportArr;
}