Edit this page

excel.allPages Boolean (default: false)

If set to true the grid will export all pages of data. By default the grid exports only the current page.

If the grid is bound to remote data and allPages is set to true it will request all data items from the remote service. Be careful if you have a lot of data.

Example - export all pages of data

<div id="grid"></div>
<script>
$("#grid").kendoGrid({
    toolbar: ["excel"],
    excel: {
        allPages: true
    },
    dataSource: {
        transport: {
            read: {
                url: "https://demos.telerik.com/kendo-ui/service/products",
                dataType: "jsonp"
            }
        },
        pageSize: 10
    },
    pageable: true
});
</script>