Excel Export With Ajax Paging

[Umut]

I did the same as tutorial http://demos.telerik.com/aspnet-mvc/grid/excel-export . But as you can see in the tutorial, when you export the excel, it contains only page 1. 
I want to export all the the pages. How should i do ? 

Regards.

[Dimiter Madjarov]

Hello Umut,

In order to achieve this you should enable the allPages options of the Excel export.
E.g.

.Excel(excel => excel
    .FileName("Kendo UI Grid Export.xlsx")
    .AllPages(true)
    ...
)

 

Regards,
Dimiter Madjarov
Telerik

 

 

[David]

I followed the example EXACTLY, and added the lines you indicated above...it still only prints the current page.

 (I got rid of the groupings, totals, and changed the model to match my model...but everything else is the same)

Thoughts?

 

Grid Code Below:

 

@(Html.Kendo().Grid<DairyDashboard.MVC.ViewModels.Home.MyHerdViewModel>()
    .Name("grid")
    .HtmlAttributes(new { style = "width: 900px" })
    .Columns(columns =>
    {
        columns.Bound(p => p.AnimalId).Width(300);
    })
    .ToolBar(tools => tools.Excel())
    .Pageable()
    .Sortable()
    .Scrollable()
    .Groupable()
    .Excel(excel => excel
        .FileName("Kendo UI Grid Export.xlsx")
        .AllPages(true)
        .Filterable(true)
        .ProxyURL(Url.Action("Excel_Export_Save", "Home"))
    )
    .Reorderable(r => r.Columns(true))
    .Resizable(r => r.Columns(true))
    .ColumnMenu()
    .DataSource(dataSource => dataSource
        .Ajax()
        .PageSize(30)
            .Read(read => read.Action("Excel_Export_Read", "Home"))
    )
)

 

 

 

[Dimiter Madjarov]

Hello David,

The provided sample code seems correct, so I cannot state for sure why only the current page is exported. Please provide small isolated runnable example that I could inspect locally and assist further.

I am looking forward to hearing from you.

Regards,
Dimiter Madjarov
Telerik

[David]

I was incorrectly setting a page size in my controller action...this was preventing the return of all data.

 

Issue resolved.

[Dimiter Madjarov]

Hello David,

Thanks for the update. I am glad the issue is resolved.

Regards,
Dimiter Madjarov
Telerik