1. PHPExcel读取xls格式的文件
$excelReader = \PHPExcel_IOFactory::createReader('Excel5');
2. PHPExcel读取xlsx格式的文件
$excelReader = \PHPExcel_IOFactory::createReader('Excel2007');
3. 不知道哪个版本时 :
$excelReader = \PHPExcel_IOFactory::createReader('Excel5');
if(!$excelReader->canRead($path)){
$excelReader = \PHPExcel_IOFactory::createReader('Excel2007');
}
4. 当读取Excel出现内存溢出时 , 在load文件前
$excelReader->setReadDataOnly(true);