Kendo UI Grid Export Excel

[Muralidharan]

Is there any possible way to export grid data to excel page by page like "Export PDF" or is there any option to define the page size while exporting the excel to get the record page by page?

[Dan]

Hello,

Based on the docs here: http://docs.telerik.com/kendo-ui/controls/data-management/grid/excel-export

export to excel exports only the current page of the grid (unless allPages is set to true).

Is that what you were looking for?

Dan

[Dimiter Madjarov]

Hello Muralidharan,

Could you elaborate what exactly is the current requirement? By default only the current page is exported according to the page size set in the Grid's dataSource. Would like to export all pages in separate excel files or separate sheets in one file?

I am looking forward to hearing from you.

Regards,
Dimiter Madjarov
Telerik by Progress

[Muralidharan]

Hello Dimiter,

       I have a huge data which has been connected with our custom service, the service will return only 1000 rows of data at a time, irrelevant of whatever you set as "top". Now in our example, we have a grid with server side paging and has around 1 lakh records, so while exporting it, it's setting the top as "top=100000", but the service returns only 1000 rows which causing issue to us, is there any option to get the data page wise and export to excel.

     

[Dimiter Madjarov]

Hello Muralidharan,

Thank you for the additional information. So if I understand correctly, you would like to export all Grid pages, but they should be retrieved one by one, as the service is configured to return only 1000 records.

Theoretically this could be achieved by sending multiple requests to retrieve the items, read them and export them only after all of the data have been read. Nevertheless I don't recommend using the built in Excel export functionality with a data set of this size. The file is constructed completely client side and that may lead to hitting the browsers memory and resource limitations (which differ in each of them). This is why I would recommend to use some server-side Excel export solution instead.

Regards,
Dimiter Madjarov
Telerik by Progress

[Muralidharan]

Hello Dim,

          Thanks for the reply, Server Side Excel Export means, MVC server side? Is there a way in for .Net server side export.

     

[Dimiter Madjarov]

Hello Muralidharan,

There are multiple 3rd party libraries for server side Excel export, depending on the platform being used, including MVC yes. You could find a sample implementation on the following documentation page.

Regards,
Dimiter Madjarov
Telerik by Progress