Issue with Excel Export in Grid using CustomAdaptor with Server-Side Operations

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.


1 Reply

SK Sanjay Kumar Suresh Syncfusion Team June 2, 2025 01:45 PM UTC

Hi Farshad Mehrvarzan,


We would like to inform you that the DataGrid will export data based on the current UI state. This means that if you have applied sorting, filtering, or grouping to the records in the Grid, the exported data will reflect those customizations.


For your reference, we have documented various Excel export scenarios, including exporting grouped or selected records. Please refer to the links below for detailed guidance and sample implementations:


If you continue to experience any issues, we kindly request you to share a simple issue-replicating sample from your end. This will help us validate the scenario and assist you more effectively.


Regards,

Sanjay Kumar Suresh


Loader.
Up arrow icon