phpexcel导入验证技巧_thinkphp5 导入excel

public function import() {$file = $this->request->file();if (empty($file)) {$ret = array('code'=>0,'msg'=> \公众请选择导入文件！
\"大众);return json($ret);}$file = array_shift($file)->getInfo();//excel验证并且将数据转化为数组$extension = strtolower(pathinfo($file['name'], PATHINFO_EXTENSION));if (strtolower($extension) != 'xlsx' && strtolower($extension) != 'xls') {$ret = array('code'=>0,'msg'=> \公众请选择Excel类型文件！
\"大众);return json($ret);}if ($extension == 'xlsx') {$objReader = \PHPExcel_IOFactory::createReader('Excel2007');$objPHPExcel = $objReader->load($file['tmp_name'], $encode = 'utf-8');} else if ($extension == 'xls') {$objReader = \PHPExcel_IOFactory::createReader('Excel5');$objPHPExcel = $objReader->load($file['tmp_name'], $encode = 'utf-8');}//转换为数组格式$excelArray = $objPHPExcel->getsheet(0)->toArray(); //$excelArray数组存放的便是excel数据，后面就可以读这些数据进行所须要的操作return array('code'=>1,'result'=>$excelArray,'msg'=> \"大众请选择Excel类型文件！
\公众);}