Last Updated: 31 Mar 2021 10:52 by ADMIN
Release 2020.R3
Created on: 27 Mar 2020 17:30
Category: TreeList
Type: Bug Report
Excel export AllPages option missing

Dear support,

Your documentation clearly states that there is an option to export all pages:

Exporting All Data

By default, the Telerik UI TreeList for ASP.NET MVC exports only the current page of data. To export all pages, set the AllPages option to true.

@(Html.Kendo().TreeList<Kendo.Mvc.Examples.Models.TreeList.EmployeeDirectoryModel>() .Name("treelist") .Toolbar(tools => tools.Excel()) .Excel(excel => excel.AllPages(true)) .DataSource(dataSource => dataSource .Read(read => read.Action("All", "EmployeeDirectory")) ) )


However, when I try this, AllPages gives a compiler error:

Severity Code Description Project File Line Suppression State
Error CS1061 'TreeListExcelSettingsBuilder<dynamic>' does not contain a definition for 'AllPages' and no accessible extension method 'AllPages' accepting a first argument of type 'TreeListExcelSettingsBuilder<dynamic>' could be found (are you missing a using directive or an assembly reference?) StarPMWeb C:\TFS2015\StarPMWeb\StarPMWeb.root\MAIN\Enhancements\WIPProvisions_MR\StarPMWeb\Areas\WIPPROVISIONS\Views\ParentChildPeriod\_RenderParentChildEditPeriodGrid.cshtml 706 Active

Why is this happening? Is your documentation just wrong?

I am using version 2020.1.114

If this AllPages option is not currently implemented, can you please add this to the roadmap? It seems to be a strange omission.


Posted on: 30 Mar 2020 11:32

Many thanks.

Your suggested workround works just fine for us.

Posted on: 30 Mar 2020 11:23

Hi Martin,

Thank you for reporting this. This behavior is a bug, and thus, I converted this ticket into a public bug report.

For the time being, as a workaround, you could use JavaScript similar to:

    $(document).ready(function () {
        var treelist = $("#treelist").data("kendoTreeList");

        if (treelist) {
            treelist.options.excel.allPages = true;

Finally, as a small token of gratitude for pointing us to this bug, I updated your Telerik points.


Progress Telerik

Progress is here for your business, like always. Read more about the measures we are taking to ensure business continuity and help fight the COVID-19 pandemic.
Our thoughts here at Progress are with those affected by the outbreak.