Laravel-excel: is not recognised as an OLE file

[kemalatila]

Versions

• PHP version: 7.1.12
• Lumen version: 5.5.*
• Package version: 3.1

Description

I get an error on some xls files when importing.

The filename /tmp/laravel-excel-p0Ik8z8RMONZ7664r1feNjsyQPS6vKap is not recognised as an OLE file

how can i solve it?

[issue-check[bot]]

Thanks for submitting the ticket. Unfortunately the information you provided is incomplete. We need to know which version you use and how to reproduce it. Please include code examples. Before we can pick it up, please check (https://github.com/Maatwebsite/Laravel-Excel/blob/3.1/.github/ISSUE_TEMPLATE.md) and add the missing information. To make processing of this ticket a lot easier, please make sure to check (https://laravel-excel.maatwebsite.nl/3.1/getting-started/contributing.html) and double-check if you have filled in the issue template correctly. This will allow us to pick up your ticket more efficiently. Issues that follow the guidelines correctly will get priority over other issues.

[GlennM]

Could you please add more information about the version you're using, and your code? Please refer to the issue template if you need any guidance on this. Thanks!

[kemalatila]

My Controller Code :

        $new_file_name = md5(uniqid()) . '.' . $request->file('document')->getClientOriginalExtension();
        $path = $request->file('document')->move(storage_path() . '/epdk_import/', $new_file_name);
        Excel::import(new VendorsImport, $path);

and sent the excel as attachment

test.xls.zip

[patrickbrouwers]

Can you share the full stack trace please.

[kemalatila]

Full Stack Trace
full_stack_trace.txt

[patrickbrouwers]

@kemalatila I checked your file, but your file seems invalid.

[kemalatila]

thanks @patrickbrouwers , I figure out.

[davs20]

i have the same problem

[davs20]

@kemalatila how did you solve it?

[kemalatila]

It was tricky. I said save as "microsoft office 2013" format to users before upload it. Otherwise have to parse xml file .. (open to advice)

[tanvira1993]

Hello @kemalatila , I am also facing this same problem while uploading .xls format but when I upload .xlsx format then it's working well, how can I solve this problem.

[kemalatila]

Hello @kemalatila , I am also facing this same problem while uploading .xls format but when I upload .xlsx format then it's working well, how can I solve this problem.

Hi @tanvira1993, Did you try save as file to "Microsoft Office 2013" format again?

[hoangnkvti]

Hello @kemalatila, I am facing this problem too when upgrade from version 2.0 to 3.1.

In 2.0, it is OK to upload this file, but when I use 3.1, an error as is not recognised as an OLE file was showed.
I save my file as Excel97-2004 format and can upload well. But how I can fix that without convert the file format? because I have a lot of files like this.

[kemalatila]

Hi @hoangnkvti, I have no idea about this problem, contributors may support you. @GlennM, @patrickbrouwers .