Populating Multiple Collection in an Export

[cassandra-low]

Hi. I'm just started using Laravel-Excel and I need to build something like the following

As you can see, data from column C and D (yellow color) are coming from collection A, whereas data from column E to H (green color) are coming from collection B.

There's no direct linkage between collection A and B but they are grouped by date (column A) and name (column B).

From the documentation, I saw that WithCustomStartCell is only supported for FromCollection exports.
However, I'm using FromView because the table that I'm building is quite complex.

My questions:

1. Can we export excel based on multiple collections? Please advice.
2. Can we export different collections on different custom cells for FromView?
3. How to merge certain cells (e.g. row 23 & 24) dynamically based on the grouped data?

Appreciate for your advice!

[patrickbrouwers]

Hey if you are using FromView you can just build it as if you where creating a normal html table for the web.
You can use as many collections as you want with from view, you are completely free to do what ever you want in the view, as long as it is an html table.
You can merge cells and rows using row and colspans like in normal html

[cassandra-low]

Hi, Patrick.
Ok, I'll give it a try then. Thanks!