How to define, which file type my excel is?

[tcagkansokmen]

Hi there,

I created a system with excel import. But I don't know, in which format will my user upload the excel.

If I import as;

Excel::import(new SoftImport($upload->id), $filename, null, \Maatwebsite\Excel\Excel::XLSX);

then, XLS files return error.

If I import as,
Excel::import(new SoftImport($upload->id), $filename, null, \Maatwebsite\Excel\Excel::XLS);

then XLSX files return error.

I need to define at the begining "which excel type does this document has" and import it with that.

But couldnt find any solution on documentation.
How can we do that?

[patrickbrouwers]

If you don't pass the file type, we'll try to autodiscover the filetype based on the extension. That might work for you?

[tcagkansokmen]

but when I left it empty, in some files it returns: "The filename f0c9a97ab443e6d0e5f1efa5bba.xls is not recognised as an OLE file" and I had to use "XLS" format to resolve that

[patrickbrouwers]

You might need to build your own filetype detector then. You can have a look at PhpSpreadsheet\IOFactory::identify($inputFileName) to see what they use