Skip to main content

ASPxClientSpreadsheet.GetCellValue(colModelIndex, rowModelIndex) Method

Gets the value of the specified cell.

#Declaration

TypeScript
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.

// 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.

See Also