Class: Worksheet

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:71

The model of a Worksheet.

Constructors

new Worksheet()

new Worksheet(
   unitId, 
   snapshot, 
   _styles): Worksheet

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:83

Parameters

Parameter	Type
`unitId`	`string`
`snapshot`	`Partial`<`IWorksheetData`>
`_styles`	`Styles`

Returns

Worksheet

Properties

Property	Modifier	Type	Defined in
`_cellData`	`protected`	`ObjectMatrix`<`ICellData`>	packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:74
`_columnManager`	`protected`	`ColumnManager`	packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:77
`_rowManager`	`protected`	`RowManager`	packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:76
`_sheetId`	`protected`	`string`	packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:72
`_snapshot`	`protected`	`IWorksheetData`	packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:73
`_spanModel`	`protected`	`SpanModel`	packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:81
`_viewModel`	`readonly`	`SheetViewModel`	packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:79
`unitId`	`readonly`	`string`	packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:84

Methods

__interceptViewModel()

__interceptViewModel(callback): void

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:105

Internal

Parameters

Parameter	Type
`callback`	(`viewModel`) => `void`

Returns

void

cellHasValue()

cellHasValue(value): boolean

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:872

Parameters

Parameter	Type
`value`	`ICellData`

Returns

boolean

clone()

clone(): Worksheet

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:364

Returns WorkSheet Clone Object

Returns

Worksheet

WorkSheet Clone Object

Deprecated

getBlankCellDocumentModel()

getBlankCellDocumentModel(cell): IDocumentLayoutObject

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:1178

Only used for cell edit, and no need to rotate text when edit cell content!

Parameters

Parameter	Type
`cell`	`Nullable`<`ICellData`>

Returns

IDocumentLayoutObject

getCell()

getCell(row, col): Nullable<ICellDataForSheetInterceptor>

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:490

Get cellData, includes cellData, customRender, markers, dataValidate, etc.

WARNING: All sheet CELL_CONTENT interceptors will be called in this method, cause performance issue. example: this._sheetInterceptorService.intercept(INTERCEPTOR_POINT.CELL_CONTENT);

Parameters

Parameter	Type
`row`	`number`
`col`	`number`

Returns

Nullable<ICellDataForSheetInterceptor>

ICellDataForSheetInterceptor

getCellDocumentModelWithFormula()

getCellDocumentModelWithFormula(cell): Nullable<IDocumentLayoutObject>

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:1217

Parameters

Parameter	Type
`cell`	`ICellData`

Returns

Nullable<IDocumentLayoutObject>

getCellInfoInMergeData()

getCellInfoInMergeData(row, column): ISelectionCell

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:436

Get cell info with merge data

Parameters

Parameter	Type	Description
`row`	`number`	The row index of the cell.
`column`	`number`	The column index of the cell.

Returns

ISelectionCell

The cell info with merge data

getCellMatrix()

getCellMatrix(): ObjectMatrix<Nullable<ICellData>>

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:229

Returns WorkSheet Cell Data Matrix

Returns

ObjectMatrix<Nullable<ICellData>>

WorkSheet Cell Data Matrix

getCellMatrixPrintRange()

getCellMatrixPrintRange(): 
  | null
  | {
  endColumn: number;
  endRow: number;
  startColumn: number;
  startRow: number;
}

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:238

Get worksheet printable cell range.

Returns

| null | { endColumn: number; endRow: number; startColumn: number; startRow: number; }

getCellRaw()

getCellRaw(row, col): Nullable<ICellData>

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:526

Parameters

Parameter	Type
`row`	`number`
`col`	`number`

Returns

Nullable<ICellData>

getCellStyleOnly()

getCellStyleOnly(row, col): Nullable<ICellDataForSheetInterceptor>

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:518

Get cellData only use effect on style interceptor

Parameters

Parameter	Type	Description
`row`	`number`	The row index of the cell.
`col`	`number`	The column index of the cell.

Returns

Nullable<ICellDataForSheetInterceptor>

The cell data only use effect on style interceptor

getCellValueOnly()

getCellValueOnly(row, col): Nullable<ICellDataForSheetInterceptor>

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:504

Get cellData only use effect on value interceptor

Parameters

Parameter	Type
`row`	`number`
`col`	`number`

Returns

Nullable<ICellDataForSheetInterceptor>

The cell data only use effect on value interceptor

getCellWithFilteredInterceptors()

getCellWithFilteredInterceptors(
   row, 
   col, 
   key, 
filter): Nullable<ICellDataForSheetInterceptor>

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:531

Parameters

Parameter	Type
`row`	`number`
`col`	`number`
`key`	`string`
`filter`	(`interceptor`) => `boolean`

Returns

Nullable<ICellDataForSheetInterceptor>

getColumnCount()

getColumnCount(): number

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:706

Returns

number

getColumnManager()

getColumnManager(): ColumnManager

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:347

Returns Column Manager

Returns

ColumnManager

Column Manager

getColumnStyle()

getColumnStyle(column, keepRaw?): 
  | string
| Nullable<IStyleData>

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:141

Get the style of the column.

Parameters

Parameter	Type	Default value	Description
`column`	`number`	`undefined`	The column index
`keepRaw`?	`boolean`	`false`	If true, return the raw style data, otherwise return the style data object

Returns

| string | Nullable<IStyleData>

The style of the column

getColumnWidth()

getColumnWidth(columnPosition): number

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:760

Gets the width in pixels of the given column.

Parameters

Parameter	Type	Description
`columnPosition`	`number`	column index

Returns

number

Gets the width in pixels of the given column.

getColVisible()

getColVisible(col): boolean

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:811

Parameters

Parameter	Type
`col`	`number`

Returns

boolean

getConfig()

getConfig(): IWorksheetData

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:664

Returns WorkSheet Configures

Returns

IWorksheetData

WorkSheet Configures

getCustomMetadata()

getCustomMetadata(): CustomData

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:1229

Get custom metadata of worksheet

Returns

CustomData

custom metadata

getDataRangeScope()

getDataRangeScope(): IRange

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:868

Returns

IRange

getDefaultCellStyle()

getDefaultCellStyle(): 
  | string
| Nullable<IStyleData>

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:208

Get the default style of the worksheet.

Returns

| string | Nullable<IStyleData>

Default Style

getDefaultCellStyleInternal()

getDefaultCellStyleInternal(): Nullable<IStyleData>

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:212

Returns

Nullable<IStyleData>

getFreeze()

getFreeze(): IFreeze

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:672

Returns frozen.

Returns

IFreeze

frozen

getGridlinesColor()

getGridlinesColor(): undefined | string

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:740

Returns the color of the gridlines, or undefined if the gridlines are not colored.

Returns

undefined | string

returns the color of the gridlines, or undefined if the gridlines are default.

getHiddenCols()

getHiddenCols(start?, end?): IRange[]

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:815

Parameters

Parameter	Type
`start`?	`number`
`end`?	`number`

Returns

IRange[]

getHiddenRows()

getHiddenRows(start?, end?): IRange[]

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:803

Parameters

Parameter	Type
`start`?	`number`
`end`?	`number`

Returns

IRange[]

getLastColumnWithContent()

getLastColumnWithContent(): number

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:864

Returns the position of the last column that has content.

Returns

number

the position of the last column that has content.

getLastRowWithContent()

getLastRowWithContent(): number

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:856

Returns the position of the last row that has content.

Returns

number

the position of the last row that has content.

getMatrixWithMergedCells()

Call Signature

getMatrixWithMergedCells(
   row, 
   col, 
   endRow, 
endCol): ObjectMatrix<ICellDataWithSpanAndDisplay>

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:548

Get cell matrix from a given range and pick out non-first cells of merged cells.

Notice that ICellData here is not after copying. In another word, the object matrix here should be considered as a slice of the original worksheet data matrix.

Control the v attribute in the return cellData.v through dataMode

Parameters

Parameter	Type
`row`	`number`
`col`	`number`
`endRow`	`number`
`endCol`	`number`

Returns

ObjectMatrix<ICellDataWithSpanAndDisplay>

Call Signature

getMatrixWithMergedCells(
   row, 
   col, 
   endRow, 
   endCol, 
dataMode): ObjectMatrix<ICellDataWithSpanAndDisplay>

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:555

Get cell matrix from a given range and pick out non-first cells of merged cells.

Notice that ICellData here is not after copying. In another word, the object matrix here should be considered as a slice of the original worksheet data matrix.

Control the v attribute in the return cellData.v through dataMode

Parameters

Parameter	Type
`row`	`number`
`col`	`number`
`endRow`	`number`
`endCol`	`number`
`dataMode`	`CellModeEnum`

Returns

ObjectMatrix<ICellDataWithSpanAndDisplay>

getMaxColumns()

getMaxColumns(): number

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:680

Returns the current number of columns in the sheet, regardless of content.

Returns

number

the current number of columns in the sheet, regardless of content

getMaxRows()

getMaxRows(): number

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:691

Returns the current number of rows in the sheet, regardless of content.

Returns

number

the current number of rows in the sheet, regardless of content

getMergeData()

getMergeData(): IRange[]

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:375

Get the merged cell list of the sheet.

Returns

IRange[]

merged cell list

getMergedCell()

getMergedCell(row, col): Nullable<IRange>

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:387

Get the merged cell Range of the sheet cell. If (row, col) is not in a merged cell, return null

Parameters

Parameter	Type	Description
`row`	`number`	The row index of test cell
`col`	`number`	The column index of test cell

Returns

Nullable<IRange>

The merged cell range of the cell, if the cell is not in a merged cell, return null

getMergedCellRange()

getMergedCellRange(
   startRow, 
   startColumn, 
   endRow, 
   endColumn): IRange[]

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:399

Get the merged cell info list which has intersection with the given range.

Parameters

Parameter	Type	Description
`startRow`	`number`	The start row index of the range
`startColumn`	`number`	The start column index of the range
`endRow`	`number`	The end row index of the range
`endColumn`	`number`	The end column index of the range

Returns

IRange[]

The merged cell info list which has intersection with the given range or empty array if no merged cell in the range

getName()

getName(): string

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:355

Returns the name of the sheet.

Returns

string

name of the sheet

getRange()

Call Signature

getRange(range): Range

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:621

Parameters

Parameter	Type
`range`	`IRange`

Returns

Range

Call Signature

getRange(startRow, startColumn): Range

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:622

Parameters

Parameter	Type
`startRow`	`number`
`startColumn`	`number`

Returns

Range

Call Signature

getRange(
   startRow, 
   startColumn, 
   endRow, 
   endColumn): Range

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:623

Parameters

Parameter	Type
`startRow`	`number`
`startColumn`	`number`
`endRow`	`number`
`endColumn`	`number`

Returns

Range

getRowCount()

getRowCount(): number

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:698

Returns

number

getRowFiltered()

getRowFiltered(row): boolean

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:535

Parameters

Parameter	Type
`row`	`number`

Returns

boolean

getRowHeight()

getRowHeight(row): number

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:769

Gets the height in pixels of the given row.

Parameters

Parameter	Type	Description
`row`	`number`	row index

Returns

number

Gets the height in pixels of the given row.

getRowManager()

getRowManager(): RowManager

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:324

Returns Row Manager

Returns

RowManager

Row Manager

getRowRawVisible()

getRowRawVisible(row): boolean

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:799

Get if the row does not have hidden property. This value won’t affected by features like filter and view.

Parameters

Parameter	Type	Description
`row`	`number`	the row index

Returns

boolean

if the row does not have hidden property

getRowStyle()

getRowStyle(row, keepRaw?): 
  | string
| Nullable<IStyleData>

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:163

Get the style of the row.

Parameters

Parameter	Type	Default value	Description
`row`	`number`	`undefined`	The row index
`keepRaw`?	`boolean`	`false`	If true, return the raw style data, otherwise return the style data object

Returns

| string | Nullable<IStyleData>

The style of the row

getRowVisible()

getRowVisible(row): boolean

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:790

Get if the row is visible. It may be affected by features like filter and view.

Parameters

Parameter	Type	Description
`row`	`number`	the row index

Returns

boolean

if the row in visible to the user

getScrollLeftTopFromSnapshot()

getScrollLeftTopFromSnapshot(): {
  scrollLeft: number;
  scrollTop: number;
}

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:645

Returns

{
  scrollLeft: number;
  scrollTop: number;
}

Name	Type	Defined in
`scrollLeft`	`number`	packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:647
`scrollTop`	`number`	packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:648

getSheetId()

getSheetId(): string

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:339

Returns the ID of the sheet represented by this object.

Returns

string

ID of the sheet

getSnapshot()

getSnapshot(): IWorksheetData

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:109

Returns

IWorksheetData

getSpanModel()

getSpanModel(): SpanModel

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:122

Returns

SpanModel

getStyleDataByHash()

getStyleDataByHash(hash): Nullable<IStyleData>

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:126

Parameters

Parameter	Type
`hash`	`string`

Returns

Nullable<IStyleData>

getTabColor()

getTabColor(): Nullable<string>

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:748

Gets the sheet tab color, or null if the sheet tab has no color.

Returns

Nullable<string>

the sheet tab color or null

getUnitId()

getUnitId(): string

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:331

Returns the ID of its parent unit.

Returns

string

getVisibleCols()

getVisibleCols(): IRange[]

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:836

Get all visible columns in the sheet.(not include filter & view)

Returns

IRange[]

Visible columns range list

getVisibleRows()

getVisibleRows(): IRange[]

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:827

Get all visible rows in the sheet.(not include filter & view, like getRawVisibleRows)

Returns

IRange[]

Visible rows range list

getZoomRatio()

getZoomRatio(): number

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:656

Return WorkSheetZoomRatio

Returns

number

zoomRatio

hasHiddenGridlines()

hasHiddenGridlines(): boolean

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:726

Returns true if the sheet’s gridlines are hidden; otherwise returns false. Gridlines are visible by default.

Returns

boolean

Gridlines Hidden Status.

isColumnContainsMergedCell()

isColumnContainsMergedCell(column): boolean

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:417

Get if the column contains merged cell

Parameters

Parameter	Type	Description
`column`	`number`	The column index

Returns

boolean

Is merge cell across column

isRightToLeft()

isRightToLeft(): BooleanNumber

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:845

Returns true if this sheet layout is right-to-left. Returns false if the sheet uses the default left-to-right layout.

Returns

BooleanNumber

true if this sheet layout is right-to-left. Returns false if the sheet uses the default left-to-right layout.

isRowContainsMergedCell()

isRowContainsMergedCell(row): boolean

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:408

Get if the row contains merged cell

Parameters

Parameter	Type	Description
`row`	`number`	The row index

Returns

boolean

Is merge cell across row

isRowFiltered()

isRowFiltered(row): boolean

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:781

Row is filtered out, that means this row is invisible.

Parameters

Parameter	Type
`row`	`number`

Returns

boolean

is row hidden by filter

isSheetHidden()

isSheetHidden(): BooleanNumber

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:718

isSheetHidden

Returns

BooleanNumber

hidden status of sheet

iterateByColumn()

iterateByColumn(
   range, 
   skipEmpty, 
skipNonTopLeft): Iterable<Readonly<ICell>>

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:959

Iterate a range column by column. This is pretty similar to iterateByRow but with different order.

Performance intensive.

Parameters

Parameter	Type	Default value	Description
`range`	`IRange`	`undefined`	The iterate range.
`skipEmpty`	`boolean`	`true`	Whether to skip empty cells, default to be `true`.
`skipNonTopLeft`	`boolean`	`true`	Whether to skip non-top-left cells of merged cells, default to be `true`. If the parameter is set to `false`, the iterator will return cells in the top row.

Returns

Iterable<Readonly<ICell>>

iterateByRow()

iterateByRow(range, skipEmpty): Iterable<Readonly<ICell>>

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:888

Iterate a range row by row.

Performance intensive.

Parameters

Parameter	Type	Default value	Description
`range`	`IRange`	`undefined`	the iterate range
`skipEmpty`	`boolean`	`true`	whether to skip empty cells, default to be `true`

Returns

Iterable<Readonly<ICell>>

mixinDefaultStyleToCellRaw()

mixinDefaultStyleToCellRaw(
   row, 
   col, 
   cellRaw, 
   isRowStylePrecedeColumnStyle): void

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:186

this function is used to mixin default style to cell raw{number}

Parameters

Parameter	Type	Description
`row`	`number`	The row index
`col`	`number`	The column index
`cellRaw`	`Nullable`<`ICellData`>	The cell raw data
`isRowStylePrecedeColumnStyle`	`boolean`	The priority of row style and column style

Returns

void

setColumnCount()

setColumnCount(count): void

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:710

Parameters

Parameter	Type
`count`	`number`

Returns

void

setColumnStyle()

setColumnStyle(column, style): void

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:153

Set the style of the column.

Parameters

Parameter	Type	Description
`column`	`number`	The column index
`style`	\| `string` \| `Nullable`<`IStyleData`>	The style to be set

Returns

void

setCustomMetadata()

setCustomMetadata(custom): void

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:1237

Set custom metadata of workbook

Parameters

Parameter	Type	Description
`custom`	`CustomData`	custom metadata

Returns

void

setDefaultCellStyle()

setDefaultCellStyle(style): void

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:221

Set Default Style, if the style has been set, all cells style will be base on this style.

Parameters

Parameter	Type	Description
`style`	\| `string` \| `Nullable`<`IStyleData`>	The style to be set as default style

Returns

void

setMergeData()

setMergeData(mergeData): void

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:117

Set the merge data of the sheet, all the merged cells will be rebuilt.

Parameters

Parameter	Type
`mergeData`	`IRange`[]

Returns

void

setRowCount()

setRowCount(count): void

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:702

Parameters

Parameter	Type
`count`	`number`

Returns

void

setRowStyle()

setRowStyle(row, style): void

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:175

Set the style of the row.

Parameters

Parameter	Type	Description
`row`	`number`	-
`style`	\| `string` \| `Nullable`<`IStyleData`>	The style to be set

Returns

void

setStyleData()

setStyleData(style): Nullable<string>

Defined in: packages/api/tmp/univer-pro/submodules/univer/packages/core/src/sheets/worksheet.ts:131

Parameters

Parameter	Type
`style`	`IStyleData`

Returns

Nullable<string>

Workbook Absolutereftype