ASPxClientSpreadsheet.GetCellValue(colModelIndex, rowModelIndex) Method

Gets the value of the specified cell.

Declaration

GetCellValue(
    colModelIndex: number,
    rowModelIndex: number
): any

Parameters

Name	Type	Description
colModelIndex	number	The cell’s column index.
rowModelIndex	number	The cell’s row index.

Returns

Type	Description
any	An object that is the specified cell’s value.

Remarks

Call the GetCellValue method to obtain a value of a certain cell based on its column and row index.

JS

// Returns a value of the A5 cell
var value = spreadsheet.GetCellValue(0,4)

The method might return an irrelevant value of the specified cell in the following cases:

• The specified cell is not displayed on the screen. In this case, the method returns the null value.

For a better performance, the client-side control stores the values only for displayed data cells. To get a value of a cell located outside the displayed area, use the PerformCallback(parameter) method.

• The document is used by more than one end-user.

The method returns a value that differs from the value stored on the server side if the document is open and does not receive updates from the server side while another end-user has updated the server-side value.