---
url: 'https://adk.nht.io/api/@nhtio/adk/batteries/media/interfaces/SheetNamespace.md'
description: '`sheet.*` verbs, mirrored from the verb table.'
---

# Interface: SheetNamespace

Defined in: [src/batteries/media/builder.ts:241](https://github.com/NHTIO/ADK/blob/v1.20260713.1/src/src/batteries/media/builder.ts#L241)

`sheet.*` verbs, mirrored from the verb table.

## Methods

### addColumns()

```ts
addColumns(options: {
  after?: number;
  before?: number;
  columns?: {
     header: string;
     values?: (string | number | boolean | null)[];
  }[];
  headers?: string[];
  sheet?: string | number;
}): MediaChain;
```

Defined in: [src/batteries/media/builder.ts:262](https://github.com/NHTIO/ADK/blob/v1.20260713.1/src/src/batteries/media/builder.ts#L262)

Insert columns.

#### Parameters

| Parameter          | Type                                                                                                                                                                                                        |
| ------------------ | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `options`          | { `after?`: `number`; `before?`: `number`; `columns?`: { `header`: `string`; `values?`: (`string` | `number` | `boolean` | `null`)\[]; }\[]; `headers?`: `string`\[]; `sheet?`: `string` | `number`; } |
| `options.after?`   | `number`                                                                                                                                                                                                    |
| `options.before?`  | `number`                                                                                                                                                                                                    |
| `options.columns?` | { `header`: `string`; `values?`: (`string` | `number` | `boolean` | `null`)\[]; }\[]                                                                                                                     |
| `options.headers?` | `string`\[]                                                                                                                                                                                                  |
| `options.sheet?`   | `string` | `number`                                                                                                                                                                                        |

#### Returns

[`MediaChain`](../classes/MediaChain.md)

***

### addRows()

```ts
addRows(rows: (string | number | boolean | null)[][], options?: {
  after?: number;
  before?: number;
  sheet?: string | number;
}): MediaChain;
```

Defined in: [src/batteries/media/builder.ts:247](https://github.com/NHTIO/ADK/blob/v1.20260713.1/src/src/batteries/media/builder.ts#L247)

Insert rows.

#### Parameters

| Parameter         | Type                                                                           |
| ----------------- | ------------------------------------------------------------------------------ |
| `rows`            | (`string` | `number` | `boolean` | `null`)\[]\[]                              |
| `options`         | { `after?`: `number`; `before?`: `number`; `sheet?`: `string` | `number`; } |
| `options.after?`  | `number`                                                                       |
| `options.before?` | `number`                                                                       |
| `options.sheet?`  | `string` | `number`                                                           |

#### Returns

[`MediaChain`](../classes/MediaChain.md)

***

### addSheet()

```ts
addSheet(name: string, options?: {
  at?: number;
}): MediaChain;
```

Defined in: [src/batteries/media/builder.ts:300](https://github.com/NHTIO/ADK/blob/v1.20260713.1/src/src/batteries/media/builder.ts#L300)

Add a worksheet.

#### Parameters

| Parameter     | Type                   |
| ------------- | ---------------------- |
| `name`        | `string`               |
| `options`     | { `at?`: `number`; } |
| `options.at?` | `number`               |

#### Returns

[`MediaChain`](../classes/MediaChain.md)

***

### deleteColumns()

```ts
deleteColumns(columns: number[], options?: {
  sheet?: string | number;
}): MediaChain;
```

Defined in: [src/batteries/media/builder.ts:292](https://github.com/NHTIO/ADK/blob/v1.20260713.1/src/src/batteries/media/builder.ts#L292)

Delete columns by 1-based index.

#### Parameters

| Parameter        | Type                                  |
| ---------------- | ------------------------------------- |
| `columns`        | `number`\[]                            |
| `options`        | { `sheet?`: `string` | `number`; } |
| `options.sheet?` | `string` | `number`                  |

#### Returns

[`MediaChain`](../classes/MediaChain.md)

***

### deleteRows()

```ts
deleteRows(rows: number[], options?: {
  sheet?: string | number;
}): MediaChain;
```

Defined in: [src/batteries/media/builder.ts:288](https://github.com/NHTIO/ADK/blob/v1.20260713.1/src/src/batteries/media/builder.ts#L288)

Delete rows by 1-based index.

#### Parameters

| Parameter        | Type                                  |
| ---------------- | ------------------------------------- |
| `rows`           | `number`\[]                            |
| `options`        | { `sheet?`: `string` | `number`; } |
| `options.sheet?` | `string` | `number`                  |

#### Returns

[`MediaChain`](../classes/MediaChain.md)

***

### removeSheet()

```ts
removeSheet(sheet: string): MediaChain;
```

Defined in: [src/batteries/media/builder.ts:304](https://github.com/NHTIO/ADK/blob/v1.20260713.1/src/src/batteries/media/builder.ts#L304)

Remove a worksheet (name-targeted).

#### Parameters

| Parameter | Type     |
| --------- | -------- |
| `sheet`   | `string` |

#### Returns

[`MediaChain`](../classes/MediaChain.md)

***

### renameSheet()

```ts
renameSheet(sheet: string, to: string): MediaChain;
```

Defined in: [src/batteries/media/builder.ts:296](https://github.com/NHTIO/ADK/blob/v1.20260713.1/src/src/batteries/media/builder.ts#L296)

Rename a worksheet (name-targeted).

#### Parameters

| Parameter | Type     |
| --------- | -------- |
| `sheet`   | `string` |
| `to`      | `string` |

#### Returns

[`MediaChain`](../classes/MediaChain.md)

***

### reorderSheets()

```ts
reorderSheets(order: (string | number)[]): MediaChain;
```

Defined in: [src/batteries/media/builder.ts:308](https://github.com/NHTIO/ADK/blob/v1.20260713.1/src/src/batteries/media/builder.ts#L308)

Reorder worksheets by names and/or 1-based indices.

#### Parameters

| Parameter | Type                     |
| --------- | ------------------------ |
| `order`   | (`string` | `number`)\[] |

#### Returns

[`MediaChain`](../classes/MediaChain.md)

***

### transformTable()

```ts
transformTable(options: {
  drop?: string[];
  headerRow?: number;
  rename?: {
     from: string;
     to: string;
  }[];
  select?: string[];
  sheet?: string | number;
}): MediaChain;
```

Defined in: [src/batteries/media/builder.ts:312](https://github.com/NHTIO/ADK/blob/v1.20260713.1/src/src/batteries/media/builder.ts#L312)

Table transforms by header name.

#### Parameters

| Parameter            | Type                                                                                                                                                            |
| -------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `options`            | { `drop?`: `string`\[]; `headerRow?`: `number`; `rename?`: { `from`: `string`; `to`: `string`; }\[]; `select?`: `string`\[]; `sheet?`: `string` | `number`; } |
| `options.drop?`      | `string`\[]                                                                                                                                                      |
| `options.headerRow?` | `number`                                                                                                                                                        |
| `options.rename?`    | { `from`: `string`; `to`: `string`; }\[]                                                                                                                       |
| `options.select?`    | `string`\[]                                                                                                                                                      |
| `options.sheet?`     | `string` | `number`                                                                                                                                            |

#### Returns

[`MediaChain`](../classes/MediaChain.md)

***

### updateCells()

```ts
updateCells(updates: CellUpdate[], options?: {
  sheet?: string | number;
}): MediaChain;
```

Defined in: [src/batteries/media/builder.ts:281](https://github.com/NHTIO/ADK/blob/v1.20260713.1/src/src/batteries/media/builder.ts#L281)

Update cells.

#### Parameters

| Parameter        | Type                                  |
| ---------------- | ------------------------------------- |
| `updates`        | [`CellUpdate`](CellUpdate.md)\[]       |
| `options`        | { `sheet?`: `string` | `number`; } |
| `options.sheet?` | `string` | `number`                  |

#### Returns

[`MediaChain`](../classes/MediaChain.md)