$fname = $_FILES['file']['name'];
$ftype = pathinfo($fname, PATHINFO_EXTENSION);
if ( ! in_array($ftype, ['xls','xlsx'])) {
$this->error("上传文件格式必须为.xlsx或.xls");
}
$filename = $_FILES['file']['tmp_name'];
include_once(dirname(__FILE__) . '/../../../common/PHPExcel/PHPExcel.php');
//建立reader对象
$PHPReader = new \PHPExcel_Reader_Excel2007();
if(!$PHPReader->canRead($filename)){
$PHPReader = new \PHPExcel_Reader_Excel5();
if(!$PHPReader->canRead($filename)){
$this->error("读取文件错误");
return ;
}
}
$objPHPExcel = $PHPReader->load($filename);
ob_clean();
$sheetData = $objPHPExcel->getActiveSheet()->toArray('',true,true,true);