Definition
Namespace:Telerik.Web.UI
Inheritance: Telerik.Web.UI.SpreadsheetSheet
Methods
Deletes the contents of the column at the provided index and shifts the remaining contents of the sheet to the left.
deleteColumn(Number index): voidThe zero-based index of the column
Deletes the contents of the row at the provided index and shifts the remaining contents of the sheet up.
deleteRow(Number index): voidThe zero-based index of the row
Gets the width of the column at the given index.
get_columnWidth(): NumberNumber
Gets the amount of frozen columns displayed by the sheet.
get_frozenColumns(): NumberNumber
The current frozen columns. By default, returns 0.
Gets the amount of frozen rows displayed by the sheet.
get_frozenRows(): NumberNumber
Returns a Range for the given range specification.
get_range(String rangeString): Telerik.Web.UI.SpreadsheetRangeA1 or RC notation reference of the cells. ex. "A1:B2"
Returns:Telerik.Web.UI.SpreadsheetRange
Gets the default row height in pixels.
get_rowHeight(): NumberNumber
Returns a range with the current active selection.
get_selection(): Telerik.Web.UI.SpreadsheetRangeTelerik.Web.UI.SpreadsheetRange
Hides the column at the provided index.
hideColumn(Number index): voidThe zero-based index of the column.
Hides the row at the provided index.
hideRow(Number index): voidThe zero-based index of the row
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.
insertColumn(Number index): voidThe zero-based index of the column
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.
insertRow(Number index): voidThe zero-based index of the row
Sets or sets the width of the column at the given index.
set_columnWidth(Number colIndex, Number width): voidThe zero-based index of the column
widthNumberIf passed, the method will set the width of the column at the passed index.
Sets the amount of frozen columns displayed by the sheet.
set_frozenColumns(Number count): NumberThe amount of columns to be frozen. Pass 0 to remove the frozen pane.
Returns:Number
Sets the amount of frozen rows displayed by the sheet.
set_frozenRows(Number count): voidThe amount of columns to be frozen. Pass 0 to remove the frozen pane.
Sets the default row height in pixels.
set_rowHeight(Number index, Number width): voidThe zero-based index of the row
widthNumberIf passed, the method will set the height of the row at the passed index.