Server Side Pagination Excel Export

[Joey]

Hi,

I'm looking to do the Excel Export with server side paging. Since we are server side paging, we are only exporting what is displayed on the screen at the time. I scoured the docs and knowledge base, but couldn't find any documentation or discussions pertaining to this. 

 

Thanks for the help!

Joey

[Mihaela]

Hello Joey,

You can export all records to Excel by enabling the AllPages() option, which is disabled by default:

@(Html.Kendo().Grid<Kendo.Mvc.Examples.Models.ProductViewModel>()
	.Name("grid")
	.Excel(excel => excel.AllPages(true))
        .ToolBar(tools => tools.Excel())
        ...
)

Here is a REPL sample for your reference:

https://netcorerepl.telerik.com/wouGGAlk00SNWwyH48

 

Regards,
Mihaela
Progress Telerik

[Joey]

Hey!

We have all pages set to true, and that works for grids that are client side paged, but not server side. We are doing our server side paging by sending skips and takes to a custom stored procedure that we wrote. If there isn't a great way to handle this via Telerik API, then I'm sure we can just write something to create our own excel files to download.

[Mihaela]

Hey Joey,

Generally, the server operations are performed server-side (the ServerOperation() option is enabled by default), so the Grid in the REPL sample uses server-side paging.

Would you please share the Grid configuration at your end, so I can review it?

Also, as an alternative solution, I would suggest exporting the Excel file server-side, as demonstrated in the online demo:

https://demos.telerik.com/aspnet-core/grid/server-export

(Check out the View Source section to examine the source code)

Best,

Mihaela