Components All New MacOS Windows Linux iOS Examples Mac & Win Server Client Guides Statistic FMM Blog Deprecated Old

Reads a number value from a cell.

 Component Version macOS Windows Linux Server iOS SDK XL 3.5 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "XL.Sheet.CellReadNumber"; bookRef; sheetIndex; Row; Column )   More

### Parameters

Parameter Description Example
sheetIndex The index of the sheet. This number ranges from 0 to XL.Book.SheetCount-1. 0
Row The row for the cell. First row has index 0. \$row
Column The column for the cell. First column has index 0. \$column

### Result

Returns number or error message.

### Description

Reads a number value from a cell.

### Examples

Write a formula with result:

# calculate the address like A1 and B1
Set Variable [\$a1; Value: MBS( "XL.Sheet.RowColToAddr"; \$book; \$sheet; \$row; 1; 0; 0)]
Set Variable [\$a2; Value: MBS( "XL.Sheet.RowColToAddr"; \$book; \$sheet; \$row; 2; 0; 0)]
# build the formula
Set Variable [\$formula; Value: "=" & \$a1 & "+" & \$a2 ]
# and we calculate in result based on our data
Set Variable [\$result; Value: MBS( "XL.Sheet.CellReadNumber"; \$book; \$sheet; \$row; 1 ) + MBS( "XL.Sheet.CellReadNumber"; \$book; \$sheet; \$row; 2 ) ]
# write it to the new cell
Set Variable [\$r; Value: MBS( "XL.Sheet.CellWriteFormulaBoolean"; \$book; \$sheet; \$Row; \$Column; \$formula; \$result; \$format ]