Object of class stdClass could not be converted to string Maatwebsite

Question

I was trying to export a query - the function in the controller was as below

class Export implements FromCollection
{
    public function collection()
    {
        $data = DB::table('Providers')->get();

        return $data;
    }
}

but producing the error:

vendor\phpoffice\phpspreadsheet\src\PhpSpreadsheet\Cell\DefaultValueBinder.php

"Object of class stdClass could not be converted to string"

Answer 1

You could try to make a collection out of it and then map it.

$dataArray = collect($data)->map( function($stdClass) {

    return (array) stdClass;
}

Not sure what your data looks like, perhaps you could also cast it to a string. Hope this helps.

Answer 2

class Export implements FromCollection
{
    public function collection()
    {
        $data = DB::table('Providers')->get();
        $data = $data->toArray();
        $data = json_decode(json_encode($data), true);
        return $data;
    }
}

Answer 3

You Can Do It Like This

class Export implements FromCollection
{
    public function collection()
    {
        $data = DB::table('Providers')->get();
        return $data->toJson();
        return $data->toArray();
    }
}