sheets.freezePaneObject
Deprecated in versions 2015.3 and later. Use frozenColumns and frozenRows instead.
Example
<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.colSplitNumber(default: 0)
Deprecated in versions 2015.3 and later. Use frozenColumns instead.
Example
<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.rowSplitNumber(default: 0)
Deprecated in versions 2015.3 and later. Use frozenRows instead.
Example
<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>In this article