Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
516
Automatically expanding a grouped grid in Excel
posted

I'm exporting data from a 'Grouped by' grid into Excel.
When I open Excel, the GroupedBy columns are shown as in the grid, with the '+' .
But I would like to know if it  is possible to show the data in Excel fully expanded automatically. 

In the grid this can be done with the ExpandAll command, but how can I do this in the Excelexport?

It may also be necessary to remove/alter the grouping when exporting. Is there a way to achieve this?