php phpexcel导入excel

/**
 * 导入Excel.
 *
 * @author yzm
 *
 * @param $fileName
 * @param string $encode
 * @return array
 * @throws Exception
 * @throws PHPExcel_Exception
 */
function importExcel($fileName, $encode = 'utf-8')
{
    $excelData = [];


    if (!file_exists($fileName)) {
        return $excelData;
    }


    header("Content-type:text/html;charset={$encode}");
    $objReader = \PHPExcel_IOFactory::createReader('Excel2007');
    $objReader->setReadDataOnly(true);
    $objPHPExcel = $objReader->load($fileName);


    $objWorksheet = $objPHPExcel->getActiveSheet();
    $highestRow = $objWorksheet->getHighestRow();
    $highestColumn = $objWorksheet->getHighestColumn();
    $highestColumnIndex = \PHPExcel_Cell::columnIndexFromString($highestColumn);


    for ($row = 2; $row <= $highestRow; $row++) {
        for ($col = 0; $col < $highestColumnIndex; $col++) {
            $excelData[$row][] = (string)$objWorksheet->getCellByColumnAndRow($col, $row)->getValue();
        }
    }


    return $excelData;
}