# IWorksheetData

> Language fallback: requested `ko-KR`; content is `en-US`.

- Human documentation: [https://docs.univer.ai/ko-KR/reference/types/worksheet-data](https://docs.univer.ai/ko-KR/reference/types/worksheet-data)

- Agent Markdown: [https://docs.univer.ai/ko-KR/reference/types/worksheet-data.md](https://docs.univer.ai/ko-KR/reference/types/worksheet-data.md)

- Requested language: `ko-KR`

- Content language: `en-US`

- Documentation version: `1.0.4`

- Source: [types/worksheet-data.mdx](https://github.com/dream-num/documentation/blob/dev/content/reference/types/worksheet-data.mdx)

---

The data for one worksheet: cells, row and column sizes, merged ranges, and display settings. Workbooks store sheets under `IWorkbookData.sheets`; each key matches the corresponding sheet ID in `sheetOrder`.

## Import

```ts
import type { IWorksheetData } from '@univerjs/core'
```

## Definition

```ts
interface IWorksheetData {
  id: string

  name: string
  tabColor: string

  hidden: WorksheetHiddenState | BooleanNumber
  freeze: IFreeze
  rowCount: number
  columnCount: number
  zoomRatio: number
  scrollTop: number
  scrollLeft: number
  defaultColumnWidth: number
  defaultRowHeight: number

  mergeData: IRange[]

  cellData: IObjectMatrixPrimitiveType<ICellData>
  rowData: IObjectArrayPrimitiveType<Partial<IRowData>>
  columnData: IObjectArrayPrimitiveType<Partial<IColumnData>>

  defaultStyle?: Nullable<IStyleData> | string
  rowHeader: {
    width: number
    hidden?: BooleanNumber
  }
  columnHeader: {
    height: number
    hidden?: BooleanNumber
  }
  showGridlines: BooleanNumber

  gridlinesColor?: string

  backgroundImage?: IWorksheetBackgroundImage
  rightToLeft: BooleanNumber

  custom?: CustomData
}
```

## Fields

### `id`

Required · `string`

Id of the worksheet. This should be unique and immutable across the lifecycle of the worksheet.

### `name`

Required · `string`

Name of the sheet.

### `tabColor`

Required · `string`

### `hidden`

Required · `BooleanNumber | WorksheetHiddenState`

Sheet hiding state: 0 = visible, 1 = hidden, 2 = very hidden.
BooleanNumber remains accepted for existing 0/1 snapshots and integrations.
Use WorksheetHiddenState for new code; do not interpret this as a boolean flag.

### `freeze`

Required · `IFreeze`

### `rowCount`

Required · `number`

### `columnCount`

Required · `number`

### `zoomRatio`

Required · `number`

### `scrollTop`

Required · `number`

### `scrollLeft`

Required · `number`

### `defaultColumnWidth`

Required · `number`

### `defaultRowHeight`

Required · `number`

### `mergeData`

Required · `IRange[]`

All merged cells in this worksheet.

### `cellData`

Required · `IObjectMatrixPrimitiveType<ICellData>`

A matrix storing cell contents by row and column index.

### `rowData`

Required · `IObjectArrayPrimitiveType<Partial<IRowData>>`

### `columnData`

Required · `IObjectArrayPrimitiveType<Partial<IColumnData>>`

### `defaultStyle`

Optional · `string | Nullable<IStyleData>`

### `rowHeader`

Required · `{ width: number; hidden?: BooleanNumber | undefined; }`

### `columnHeader`

Required · `{ height: number; hidden?: BooleanNumber | undefined; }`

### `showGridlines`

Required · `BooleanNumber`

### `gridlinesColor`

Optional · `string | undefined`

Color of the gridlines.

### `backgroundImage`

Optional · `IWorksheetBackgroundImage | undefined`

Image tiled behind the worksheet grid. It is not included when printing.

### `rightToLeft`

Required · `BooleanNumber`

### `custom`

Optional · `CustomData`

User stored custom fields.

## Related types

* [`WorksheetHiddenState`](https://unpkg.com/@univerjs/core/lib/types/sheets/typedef.d.ts)
* [`BooleanNumber`](https://docs.univer.ai/ko-KR/reference/enums/boolean-number.md)
* [`IFreeze`](https://unpkg.com/@univerjs/core/lib/types/sheets/typedef.d.ts)
* [`IRange`](https://docs.univer.ai/ko-KR/reference/types/range.md)
* [`ICellData`](https://docs.univer.ai/ko-KR/reference/types/cell-data.md)
* [`IObjectMatrixPrimitiveType`](https://unpkg.com/@univerjs/core/lib/types/shared/object-matrix.d.ts)
* [`Partial`](https://unpkg.com/@typescript/typescript-darwin-arm64/lib/lib.es5.d.ts)
* [`IRowData`](https://unpkg.com/@univerjs/core/lib/types/sheets/typedef.d.ts)
* [`IObjectArrayPrimitiveType`](https://unpkg.com/@univerjs/core/lib/types/shared/object-matrix.d.ts)
* [`IColumnData`](https://unpkg.com/@univerjs/core/lib/types/sheets/typedef.d.ts)
* [`Nullable`](https://unpkg.com/@univerjs/core/lib/types/shared/types.d.ts)
* [`IStyleData`](https://docs.univer.ai/ko-KR/reference/types/style-data.md)
* [`IWorksheetBackgroundImage`](https://unpkg.com/@univerjs/core/lib/types/sheets/typedef.d.ts)
* [`CustomData`](https://unpkg.com/@univerjs/core/lib/types/sheets/typedef.d.ts)

**Package:** [`@univerjs/core`](https://docs.univer.ai/ko-KR/reference/packages/plugins/univerjs/core.md) · [Type definitions](https://unpkg.com/@univerjs/core/lib/types/sheets/typedef.d.ts)