The sample given for exporting a paged igGrid to Excel in MVC is good, but how can I efficiently export a filtered/sorted/paged igGrid to Excel in MVC? So far the best I have come up with is to get the data from the grid using $("#myGrid").data("igGrid").dataSource.dataView(); and submit it back to my controller as json, and the data could be large...thus slow.
Hello Andrew,
A possible approach would be to submit only the required parameters to query the data source on the server, like filter rules, sorting direction, page size, etc. On the server you can use these parameters to filter/sort your data before exporting it.
Please let me know if this helps.
Hi,
I'm just checking if you need any further assistance with the matter.