Kendo.Mvc.UI.Fluent.SpreadsheetSheetBuilder

Defines the fluent API for configuring SpreadsheetSheet

Methods

DataSource(System.Action<Kendo.Mvc.UI.Fluent.DataSourceBuilder<T1>>)

Sets the data source configuration of the grid.

Parameters

configurator System.Action<Kendo.Mvc.UI.Fluent.DataSourceBuilder>

The lambda which configures the data source

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<Kendo.Mvc.UI.Fluent.SpreadsheetSheetColumnFactory>)

An array which defines the columns in this sheet and their content.

Parameters

configurator System.Action<Kendo.Mvc.UI.Fluent.SpreadsheetSheetColumnFactory>

The configurator for the columns setting.

Drawings(System.Action<Kendo.Mvc.UI.Fluent.SpreadsheetSheetDrawingFactory>)

An array which contains the drawings used in this sheet.

Parameters

configurator System.Action<Kendo.Mvc.UI.Fluent.SpreadsheetSheetDrawingFactory>

The configurator for the drawings setting.

Filter(System.Action<Kendo.Mvc.UI.Fluent.SpreadsheetSheetFilterSettingsBuilder>)

Defines the filtering criteria for this sheet, if any.

Parameters

configurator System.Action<Kendo.Mvc.UI.Fluent.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<Kendo.Mvc.UI.Fluent.SpreadsheetSheetRowFactory>)

The row data for this sheet.

Parameters

configurator System.Action<Kendo.Mvc.UI.Fluent.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<Kendo.Mvc.UI.Fluent.SpreadsheetSheetSortSettingsBuilder>)

Defines the sort criteria for the sheet.

Parameters

configurator System.Action<Kendo.Mvc.UI.Fluent.SpreadsheetSheetSortSettingsBuilder>

The configurator for the sort setting.

In this article
Not finding the help you need?