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 totrue
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>