I am using export from PHP.
You mean direct export, without client side, right?
It seems we have a problem here, currently linked collections is not used during direct export.
We will check how it can be fixed. Solution will be available in few days.
I attach the two classes modified by myself (gridExcelWrapper.php and gridExcelGenerator.php). I have solved some other issues, perhaps it’s usefull for you.
I added the ability to hide columns. When grid column property hidden = true, I don’t draw it in excel.
I added the align property to excel data. It was working just for titles.
I changed the cells width multiplier. Now it looks better in excel.
I saw the class is prepared to use a data type excel: $ column-> Attributes()->excel_type. But this attribute is not defined in the grid. To fix this I added the grid types (ro, ron, txt…) to the switch instruction.
Modifications (1),(2),(4) included in the main codebase. ( thank for provided code )
Fixed files ( export of collections ) are attached. export_tools.zip (4.24 KB)