New to Telerik UI for ASP.NET MVC? Start a free 30-day trial

SpreadsheetSheet

Class

Definition

Namespace:Kendo.Mvc.UI

Assembly:Kendo.Mvc.dll

Syntax:

public class SpreadsheetSheet : JsonObject

Inheritance: objectJsonObjectSpreadsheetSheet

Inherited Members JsonObject.ToJson()object.GetType()object.MemberwiseClone()object.ToString()object.Equals(object)object.Equals(object, object)object.ReferenceEquals(object, object)object.GetHashCode()...

Constructors

SpreadsheetSheet()

public SpreadsheetSheet()

Properties

ActiveCell

string

The active cell in the sheet, for example, A1.

public string ActiveCell { get; set; }

Columns

List<SpreadsheetSheetColumn>

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

public List<SpreadsheetSheetColumn> Columns { get; set; }

DataSource

public DataSource DataSource { get; set; }

Drawings

List<SpreadsheetSheetDrawing>

An array which contains the drawings used in this sheet.

public List<SpreadsheetSheetDrawing> Drawings { get; set; }

Filter

SpreadsheetSheetFilterSettings

Defines the filtering criteria for this sheet, if any.

public SpreadsheetSheetFilterSettings Filter { get; set; }

FrozenColumns

int?

The number of frozen columns in this sheet.

public int? FrozenColumns { get; set; }

FrozenRows

int?

The number of frozen rows in this sheet.

public int? FrozenRows { get; set; }

MergedCells

string[]

An array of merged cell ranges, for example, B1:D2.

public string[] MergedCells { get; set; }

Name

string

The name of the sheet.

public string Name { get; set; }

Rows

List<SpreadsheetSheetRow>

The row data for this sheet.

public List<SpreadsheetSheetRow> Rows { get; set; }

Selection

string

The selected range in the sheet, for example, A1:B10.

public string Selection { get; set; }

ShowGridLines

bool?

A Boolean value which indicates if the grid lines of the sheet will be displayed.

public bool? ShowGridLines { get; set; }

Sort

SpreadsheetSheetSortSettings

Defines the sort criteria for the sheet.

public SpreadsheetSheetSortSettings Sort { get; set; }

Methods

Serialize(IDictionary<string, object>)

protected override void Serialize(IDictionary<string, object> json)

Parameters:jsonIDictionary<string, object>

Overrides: JsonObject.Serialize(IDictionary<string, object>)