How can I merge cells dynamically?

[Daniil-Solovyev]

Versions

• PHP version: 8.1
• Laravel version: 10.16.1
• Package version: 3.1.48

So I have three methods in the export class: headings(), collection() and registerEvents().

The problem is that I cannot know in advance which cells to merge. I only know this when I iterate over the collection and collect the cell merge information into an array. I can't pass any data to the registerEvents() method because it is called before the collection() method.

Any ideas are welcome.

[shanakamadusanka]

Didn't you try this ?
https://stackoverflow.com/questions/68176458/laravel-excel-add-complex-headers-to-an-export