Ag Grid Export to Excel for Server side pagination row model

Question

I am not able to find any helpful detail in ag-grid documentation regarding export data for server side row model. It seems to support the export of data that is already loaded.

Is their any way we can do excel export for complete data I am using Ag Grid - 23.1.1 Angular - 9.1.0

Answer 1

Yes, AgGrid only exports data that is loaded on the web client. You will need to either call a request with all the data possible (single page with all the elements) then call the exportAsExcel method on that.

This is a stretch since excel export for more than 4000 lines on the web client is a real pain that will render your browser completely unresponsive for some visible amount of time.

If you are looking for a huge datasheets export you could try to make it on the server side in an asynchronous way, agGrid can't help you that much here.