# SpreadsheetSetRowHidden

Sets the hidden state of a row on the active sheet.

## Method Signature

```
SpreadsheetSetRowHidden(spreadsheetObj=[any], row=[any], hide=[any])
```

### Arguments

| Argument         | Type      | Required | Description                                   | Default |
| ---------------- | --------- | -------- | --------------------------------------------- | ------- |
| `spreadsheetObj` | `ANY`     | `true`   | The spreadsheet object.                       |         |
| `row`            | `NUMERIC` | `true`   | The row number (1-based).                     |         |
| `hide`           | `BOOLEAN` | `false`  | True to hide, false to show. Default is true. | true    |

## Examples

Hide a row:

```js
// Hide row 5
var spreadsheet = SpreadsheetNew();
SpreadsheetSetRowHidden( spreadsheet, 5, true );
```

Show hidden rows:

```js
// Unhide row
SpreadsheetSetRowHidden( spreadsheet, 5, false );
```

## Related

* [SpreadsheetSetColumnHidden()](https://boxlang.ortusbooks.com/boxlang-framework/boxlang-plus/modules/bx-spreadsheet/reference/built-in-functions/spreadsheetsetcolumnhidden) - Hide column
* [SpreadsheetSetRowHeight()](https://boxlang.ortusbooks.com/boxlang-framework/boxlang-plus/modules/bx-spreadsheet/reference/built-in-functions/spreadsheetsetrowheight) - Set row height
* [SpreadsheetisRowHidden()](https://boxlang.ortusbooks.com/boxlang-framework/boxlang-plus/modules/bx-spreadsheet/reference/built-in-functions/spreadsheetisrowhidden) - Check if hidden