Level 24
you can remove |mimes:xlsx,csv and dd() check the mime type
very old post: https://stackoverflow.com/questions/4212861/what-is-a-correct-mime-type-for-docx-pptx-etc
1 like
Dec 4, 2022
6
Level 1
Laravel validation error, while upload excel file
I took an excel file from google spreadsheets and downloaded it to excel. When I upload it, I get an error message The upload must be a file of type: xlsx, csv., but if I take it directly from the ms.excel application, it works fine. this is my code
protected $rules = [
'type' => 'required|in:psb,mutasi',
'upload' => 'required|file|mimes:xlsx,csv',
];
Level 1
@newbie360 i checked the mime type and it was application/octet-stream, and i changed my rules to this
protected $rules = [
'type' => 'required|in:psb,mutasi',
'upload' => 'required|file|mimetypes:application/vnd.openxmlformats-officedocument.spreadsheetml.sheet,application/vnd.ms-excel,application/octet-stream',
];
and it's still same error.
Level 28
@akhmami What is the file size that you were trying to upload? You may also want to check your php.ini configuration on this part:
post_max_size = 20M
upload_max_filesize = 20M
Level 1
@drgreen my excel file is only 5KB.
Level 24
@akhmami what this show dd($this->upload->getMimeType());
1 like
Level 1
@newbie360 it's application/vnd.openxmlformats-officedocument.spreadsheetml.sheetapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet.
thanks, you saved my day.
protected $rules = [
'type' => 'required|in:psb,mutasi',
'upload' => 'required|file|mimetypes:application/vnd.openxmlformats-officedocument.spreadsheetml.sheet,application/vnd.ms-excel,application/vnd.openxmlformats-officedocument.spreadsheetml.sheetapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet',
];
it works fine.
Please or to participate in this conversation.