Hi Rina,
The Kendo UI Grid could be configured to either export the first page or all pages. Hence, exporting only a certain amount of items has to be handled separately. Generally, what I could recommend is to handle the ExcelExport and prevent the default execution of the event. Then, manually export the Grid using the saveAsExcel() method. And load only the desired rows. A similar approach could be found in the following forum thread:
https://www.telerik.com/forums/export-to-grid-hide-columns#on_CdInsGESYqc5Jumibow
As per the export of large data, it is actually a browser limitation that is imposed. If the AllPages property is set to true, the grid would make a request for all of the data. And this data could not be serialized on the client.
In such cases, I can recommend taking advantage of the server export functionality. An example could be found here:
https://demos.telerik.com/aspnet-mvc/grid/server-export
Let me know in case further assistance is required.
Best regards,
Tsvetomir
Progress Telerik
Get
quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers.
Learn More.