- 出现这个错误的原因可能是你上传的文件类型和你设置的不一致,处理方位如下
$info = $file->move( 'uploads/excel');
$info_each = $file->getInfo();
$img_suffix = explode(".", $info_each['name']);
$excel_type = ucfirst(end($img_suffix));
$objReader = IOFactory::createReader($excel_type);
$objPHPExcel = $objReader->load(Env::get('root_path').'public\uploads\excel\\'.$info->getSaveName());
$worksheet = $objPHPExcel->getSheet(0);
$allRow = $worksheet->getHighestRow();
$data = [];
for ($i = 3; $i <= $allRow; $i++)
{
echo $objPHPExcel->getActiveSheet()->getCell('A'.$i)->getValue().'-';
}
private static $readers = [
'Xlsx' => Reader\Xlsx::class,
'Xls' => Reader\Xls::class,
'Xml' => Reader\Xml::class,
'Ods' => Reader\Ods::class,
'Slk' => Reader\Slk::class,
'Gnumeric' => Reader\Gnumeric::class,
'Html' => Reader\Html::class,
'Csv' => Reader\Csv::class,
];