> ## Documentation Index
> Fetch the complete documentation index at: https://docs.reducto.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Other classes: Page layout and printing

## `HeaderFooter`

`Excel.HeaderFooter`: one page kind's header and footer, three sections each.

Import from `@reductoai/xlsx/officejs`.

### HeaderFooter properties

| Name | Type | Description |
| - | - | - |
| `centerFooter` | `string` | |
| `centerFooterPicture` | `HeaderFooterPicture` | read-only |
| `centerHeader` | `string` | |
| `centerHeaderPicture` | `HeaderFooterPicture` | read-only |
| `leftFooter` | `string` | |
| `leftFooterPicture` | `HeaderFooterPicture` | read-only |
| `leftHeader` | `string` | |
| `leftHeaderPicture` | `HeaderFooterPicture` | read-only |
| `rightFooter` | `string` | |
| `rightFooterPicture` | `HeaderFooterPicture` | read-only |
| `rightHeader` | `string` | |
| `rightHeaderPicture` | `HeaderFooterPicture` | read-only |

### `HeaderFooter.set()`

```ts theme={null}
set(properties: HeaderFooter | UpdateData<HeaderFooter>, options?: UpdateOptions): void
```

Sets several properties at once; a navigation member takes a nested batch.

## `HeaderFooterGroup`

`Excel.HeaderFooterGroup`: `<headerFooter>`.

Import from `@reductoai/xlsx/officejs`.

### HeaderFooterGroup properties

| Name | Type | Description |
| - | - | - |
| `defaultForAllPages` | `HeaderFooter` | read-only |
| `evenPages` | `HeaderFooter` | read-only |
| `firstPage` | `HeaderFooter` | read-only |
| `oddPages` | `HeaderFooter` | read-only |
| `state` | `HeaderFooterState` | |
| `useSheetMargins` | `boolean` | |
| `useSheetScale` | `boolean` | |

### `HeaderFooterGroup.set()`

```ts theme={null}
set(
  properties: HeaderFooterGroup | UpdateData<HeaderFooterGroup>,
  options?: UpdateOptions,
): void
```

Sets several properties at once; a navigation member takes a nested batch.

## `PageBreak`

`Excel.PageBreak`.

Import from `@reductoai/xlsx/officejs`.

### PageBreak properties

| Name | Type | Description |
| - | - | - |
| `columnIndex` | `number` | read-only The first column after the break; 0 for a horizontal break. |
| `rowIndex` | `number` | read-only The first row after the break; 0 for a vertical break. |

### `PageBreak.delete()`

```ts theme={null}
delete(): void
```

### `PageBreak.getCellAfterBreak()`

```ts theme={null}
getCellAfterBreak(): ExcelRange
```

## `PageBreakCollection`

`Excel.PageBreakCollection`.

Import from `@reductoai/xlsx/officejs`.

### PageBreakCollection properties

| Name | Type | Description |
| - | - | - |
| `items` | `PageBreak[]` | read-only |

### `PageBreakCollection.add()`

```ts theme={null}
add(pageBreakRange: string | ExcelRange): PageBreak
```

A break before the top row (or left column) of the range; the first row or column has none.

### `PageBreakCollection.getCount()`

```ts theme={null}
getCount(): ClientResult<number>
```

### `PageBreakCollection.getItem()`

```ts theme={null}
getItem(index: number): PageBreak
```

### `PageBreakCollection.removePageBreaks()`

```ts theme={null}
removePageBreaks(): void
```

Removes every manual break of this direction.
