Tips for more performant exports from view?

[mokhosh]

I'm exporting about 60 rows from view, because I require very specific styles and transformations.
But the export is incredibly slow, even on my local on a Macbook Pro M1!

Are there any ways I can increase the performance here?

[patrickbrouwers]

60 rows isn't a lot, so probably database related.

[mokhosh]

It never takes more than 600ms to load the view when I return the view directly from a test route.
Am I still missing something?

[patrickbrouwers]

Then probably you are doing some complicated html table styling that takes php spreadsheet alot of time to parse

[mokhosh]

Indeed I am. That's why I have to use HTML.
No way around this? Any tips, any alternative packages, any optimisations?

[patrickbrouwers]

Can you show an example?
Doimg it manually using WithStyles probably increases the speed

[mokhosh]

As you can (hopefully) see in this zoomed out screenshot of half of the sheet, there are:

Multiple sub-tables next to each other with their own border styles.
Header rows before all tables.
Complex heading rows with row-span and col-spans, and custom background and text colors.
Multiple layers of grouping of data inside each sub-table.
Total rows for each layer of grouping.
Grand total row. Sometimes showing simple total of items, sometimes total of specific rows, sometimes a formula to live-calculate the sum of specific rows.
Using custom formats and explicit types for most cells.
Live formula for many cells.
etc.

[patrickbrouwers]

Try to disable all the styling and see how much it influences the performance.

As this is all phpspreadsheet logic, there isn't a lot I can do to help you here btw

[mokhosh]

Yeah, I did dive into the HTML reader of phpspreadsheet and I can see why it's using so much resource.
Just thought there might be a list of tips or an article specifically for this type of output.

[mokhosh]

Try to disable all the styling and see how much it influences the performance.

I tried this and it becomes almost instant!