sheets.filter Object (default: null)

The configuration of the Excel auto-filter. When set, the final document will be have auto-filtering enabled.

Example - enabling filtering

<script>
var workbook = new kendo.ooxml.Workbook({
  sheets: [
      {
          filter: { from: 0, to: 1 },
          rows: [
            { cells: [ { value: "First Name" }, { value: "Last Name" } ] },
            { cells: [ { value: "John" }, { value: "Doe" } ] },
            { cells: [ { value: "Jane" }, { value: "Doe" } ] }
          ]
      }
  ]
});
kendo.saveAs({
  dataURI: workbook.toDataURL(),
  fileName: "Test.xlsx"
});
</script>

sheets.filter.from Number

The index of the first filterable column.

sheets.filter.to Number

The index of the last filterable column.

In this article