Can't export with belongsToMany relationship

[Kajaia]

Hello,

Trying to export my hotels collection in excel file, where I should have hotel name and hotel services, which is a many to many relationship.

This is how my HotelsExport.php file looks like:

<?php

namespace App\Exports;

use App\Models\Hotel;
use Maatwebsite\Excel\Concerns\FromCollection;
use Maatwebsite\Excel\Concerns\ShouldAutoSize;
use Maatwebsite\Excel\Concerns\WithMapping;
use Maatwebsite\Excel\Concerns\WithHeadings;
use Maatwebsite\Excel\Concerns\WithStyles;
use PhpOffice\PhpSpreadsheet\Worksheet\Worksheet;

class HotelsExport implements FromCollection, WithMapping, WithHeadings, WithStyles, ShouldAutoSize
{
    /**
    * @return \Illuminate\Support\Collection
    */
    public function collection()
    {
        return Hotel::all();
    }

    public function map($hotel): array
    {
        return [
            $hotel->name ?? '-',
            $hotel->services->name
        ];
    }

    public function headings(): array
    {
        return [
            'Title',
            'Services'
        ];
    }

    public function styles(Worksheet $sheet)
    {
        return [
            1    => [
                'font' => [
                    'bold' => true
                ]
            ],
        ];
    }
}

I'm getting this error:

Property [name] does not exist on this collection instance.

I tried to add relationship into collection function, but didn't work for me:

public function collection()
    {
        return Hotel::with('services')->get();
    }

Without services, export works just fine, but I need services also, that's really important.
Do you have any suggestions?

[patrickbrouwers]

$hotel->services->name this won't work in normal Laravel either, not something package specific. services is a collection, so you would need to get all names and e.g. comma separate them.

[Kajaia]

How can I do that?

[patrickbrouwers]

Best to ask these questions on Stackoverflow or Laracasts. Many people happy to help there.

[Kajaia]

Thanks

[Kajaia]

For future if someone needs:

$hotel->services->implode('name', ', ')