SpreadsheetSheet
Directive
kendo-spreadsheet-sheet
Props
active-cell String
The active cell in the sheet—for example,A1
.
name String
The name of the sheet.
columns Array
The columns in this sheet and their content.
data-source kendo.data.DataSource
The data source instance for this sheet.
data-source-ref String
Assigns a DataSource instance through kendo-datasource
component.
filter-columns Array
Defines the filtering criteria for this sheet (if any).
filter-ref String
The active range for the filter—for example, B1:D8
.
frozen-columns Number
The number of the frozen columns in this sheet.
frozen-rows Number
The number of the frozen rows in this sheet.
merged-cells Array
An array of the merged cell ranges—for example, B1:D2
.
rows Array
The row data for this sheet.
selection String
The selected range in the sheet—for example, A1:B10
.
show-grid-lines Boolean
A Boolean value which indicates if the grid lines of the sheet will be displayed.
sort-columns Array
The sort criteria for the sheet.
sort-ref String
The sorted range—for example, A1:D5
.