> ## 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: Shapes and pictures

## `GeometricShape`

`Excel.GeometricShape`.

Import from `@reductoai/xlsx/officejs`.

### GeometricShape properties

| Name | Type | Description |
| - | - | - |
| `id` | `string` | read-only |
| `shape` | `ExcelShape` | read-only |

## `GroupShapeCollection`

`Excel.GroupShapeCollection`: a group's members, bottom first.

Import from `@reductoai/xlsx/officejs`.

### GroupShapeCollection properties

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

### `GroupShapeCollection.getCount()`

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

### `GroupShapeCollection.getItem()`

```ts theme={null}
getItem(key: string): ExcelShape
```

By name, ignoring case, or by id.

### `GroupShapeCollection.getItemAt()`

```ts theme={null}
getItemAt(index: number): ExcelShape
```

### `GroupShapeCollection.getItemOrNullObject()`

```ts theme={null}
getItemOrNullObject(key: string): Nullable<ExcelShape>
```

## `HeaderFooterPicture`

`Excel.HeaderFooterPicture`: the picture a `&G` in its section shows. A file host cannot
fetch a path, so `filename` takes the image as base64 or a `data:` URL; "" removes it.

Import from `@reductoai/xlsx/officejs`.

### HeaderFooterPicture properties

| Name | Type | Description |
| - | - | - |
| `brightness` | `number` | |
| `colorType` | `PictureColorType` | |
| `contrast` | `number` | |
| `cropBottom` | `number` | |
| `cropLeft` | `number` | |
| `cropRight` | `number` | |
| `cropTop` | `number` | |
| `filename` | `string` | |
| `height` | `number` | |
| `lockAspectRatio` | `boolean` | |
| `width` | `number` | |

### `HeaderFooterPicture.set()`

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

## `Line`

`Excel.Line`.

Import from `@reductoai/xlsx/officejs`.

### Line properties

| Name | Type | Description |
| - | - | - |
| `beginArrowheadLength` | `ArrowheadLength` | |
| `beginArrowheadStyle` | `ArrowheadStyle` | |
| `beginArrowheadWidth` | `ArrowheadWidth` | |
| `beginConnectedShape` | `ExcelShape` | read-only |
| `beginConnectedSite` | `number \| null` | read-only |
| `connectorType` | `ConnectorType` | |
| `endArrowheadLength` | `ArrowheadLength` | |
| `endArrowheadStyle` | `ArrowheadStyle` | |
| `endArrowheadWidth` | `ArrowheadWidth` | |
| `endConnectedShape` | `ExcelShape` | read-only |
| `endConnectedSite` | `number \| null` | read-only |
| `id` | `string` | read-only |
| `isBeginConnected` | `boolean` | read-only |
| `isEndConnected` | `boolean` | read-only |
| `shape` | `ExcelShape` | read-only |

### `Line.connectBeginShape()`

```ts theme={null}
connectBeginShape(shape: ExcelShape, connectionSite: number): void
```

### `Line.connectEndShape()`

```ts theme={null}
connectEndShape(shape: ExcelShape, connectionSite: number): void
```

### `Line.disconnectBeginShape()`

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

### `Line.disconnectEndShape()`

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

### `Line.set()`

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

## `ShapeFont`

`Excel.ShapeFont`: `null` when the runs of the range differ.

Import from `@reductoai/xlsx/officejs`.

### ShapeFont properties

| Name | Type | Description |
| - | - | - |
| `bold` | `boolean \| null` | |
| `color` | `string \| null` | |
| `italic` | `boolean \| null` | |
| `name` | `string \| null` | |
| `size` | `number \| null` | |
| `underline` | `ShapeFontUnderlineStyle \| null` | |

### `ShapeFont.set()`

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

## `ShapeGroup`

`Excel.ShapeGroup`.

Import from `@reductoai/xlsx/officejs`.

### ShapeGroup properties

| Name | Type | Description |
| - | - | - |
| `id` | `string` | read-only |
| `shape` | `ExcelShape` | read-only |
| `shapes` | `GroupShapeCollection` | read-only |

### `ShapeGroup.ungroup()`

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

Each member becomes a top-level shape where the group stood, at the same place.
