excel.collapsible Boolean (default: false)

Enables or disables collapsible (grouped) rows, for grids with aggregates.

Example - enable collapsible rows in the output Excel file

<div id="grid"></div>
<script>
 $("#grid").kendoGrid({
   toolbar: ["excel"],
   excel: {
     fileName: "excel-collapsible.xlsx",
     proxyURL: "https://demos.telerik.com/kendo-ui/service/export",
     filterable: true,
     collapsible: true
   },
   dataSource: {
     type: "odata",
     transport: {
       read: "https://demos.telerik.com/kendo-ui/service/Northwind.svc/Products"
     },
     schema:{
       model: {
         fields: {
           UnitsInStock: { type: "number" },
           ProductName: { type: "string" },
           UnitPrice: { type: "number" },
           UnitsOnOrder: { type: "number" },
           UnitsInStock: { type: "number" }
         }
       }
     },
     pageSize: 50,
     group: {
       field: "UnitsInStock", aggregates: [
         { field: "ProductName", aggregate: "count" },
         { field: "UnitPrice", aggregate: "sum"},
         { field: "UnitsOnOrder", aggregate: "average" },
         { field: "UnitsInStock", aggregate: "count" }
       ]
     },
     aggregate: [
       { field: "ProductName", aggregate: "count" },
       { field: "UnitPrice", aggregate: "sum" },
       { field: "UnitsOnOrder", aggregate: "average" },
       { field: "UnitsInStock", aggregate: "min" },
       { field: "UnitsInStock", aggregate: "max" }
     ]
   },
   sortable: true,
   pageable: true,
   groupable: true,
   filterable: true,
   columnMenu: true,
   reorderable: true,
   resizable: true,
   columns: [
     { field: "ProductName", title: "Product Name", aggregates: ["count"], footerTemplate: ({ ProductName }) => `Total Count: ${ProductName.count}`, groupFooterTemplate: ({ ProductName }) => `Count: ${ProductName.count}` },
     { field: "UnitPrice", title: "Unit Price", aggregates: ["sum"] },
     { field: "UnitsOnOrder", title: "Units On Order", aggregates: ["average"], footerTemplate: ({ UnitsOnOrder }) => `Average: ${UnitsOnOrder.average}`,
       groupFooterTemplate: ({ UnitsOnOrder }) => `Average: ${UnitsOnOrder.average}` },
     { field: "UnitsInStock", title: "Units In Stock", aggregates: ["min", "max", "count"], footerTemplate: ({ UnitsInStock }) => `Min: ${UnitsInStock.min} Max: ${UnitsInStock.max}`,
       groupHeaderTemplate: "Units In Stock: ${UnitsInStock.group.value} (Count: ${UnitsInStock.count})" }
   ]
 });
</script>