SpreadsheetSheetBuilder
Methods
DataSource(System.Action)
Sets the data source configuration of the grid.
Parameters
configurator - System.Action<DataSourceBuilder>
The lambda which configures the data source
Example
@( Html.Kendo().Spreadsheet()
.Name("spreadsheet")
.Sheets(sheets =>
{
sheets.Add()
.Name("Products")
.DataSource<SpreadsheetProductViewModel>(ds => ds
.Custom()
.Batch(true)
.Transport(t => t
.Read("onRead")
.Submit("onSubmit")
)
.Events(e => e.Change("onChange"))
.Schema(s => s
.Model(m =>
{
m.Id(p => p.ProductID);
})
)
)
})
)
ActiveCell(System.String)
The active cell in the sheet, for example, A1.
Parameters
value - System.String
The value for ActiveCell
Name(System.String)
The name of the sheet.
Parameters
value - System.String
The value for Name
Columns(System.Action)
An array which defines the columns in this sheet and their content.
Parameters
configurator - System.Action<SpreadsheetSheetColumnFactory>
The configurator for the columns setting.
Drawings(System.Action)
An array which contains the drawings used in this sheet.
Parameters
configurator - System.Action<SpreadsheetSheetDrawingFactory>
The configurator for the drawings setting.
Filter(System.Action)
Defines the filtering criteria for this sheet, if any.
Parameters
configurator - System.Action<SpreadsheetSheetFilterSettingsBuilder>
The configurator for the filter setting.
FrozenColumns(System.Int32)
The number of frozen columns in this sheet.
Parameters
value - System.Int32
The value for FrozenColumns
FrozenRows(System.Int32)
The number of frozen rows in this sheet.
Parameters
value - System.Int32
The value for FrozenRows
MergedCells(System.String[])
An array of merged cell ranges, for example, B1:D2.
Parameters
value - System.String[]
The value for MergedCells
Rows(System.Action)
The row data for this sheet.
Parameters
configurator - System.Action<SpreadsheetSheetRowFactory>
The configurator for the rows setting.
Selection(System.String)
The selected range in the sheet, for example, A1:B10.
Parameters
value - System.String
The value for Selection
ShowGridLines(System.Boolean)
A Boolean value which indicates if the grid lines of the sheet will be displayed.
Parameters
value - System.Boolean
The value for ShowGridLines
Sort(System.Action)
Defines the sort criteria for the sheet.
Parameters
configurator - System.Action<SpreadsheetSheetSortSettingsBuilder>
The configurator for the sort setting.