Laravel-excel: [QUESTION] Use a View and a Query Together?

[octoxan]

Prerequisites

• [x] Have read and understood: https://github.com/Maatwebsite/Laravel-Excel/blob/3.1/.github/SUPPORT.md
• [x] Checked if your Laravel Excel version is still supported: https://docs.laravel-excel.com/3.1/getting-started/support.html#supported-versions
• [x] Checked that your question isn't already asked before.
• [x] Filled in the entire issue template

Versions

• PHP version: 7.3.18
• Laravel version: 7.14.1
• Package version: 3.1.19

Description

Is it possible to export with multiple concerns/sources? Before I was building out pretty complicated exports on 2.1 where the user could pass data to the controller, which would pass queried variables to a view. Seems now I can only do View or Query?

[patrickbrouwers]

I'm not sure I understand the problem? You can still pass those queries variables to the View in 3.x

[octoxan]

Thanks, got that figured out, wasn't sure since the docs are so sparse and only the From Query page mentioned passing in variables.

Now just trying to figure out how to get styling to work in the view. Most of the styles from 2.x are missing. Not sure how to use phpspreadsheet styling in a blade file. Googling around now...

[patrickbrouwers]

Every concern allows variables to be passed in, it's not something exclusive, just simple PHP class logic :) If you have any additions to the documentation, feel free to PR it. You can easily PR the docs by clicking the "Help us improve this page".

Not 100% sure, but I think I've PR'd all view styling options we had before to PhpSpreadsheet. You can find the list of css properties being parsed here: https://github.com/PHPOffice/PhpSpreadsheet/blob/master/src/PhpSpreadsheet/Reader/Html.php#L746