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.2   10.3   10.4   10.5   11.0   11.1   11.2   11.3   11.4   11.5    Statistic    FMM    Blog  

XL.Sheet.CellReadValues

Reads all the values from cells in an area.

Component Version macOS Windows Linux Server iOS SDK
XL 11.5 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "XL.Sheet.CellReadValues"; bookRef; sheetIndex; First row; Last row; First column; Last column { ; Row Delimiter; Column Delimiter } )   More

Parameters

Parameter Description Example Flags
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
First row The first row to process. First row has index 0. 3
Last row The last row to process. First row has index 0. 6
First column The first column to process. First column has index 0. 2
Last column The last column to process. First column has index 0. 4
Row Delimiter The row delimiter for the result.
Default is new line character.
"¶" Optional
Column Delimiter The column delimiter for the result.
Default is tab character.
char(9) Optional

Result

Returns list of values or error.

Description

Reads all the values from cells in an area.
Depending on content we return number, boolean, text or timestamp.
Empty, blank or error cells will return empty value.
Numbers and dates are formatted by FileMaker, so they should be in localized format.

See also

Release notes

  • Version 11.5
    • Added XL.Sheet.CellReadValues function.

Blog Entries

Created 18th September 2021, last changed 18th September 2021


XL.Sheet.CellReadValue - XL.Sheet.CellType

Feedback: Report problem or ask question.




Links
MBS FileMaker tutorial videos

Start Chat