Sivo 悉见

Laravel-Excel导入excel报错No ReaderType or WriterType could be detected. Make sure you either pass a valid extension to the filename or pass an explicit type

匿名 · 更新于 2019/11/3

Laravel上传Excel文件,在Windows环境下没有报错,但是发布到Linux CentOS正式服务环境报错No ReaderType or WriterType could be detected. Make sure you either pass a valid extension to the filename or pass an explicit type,具体信息如下:

"message": "No ReaderType or WriterType could be detected. Make sure you either pass a valid extension to the filename or pass an explicit type.",
    "exception": "Maatwebsite\Excel\Exceptions\NoTypeDetectedException",
    "file": "/www/wwwroot/web/vendor/maatwebsite/excel/src/Helpers/FileTypeDetector.php",
    "line": 31

将原代码
$file = $_FILES['file'];
$data = \Excel::import(new UsersImport, $file['tmp_name']);
替换为
$path1 = $this->request->file('file')->store('temp');
$path = storage_path('app').'/'.$path1;
$data = \Excel::import(new UsersImport, $path);

好了,问题解决!!!