excel.allPagesBoolean(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
allPagesis set totrueit 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/service/v2/core/products"
}
},
pageSize: 10
},
pageable: true
});
</script>In this article