Edit this page

Telerik.Web.UI.SpreadsheetSheet

Inheritance Hierarchy

Methods

deleteColumn

Deletes the contents of the column at the provided index and shifts the remaining contents of the sheet to the left.

Parameters

index Number

The zero-based index of the column

Returns

None

deleteRow

Deletes the contents of the row at the provided index and shifts the remaining contents of the sheet up.

Parameters

index Number

The zero-based index of the row

Returns

None

get_columnWidth

Gets the width of the column at the given index.

Parameters

Returns

Number

get_frozenColumns

Gets the amount of frozen columns displayed by the sheet.

Parameters

Returns

Number The current frozen columns. By default, returns 0.

get_frozenRows

Gets the amount of frozen rows displayed by the sheet.

Parameters

Returns

Number

get_range

Returns a Range for the given range specification.

Parameters

rangeString String

A1 or RC notation reference of the cells. ex. "A1:B2"

Returns

Telerik.Web.UI.SpreadsheetRange

get_rowHeight

Gets the default row height in pixels.

Parameters

Returns

Number

get_selection

Returns a range with the current active selection.

Parameters

Returns

Telerik.Web.UI.SpreadsheetRange

hideColumn

Hides the column at the provided index.

Parameters

index Number

The zero-based index of the column.

Returns

None

hideRow

Hides the row at the provided index.

Parameters

index Number

The zero-based index of the row

Returns

None

insertColumn

Inserts a new, empty column at the provided index. The contents of the spreadsheet (including the ones in the current column index) are shifted to the right.

Parameters

index Number

The zero-based index of the column

Returns

None

insertRow

Inserts a new, empty row at the provided index. The contents of the spreadsheet (including the ones in the current row index) are shifted down.

Parameters

index Number

The zero-based index of the row

Returns

None

set_columnWidth

Sets or sets the width of the column at the given index.

Parameters

colIndex Number

The zero-based index of the column

width Number

If passed, the method will set the width of the column at the passed index.

Returns

None

set_frozenColumns

Sets the amount of frozen columns displayed by the sheet.

Parameters

count Number

The amount of columns to be frozen. Pass 0 to remove the frozen pane.

Returns

Number

set_frozenRows

Sets the amount of frozen rows displayed by the sheet.

Parameters

count Number

The amount of columns to be frozen. Pass 0 to remove the frozen pane.

Returns

None

set_rowHeight

Sets the default row height in pixels.

Parameters

index Number

The zero-based index of the row

width? Number

If passed, the method will set the height of the row at the passed index.

Returns

None