Edit this page

Kendo.Mvc.UI.Fluent.SpreadsheetSheetBuilder

Defines the fluent API for configuring the SpreadsheetSheet settings.

Methods

ActiveCell(System.String)

The active cell in the sheet, e.g. "A1".

Parameters

value System.String

The value that configures the activecell.

Name(System.String)

The name of the sheet.

Parameters

value System.String

The value that configures the name.

Columns(System.Action<Kendo.Mvc.UI.Fluent.SpreadsheetSheetColumnFactory>)

An array defining the columns in this sheet and their content.

Parameters

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

The action that configures the columns.

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 action that configures the filter.

FrozenColumns(System.Int32)

The number of frozen columns in this sheet.

Parameters

value System.Int32

The value that configures the frozencolumns.

FrozenRows(System.Int32)

The number of frozen rows in this sheet.

Parameters

value System.Int32

The value that configures the frozenrows.

MergedCells(System.String[])

An array of merged cell ranges, e.g. "B1:D2".

Parameters

value System.String[]

The value that configures the 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 action that configures the rows.

Selection(System.String)

The selected range in the sheet, e.g. "A1:B10".

Parameters

value System.String

The value that configures the selection.

ShowGridLines(System.Boolean)

A boolean value indicating if the sheet grid lines should be displayed.

Parameters

value System.Boolean

The value that configures the 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 action that configures the sort.

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