Topics   All   MacOS (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server   Client   Old   Deprecated   Guides   Examples   Videos
New in version: 10.5   11.0   11.1   11.2   11.3   11.4   11.5   12.0   12.1   12.2    Statistic    FMM    Blog  

XL.Sheet.CellReadValue

Reads a value value from a cell.

Component Version macOS Windows Linux Server iOS SDK License
XL 10.5 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes Paid
MBS( "XL.Sheet.CellReadValue"; bookRef; sheetIndex; Row; Column )   More

Parameters

Parameter Description Example
bookRef The reference to the workbook. Please use XL.LoadBook to load a file. $ref
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 value or error.

Description

Reads a value value from a cell.
Depending on content we return number, boolean, text or timestamp.
Empty, blank or error cells will return empty value.

See also

Release notes

Blog Entries

Created 1st October 2020, last changed 1st October 2020


XL.Sheet.CellReadTexts - XL.Sheet.CellReadValues

Feedback: Report problem or ask question.


Start Chat