This is a migrated thread and some comments may be shown as answers.

Kendo UI Grid Export Excel

6 Answers 65 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Muralidharan
Top achievements
Rank 1
Muralidharan asked on 21 Dec 2016, 02:48 PM
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?

6 Answers, 1 is accepted

Sort by
0
Dan
Top achievements
Rank 1
answered on 21 Dec 2016, 03:29 PM

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

0
Dimiter Madjarov
Telerik team
answered on 22 Dec 2016, 12:30 PM

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
Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
0
Muralidharan
Top achievements
Rank 1
answered on 22 Dec 2016, 01:18 PM

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.

     

0
Dimiter Madjarov
Telerik team
answered on 23 Dec 2016, 01:37 PM

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
Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
0
Muralidharan
Top achievements
Rank 1
answered on 23 Dec 2016, 02:40 PM

Hello Dim,

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

     

0
Dimiter Madjarov
Telerik team
answered on 23 Dec 2016, 03:23 PM

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
Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
Tags
Grid
Asked by
Muralidharan
Top achievements
Rank 1
Answers by
Dan
Top achievements
Rank 1
Dimiter Madjarov
Telerik team
Muralidharan
Top achievements
Rank 1
Share this question
or