New to Telerik UI for ASP.NET Core? Download free 30-day trial

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

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.

In this article
Not finding the help you need?