Excel export limited number of rows

[Irina]

Hi,

due to large amount of data in the grid, excel export does not work (>50.000 records). Is there a way to achieve this? Using 

.AllPages(false)

only exports a number of records equal to the page size. I would like to be able to let's say export 200 records per .xls file.

Is there possible to use smth similar to https://docs.telerik.com/kendo-ui/api/javascript/ui/grid/events/excelexport 

Is there a way to achieve this and can you maybe share an small example? 

Thanks a lot,

rina

[Tsvetomir]

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