New to Kendo UI for jQuery? Start a free 30-day trial

Sheets.freezePane

configuration

Deprecated in versions 2015.3 and later. Use frozenColumns and frozenRows instead.

sheets.freezePane

Object

<script>
var workbook = new kendo.ooxml.Workbook({
  sheets: [
      {
          freezePane: {
              colSplit: 2,
              rowSplit: 1
          },
          rows: [
              { cells: [ { value: "Frozen Row" }, { value: "Frozen Row" }, { value: "Frozen Row" } ] },
              { cells: [ { value: "Frozen Col" }, { value: "Frozen Col" }, { value: "Free Cell" } ] },
              { cells: [ { value: "Frozen Col" }, { value: "Frozen Col" }, { value: "Free Cell" } ] }
          ]
      }
  ]
});

workbook.toDataURLAsync().then(function(dataURL) {
  kendo.saveAs({
    dataURI: dataURL,
    fileName: "freeze-pane-example.xlsx"
  });
});
</script>

sheets.freezePane.colSplit

Number

Deprecated in versions 2015.3 and later. Use frozenColumns instead.

Default: 0

<script>
var workbook = new kendo.ooxml.Workbook({
  sheets: [
      {
          freezePane: {
              colSplit: 3
          },
          rows: [
              { cells: [ 
                  { value: "Frozen 1" }, 
                  { value: "Frozen 2" }, 
                  { value: "Frozen 3" }, 
                  { value: "Scrollable" } 
              ] }
          ]
      }
  ]
});

workbook.toDataURLAsync().then(function(dataURL) {
  kendo.saveAs({
    dataURI: dataURL,
    fileName: "col-split-example.xlsx"
  });
});
</script>

sheets.freezePane.rowSplit

Number

Deprecated in versions 2015.3 and later. Use frozenRows instead.

Default: 0

<script>
var workbook = new kendo.ooxml.Workbook({
  sheets: [
      {
          freezePane: {
              rowSplit: 2
          },
          rows: [
              { cells: [ { value: "Header Row 1" } ] },
              { cells: [ { value: "Header Row 2" } ] },
              { cells: [ { value: "Scrollable Data" } ] },
              { cells: [ { value: "More Data" } ] }
          ]
      }
  ]
});

workbook.toDataURLAsync().then(function(dataURL) {
  kendo.saveAs({
    dataURI: dataURL,
    fileName: "row-split-example.xlsx"
  });
});
</script>