sheets.filter Object (default: null)

Excel auto filter configuration. When set the final document will have auto filtering enabled.

Example - enable 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
Not finding the help you need?