Two-row headings where some headings span multiple columns

[ghgene]

Hello,

Is it possible to achieve 2-row headings with Laravel-Excel? If so, is it possible to make it span multiple columns for certain headings?

I need the following table structure:

    -------------------------------------------------------
    |          |  Header 2 - Multiple Columns  |          |
    -----------------------------------------------------
    | Header 1 | Header 2-Sub1 | Header 2-Sub2 | Header 3 |
    -------------------------------------------------------

Right now in my export file I have a simple headings method which only returns a single row headings:

    public function headings()
    {
        return ['col1', 'col2', ...];
    }

In the following example the headings span 2 rows, however not multiple columns:

public function headings()
{
    return [
        ['', 'Header 2 - Multiple Columns', ''],
        ['Header 1', 'Header 2-Sub1', 'Header 2-Sub2', 'Header 3'],
    ];
}

Thanks

[patrickbrouwers]

You are looking for $sheet->mergeCells('A2:A5'); which can be done in an AfterSheet event

[ghgene]

thank you, I managed to do it!