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

Excel Export With Ajax Paging

5 Answers 391 Views

Grid

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

5 Answers, 1 is accepted

answered on 09 Jun 2015, 01:37 PM

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"))
)
)