XL.Sheet.CellReadValues
-----------------------

Reads all the values from cells in an area.

| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
|---|---|---|---|---|---|---|
| [XL](component_XL.md) | [11.5](newinversion115.md) | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |

MBS( "XL.Sheet.CellReadValues"; BookRef; SheetIndex; First row; Last row; First column; Last column { ; Row Delimiter; Column Delimiter } ) 

**MBS**( **"XL.Sheet.CellReadValues";** /\* Reads all the values from cells in an area. \*/  
**$BookRef**; /\* The reference number for the workbook.e.g. $ref \*/   
**$SheetIndex**; /\* The index of the sheet. This number ranges from 0 to [XL.Book.SheetCount](XLBookSheetCount.md)-1.e.g. 0 \*/   
**$First row**; /\* The first row to process. First row has index 0.e.g. 3 \*/   
**$Last row**; /\* The last row to process. First row has index 0.e.g. 6 \*/   
**$First column**; /\* The first column to process. First column has index 0.e.g. 2 \*/   
**$Last column**; /\* The last column to process. First column has index 0.e.g. 4 \*/   
**$Row Delimiter**; /\* Optional; The row delimiter for the result.  
Default is new line character.e.g. "¶" \*/   
**$Column Delimiter**) /\* Optional; The column delimiter for the result.  
Default is tab character.e.g. char(9) \*/ 

### Parameters

| Parameter | Description | Example | Flags |
|---|---|---|---|
| BookRef | The reference number for the workbook. | $ref |  |
| SheetIndex | The index of the sheet. This number ranges from 0 to [XL.Book.SheetCount](XLBookSheetCount.md)-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

- [XL.Book.SheetCount](XLBookSheetCount.md)
- [XL.Sheet.CellReadComments](XLSheetCellReadComments.md)
- [XL.Sheet.CellReadDate](XLSheetCellReadDate.md)
- [XL.Sheet.CellReadDates](XLSheetCellReadDates.md)
- [XL.Sheet.CellReadFormula](XLSheetCellReadFormula.md)
- [XL.Sheet.CellReadFormulas](XLSheetCellReadFormulas.md)
- [XL.Sheet.CellReadNumber](XLSheetCellReadNumber.md)
- [XL.Sheet.CellReadNumbers](XLSheetCellReadNumbers.md)
- [XL.Sheet.CellReadText](XLSheetCellReadText.md)
- [XL.Sheet.CellReadTexts](XLSheetCellReadTexts.md)

### Release notes

- **Version 11.5**
    - Added [XL.Sheet.CellReadValues](https://www.mbsplugins.eu/XLSheetCellReadValues.shtml) function.

### Blog Entries

- [New in version 11.5 of MBS FileMaker Plugin](https://www.mbsplugins.de/archive/2021-11-30/New_in_version_115_of_MBS_File/monkeybreadsoftware_blog_filemaker)
- [MBS FileMaker Plugin, version 11.5pr1](https://www.mbsplugins.de/archive/2021-10-01/MBS_FileMaker_Plugin_version_1/monkeybreadsoftware_blog_filemaker)

This function checks for a license.

Created 18th September 2021 , last changed 29th January 2023

  
[XL.Sheet.CellReadValue](XLSheetCellReadValue.md) - [XL.Sheet.CellType](XLSheetCellType.md)

[HTML Version](XLSheetCellReadValues.shtml)