# SpreadsheetSetRepeatingRows

Sets rows to repeat on every printed page of a spreadsheet.

## Method Signature

```
SpreadsheetSetRepeatingRows(spreadsheetObj=[any], startRow=[any], endRow=[any])
```

### Arguments

| Argument         | Type      | Required | Description                        | Default |
| ---------------- | --------- | -------- | ---------------------------------- | ------- |
| `spreadsheetObj` | `ANY`     | `true`   | The spreadsheet object.            |         |
| `startRow`       | `NUMERIC` | `true`   | The starting row number (1-based). |         |
| `endRow`         | `NUMERIC` | `true`   | The ending row number (1-based).   |         |

## Examples

Set repeating rows for printing:

```js
// Repeat header row on each page
var spreadsheet = SpreadsheetNew();
SpreadsheetSetRepeatingRows( spreadsheet, "1:1" );
```

## Related

* [SpreadsheetSetRepeatingColumns()](https://boxlang.ortusbooks.com/boxlang-framework/boxlang-plus/modules/bx-spreadsheet/reference/built-in-functions/spreadsheetsetrepeatingcolumns) - Set columns
* [SpreadsheetSetHeader()](https://boxlang.ortusbooks.com/boxlang-framework/boxlang-plus/modules/bx-spreadsheet/reference/built-in-functions/spreadsheetsetheader) - Set header