php上传excel读取数据错误is not recognised as an OLE file

• 出现这个错误的原因可能是你上传的文件类型和你设置的不一致，处理方位如下

			//保存
            $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);
            //加载excel文件
            $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().'-';
            }

• phpoffice 支持的文件类型

 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,
    ];