Laravel-excel: [QUESTION] got Response::setContent() must be of the type string or null, object given

[handhikadj]

Prerequisites

• [X] Have read and understood: https://github.com/Maatwebsite/Laravel-Excel/blob/3.1/.github/SUPPORT.md
• [X] Checked if your Laravel Excel version is still supported: https://docs.laravel-excel.com/3.1/getting-started/support.html#supported-versions
• [X] Checked that your question isn't already asked before.
• [x] Filled in the entire issue template

Versions

• PHP version: 7.4.7
• Laravel version: 7.20.0
• Package version: 3.1.19

Description

I got TypeError: Argument 1 passed to Symfony\Component\HttpFoundation\Response::setContent() must be of the type string or null, object given, called in myprojectpath/vendor/laravel/framework/src/Illuminate/Http/Response.php on line 65 in file myprojectpath/vendor/symfony/http-foundation/Response.php on line 412

class MyImports implements ToCollection
{
    public function collection(Collection $collection)
    {
        return $collection;
    }
}
Route::get('apireadpdf', function () {
    $myFile = public_path("my-excel.xlsx");
    $a = \Maatwebsite\Excel\Facades\Excel::import(new \App\Imports\MyImports(), $myFile);
    return response($a);
});

[patrickbrouwers]

Can you explain what you are trying to achieve? I'm not sure based on your example. The collection() method doesn't return anything.

[handhikadj]

I only want to read a .xlsx file to be an array

[patrickbrouwers]

See documentation: https://docs.laravel-excel.com/3.1/imports/basics.html#importing-to-array-or-collection

[handhikadj]

thank you. it works