Matrix.SetRow
-------------

Sets a row to the given texts.

| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
|---|---|---|---|---|---|---|
| [Matrix](component_Matrix.md) | [9.2](newinversion92.md) | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |

MBS( "Matrix.SetRow"; MatrixRef; Row { ; Values } ) 

**MBS**( **"Matrix.SetRow";** /\* Sets a row to the given texts. \*/  
**$MatrixRef**; /\* The matrix reference number.e.g. $matrix \*/   
**$Row**; /\* The zero based row number.e.g. 2 \*/   
**$Values**) /\* Optional; The list of values.e.g. "1¶2" \*/ 

### Parameters

| Parameter | Description | Example | Flags |
|---|---|---|---|
| MatrixRef | The matrix reference number. | $matrix |  |
| Row | The zero based row number. | 2 |  |
| Values | The list of values. | "1¶2" | Optional |

### Result

Returns OK or error.

### Description

Sets a row to the given texts.  
If less values are given, the other values in the column are filled with empty values.  
### Examples

Sets rows:

 Set Variable \[ $r ; Value: MBS ( "Matrix.SetRow"; $result ; 3; "98¶43¶12¶69" ) \]   
Set Variable \[ $r ; Value: MBS ( "Matrix.SetRow"; $result ; 4; "89¶466¶45¶8" ) \]  
### See also

- [Matrix.AddRow](MatrixAddRow.md)
- [Matrix.AddRows](MatrixAddRows.md)
- [Matrix.Append](MatrixAppend.md)
- [Matrix.CopyContent](MatrixCopyContent.md)
- [Matrix.Evaluate](MatrixEvaluate.md)
- [Matrix.GetRow](MatrixGetRow.md)
- [Matrix.GetRowNames](MatrixGetRowNames.md)
- [Matrix.InsertRow](MatrixInsertRow.md)
- [Matrix.SetRowName](MatrixSetRowName.md)
- [XL.Sheet.CellWriteMatrix](XLSheetCellWriteMatrix.md)

### Release notes

- **Version 12.5**
    - Added [Matrix.SetColumnNames](https://www.mbsplugins.eu/MatrixSetColumnNames.shtml) and [Matrix.SetRowNames](https://www.mbsplugins.eu/MatrixSetRowNames.shtml) functions.

### Blog Entries

- [MBS FileMaker Plugin 15.3 News](https://www.mbsplugins.de/archive/2025-07-29/MBS_FileMaker_Plugin_153_News/monkeybreadsoftware_blog_filemaker)
- [New in MBS FileMaker Plugin 14.0](https://www.mbsplugins.de/archive/2024-01-23/New_in_MBS_FileMaker_Plugin_14/monkeybreadsoftware_blog_filemaker)
- [CSV in FileMaker with MBS FileMaker Plugin](https://www.mbsplugins.de/archive/2022-10-11/CSV_in_FileMaker_with_MBS_File/monkeybreadsoftware_blog_filemaker)
- [Matrix functions for FileMaker](https://www.mbsplugins.de/archive/2019-05-28/Matrix_functions_for_FileMaker/monkeybreadsoftware_blog_filemaker)

### FileMaker Magazin

- [Ausgabe 4/2019, Seite 31](https://filemaker-magazin.de/neuigkeit/4053-Appetithappen-FMM_201904)

This function checks for a license.

Created 8th April 2019 , last changed 17th December 2019

  
[Matrix.SetColumnNames](MatrixSetColumnNames.md) - [Matrix.SetRowName](MatrixSetRowName.md)

[HTML Version](MatrixSetRow.shtml)