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

Definition

Namespace:Telerik.Web.UI

Inheritance: Telerik.Web.UI.RadWebControlTelerik.Web.UI.RadSpreadsheet

Methods

Returns the index of the specified sheet.

JS
findSheetByIndex(Number index): Telerik.Web.UI.SpreadsheetSheet
Parameters:indexNumberReturns:

Telerik.Web.UI.SpreadsheetSheet

Returns a sheet matching the specified name, if any.

JS
findSheetByName(String name): Telerik.Web.UI.SpreadsheetSheet
Parameters:nameStringReturns:

Telerik.Web.UI.SpreadsheetSheet

Gets the active sheet.

JS
get_activeSheet(): Telerik.Web.UI.SpreadsheetSheet
Returns:

Telerik.Web.UI.SpreadsheetSheet

Returns the Height of the Column Header.

JS
get_columnHeaderHeight(): Number
Returns:

Number

Gets the number of columns in the document.

JS
get_columnsCount(): Number
Returns:

Number

Gets the default column width in pixels. Default value is 64

JS
get_columnWidth(): Number
Returns:

Number

Returns Kendo UI SpreadSheet Widget.

JS
get_kendoWidget(): Object
Returns:

Object

Gets the default Row Header Width.

JS
get_rowHeaderWidth(): Number
Returns:

Number

Gets the default row height in pixels. The default value is 20.

JS
get_rowHeight(): Number
Returns:

Number

Gets the number of rows in the document. The default value is 200.

JS
get_rowsCount(): Number
Returns:

Number

rows count.

Returns an array with the sheets in the workbook.

JS
get_sheets(): Telerik.Web.UI.SpreadsheetSheet
Returns:

Telerik.Web.UI.SpreadsheetSheet

Array

Gets the Data Sheets Object.

JS
get_sheetsData(): Object
Returns:

Object

Inserts a sheet with the specified options.

JS
insertSheet(): Telerik.Web.UI.SpreadsheetSheet
Returns:

Telerik.Web.UI.SpreadsheetSheet

Inserts a sheet with the specified options.

JS
removeSheet(): void

Renames the specified sheet.

JS
renameSheet(Telerik.Web.UI.SpreadsheetSheet sheet): Telerik.Web.UI.SpreadsheetSheet
Parameters:sheetTelerik.Web.UI.SpreadsheetSheet

String The new name of the sheet.

Returns:

Telerik.Web.UI.SpreadsheetSheet

the renamed sheet.

Save changes.

JS
save(): void

Initiates the Excel export.

JS
saveAsExcel(): void

Sets the active sheet.

JS
set_activeSheet(Telerik.Web.UI.SpreadsheetSheet sheet): void
Parameters:sheetTelerik.Web.UI.SpreadsheetSheet

Sets the Height of the Column Header.

JS
set_columnHeaderHeight(Number height): void
Parameters:heightNumber

Sets the number of columns in the document.

JS
set_columnsCount(Number count): void
Parameters:countNumber

Sets the default Row Header Width.

JS
set_rowHeaderWidth(Number headerWidth): void
Parameters:headerWidthNumber

Sets the default row height in pixels. The default value is 20.

JS
set_rowHeight(Number height): void
Parameters:heightNumber

Sets the number of rows in the document. The default value is 200.

JS
set_rowsCount(Number count): void
Parameters:countNumber

Sets the Data Sheets Object.

JS
set_sheetsData(Object data): void
Parameters:dataObject
Not finding the help you need?
Contact Support