Hello,
I’m facing an issue with Excel export when using the Syncfusion Grid along with a CustomAdaptor. In my case, all operations such as filtering, sorting, searching, and grouping are handled entirely on the server side. The grid fetches paged data from the server as the user interacts with it.
The issue is that when triggering the Excel export, the exported file is either null or empty.
Please note that I don’t want to export the entire unfiltered dataset. Instead, I want to export all the records that match the current filtering, sorting, and grouping conditions, even though they are not all loaded on the current page.
Is there a recommended way to pass the current filter, sort, and group state to the server during Excel export, so I can return the appropriate full dataset for export?
Alternatively, is there a supported way to customize the Excel export logic in this server-side setup?
Thank you in advance for your help.