@univerjs/sheets-filter v0.5.1 • Docs

Class: FWorksheetFilter

FBase is a base class for all facade classes. It provides a way to extend classes with static and instance methods. The _initialize as a special method that will be called after the constructor. You should never call it directly.

Extends

FWorksheet

Implements

IFWorksheetFilter

Constructors

new FWorksheetFilter()

new FWorksheetFilter(
   _fWorkbook, 
   _workbook, 
   _worksheet, 
   _injector, 
   _selectionManagerService, 
   _commandService): FWorksheetFilter

Parameters

Parameter	Type
`_fWorkbook`	`FWorkbook`
`_workbook`	`Workbook`
`_worksheet`	`Worksheet`
`_injector`	`Injector`
`_selectionManagerService`	`SheetsSelectionsService`
`_commandService`	`ICommandService`

Returns

FWorksheetFilter

Inherited from

FWorksheet.constructor

Defined in

sheets/src/facade/f-worksheet.ts:28

Properties

Property	Modifier	Type	Description	Inherited from	Defined in
`_commandService`	`readonly`	`ICommandService`	-	`FWorksheet`.`_commandService`	sheets/src/facade/f-worksheet.ts:34
`_fWorkbook`	`readonly`	`FWorkbook`	-	`FWorksheet`.`_fWorkbook`	sheets/src/facade/f-worksheet.ts:29
`_injector`	`readonly`	`Injector`	-	`FWorksheet`.`_injector`	sheets/src/facade/f-worksheet.ts:32
`_selectionManagerService`	`readonly`	`SheetsSelectionsService`	-	`FWorksheet`.`_selectionManagerService`	sheets/src/facade/f-worksheet.ts:33
`_workbook`	`readonly`	`Workbook`	-	`FWorksheet`.`_workbook`	sheets/src/facade/f-worksheet.ts:30
`_worksheet`	`readonly`	`Worksheet`	-	`FWorksheet`.`_worksheet`	sheets/src/facade/f-worksheet.ts:31
`setActiveSelection`	`public`	(`range`: `FRange`) => `void`	Sets the active selection region for this sheet. Param The range to set as the active selection.	`FWorksheet`.`setActiveSelection`	sheets/src/facade/f-worksheet.ts:1003

Methods

_initialize()

_initialize(): void

Returns

void

Inherited from

FWorksheet._initialize

Defined in

core/src/facade/f-base.ts:33

cancelFreeze()

cancelFreeze(): boolean

Cancels the frozen state of the current sheet.

Returns

boolean

True if the command was successful, false otherwise.

Inherited from

FWorksheet.cancelFreeze

Defined in

sheets/src/facade/f-worksheet.ts:1022

deleteColumn()

deleteColumn(columnPosition): Promise<FWorksheet>

Deletes the column at the given column position.

Parameters

Parameter	Type	Description
`columnPosition`	`number`	The position of the column, starting at 0 for the first column.

Returns

Promise<FWorksheet>

This sheet, for chaining.

Inherited from

FWorksheet.deleteColumn

Defined in

sheets/src/facade/f-worksheet.ts:738

deleteColumns()

deleteColumns(columnPosition, howMany): Promise<FWorksheet>

Deletes a number of columns starting at the given column position.

Parameters

Parameter	Type	Description
`columnPosition`	`number`	The position of the first column to delete, starting at 0 for the first column.
`howMany`	`number`	The number of columns to delete.

Returns

Promise<FWorksheet>

This sheet, for chaining.

Inherited from

FWorksheet.deleteColumns

Defined in

sheets/src/facade/f-worksheet.ts:748

deleteRow()

deleteRow(rowPosition): Promise<FWorksheet>

Deletes the row at the given row position.

Parameters

Parameter	Type	Description
`rowPosition`	`number`	The position of the row, starting at 0 for the first row.

Returns

Promise<FWorksheet>

This sheet, for chaining.

Inherited from

FWorksheet.deleteRow

Defined in

sheets/src/facade/f-worksheet.ts:370

deleteRows()

deleteRows(rowPosition, howMany): Promise<FWorksheet>

Deletes a number of rows starting at the given row position.

Parameters

Parameter	Type	Description
`rowPosition`	`number`	The position of the first row to delete, starting at 0 for the first row.
`howMany`	`number`	The number of rows to delete.

Returns

Promise<FWorksheet>

This sheet, for chaining.

Inherited from

FWorksheet.deleteRows

Defined in

sheets/src/facade/f-worksheet.ts:380

getActiveRange()

getActiveRange(): null | FRange

Returns the selected range in the active sheet, or null if there is no active range.

Returns

null | FRange

the active range

Inherited from

FWorksheet.getActiveRange

Defined in

sheets/src/facade/f-worksheet.ts:981

getCellMergeData()

getCellMergeData(row, column): undefined | FRange

Get the merged cell data of the specified row and column.

Parameters

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

Returns

undefined | FRange

The merged cell data, or undefined if the cell is not merged.

Inherited from

FWorksheet.getCellMergeData

Defined in

sheets/src/facade/f-worksheet.ts:967

getColumnDefaultStyle()

getColumnDefaultStyle(index, keepRaw?): string | Nullable<IStyleData>

Get the default style of the worksheet column

Parameters

Parameter	Type	Default value	Description
`index`	`number`	`undefined`	The column index
`keepRaw`?	`boolean`	`false`	If true, return the raw style data maybe the style name or style data, otherwise return the data from col manager

Returns

string | Nullable<IStyleData>

The default style of the worksheet column name or style data

Inherited from

FWorksheet.getColumnDefaultStyle

Defined in

sheets/src/facade/f-worksheet.ts:108

getDefaultStyle()

getDefaultStyle(): string | Nullable<IStyleData>

Get the default style of the worksheet

Returns

string | Nullable<IStyleData>

Default style

Inherited from

FWorksheet.getDefaultStyle

Defined in

sheets/src/facade/f-worksheet.ts:88

getFilter()

getFilter(): null | FFilter

Returns

null | FFilter

Implementation of

IFWorksheetFilter.getFilter

Overrides

FWorksheet.getFilter

Defined in

sheets-filter/src/facade/f-worksheet.ts:28

getFreeze()

getFreeze(): IFreeze

Get the freeze state of the current sheet.

Returns

IFreeze

The freeze state of the current sheet.

Inherited from

FWorksheet.getFreeze

Defined in

sheets/src/facade/f-worksheet.ts:1034

getFrozenColumns()

getFrozenColumns(): number

Get the number of frozen columns.

Returns

number

The number of frozen columns. Returns 0 if no columns are frozen.

Inherited from

FWorksheet.getFrozenColumns

Defined in

sheets/src/facade/f-worksheet.ts:1071

getFrozenRows()

getFrozenRows(): number

Get the number of frozen rows.

Returns

number

The number of frozen rows. Returns 0 if no rows are frozen.

Inherited from

FWorksheet.getFrozenRows

Defined in

sheets/src/facade/f-worksheet.ts:1084

getInject()

getInject(): Injector

Returns the injector

Returns

Injector

The injector

Inherited from

FWorksheet.getInject

Defined in

sheets/src/facade/f-worksheet.ts:43

getMaxColumns()

getMaxColumns(): number

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

Returns

number

The maximum columns count of the sheet

Inherited from

FWorksheet.getMaxColumns

Defined in

sheets/src/facade/f-worksheet.ts:255

getMaxRows()

getMaxRows(): number

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

Returns

number

The maximum rows count of the sheet

Inherited from

FWorksheet.getMaxRows

Defined in

sheets/src/facade/f-worksheet.ts:263

getMergedRanges()

getMergedRanges(): FRange[]

Get all merged cells in the current sheet

Returns

FRange[]

all merged cells

Inherited from

FWorksheet.getMergedRanges

Defined in

sheets/src/facade/f-worksheet.ts:956

getRange()

getRange(row, column)

getRange(row, column): FRange

Returns a Range object representing a single cell at the specified row and column.

Parameters

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

Returns

FRange

A Range object representing the specified cell.

Inherited from

FWorksheet.getRange

Defined in

sheets/src/facade/f-worksheet.ts:183

getRange(row, column, numRows)

getRange(
   row, 
   column, 
   numRows): FRange

Returns a Range object representing a range starting at the specified row and column, with the specified number of rows.

Parameters

Parameter	Type	Description
`row`	`number`	The starting row index of the range.
`column`	`number`	The starting column index of the range.
`numRows`	`number`	The number of rows in the range.

Returns

FRange

A Range object representing the specified range.

Inherited from

FWorksheet.getRange

Defined in

sheets/src/facade/f-worksheet.ts:191

getRange(row, column, numRows, numColumns)

getRange(
   row, 
   column, 
   numRows, 
   numColumns): FRange

Returns a Range object representing a range starting at the specified row and column, with the specified number of rows and columns.

Parameters

Parameter	Type	Description
`row`	`number`	The starting row index of the range.
`column`	`number`	The starting column index of the range.
`numRows`	`number`	The number of rows in the range.
`numColumns`	`number`	The number of columns in the range.

Returns

FRange

A Range object representing the specified range.

Inherited from

FWorksheet.getRange

Defined in

sheets/src/facade/f-worksheet.ts:200

getRange(a1Notation)

getRange(a1Notation): FRange

Returns a Range object specified by A1 notation.

Parameters

Parameter	Type	Description
`a1Notation`	`string`	A string representing a range in A1 notation.

Returns

FRange

A Range object representing the specified range.

Inherited from

FWorksheet.getRange

Defined in

sheets/src/facade/f-worksheet.ts:206

getRowDefaultStyle()

getRowDefaultStyle(index, keepRaw?): string | Nullable<IStyleData>

Get the default style of the worksheet row

Parameters

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

Returns

string | Nullable<IStyleData>

The default style of the worksheet row name or style data

Inherited from

FWorksheet.getRowDefaultStyle

Defined in

sheets/src/facade/f-worksheet.ts:98

getSelection()

getSelection(): null | FSelection

Returns

null | FSelection

Inherited from

FWorksheet.getSelection

Defined in

sheets/src/facade/f-worksheet.ts:71

getSheetId()

getSheetId(): string

Returns the worksheet id

Returns

string

The id of the worksheet

Inherited from

FWorksheet.getSheetId

Defined in

sheets/src/facade/f-worksheet.ts:59

getSheetName()

getSheetName(): string

Returns the worksheet name

Returns

string

The name of the worksheet

Inherited from

FWorksheet.getSheetName

Defined in

sheets/src/facade/f-worksheet.ts:67

getWorkbook()

getWorkbook(): Workbook

Returns the workbook

Returns

Workbook

The workbook

Inherited from

FWorksheet.getWorkbook

Defined in

sheets/src/facade/f-worksheet.ts:51

hasHiddenGridLines()

hasHiddenGridLines(): boolean

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

Returns

boolean

Inherited from

FWorksheet.hasHiddenGridLines

Defined in

sheets/src/facade/f-worksheet.ts:1095

hideColumn()

hideColumn(column): Promise<FWorksheet>

Hides the column or columns in the given range.

Parameters

Parameter	Type	Description
`column`	`FRange`	The column range to hide.

Returns

Promise<FWorksheet>

This sheet, for chaining.

Inherited from

FWorksheet.hideColumn

Defined in

sheets/src/facade/f-worksheet.ts:797

hideColumns()

hideColumns(columnIndex, numColumns): Promise<FWorksheet>

Hides one or more consecutive columns starting at the given index. Use 0-index for this method.

Parameters

Parameter	Type	Default value	Description
`columnIndex`	`number`	`undefined`	The starting index of the columns to hide.
`numColumns`	`number`	`1`	The number of columns to hide.

Returns

Promise<FWorksheet>

This sheet, for chaining.

Inherited from

FWorksheet.hideColumns

Defined in

sheets/src/facade/f-worksheet.ts:817

hideRow()

hideRow(row): Promise<FWorksheet>

Hides the rows in the given range.

Parameters

Parameter	Type	Description
`row`	`FRange`	The row range to hide.

Returns

Promise<FWorksheet>

This sheet, for chaining.

Inherited from

FWorksheet.hideRow

Defined in

sheets/src/facade/f-worksheet.ts:429

hideRows()

hideRows(rowIndex, numRows): Promise<FWorksheet>

Hides one or more consecutive rows starting at the given index. Use 0-index for this method.

Parameters

Parameter	Type	Default value	Description
`rowIndex`	`number`	`undefined`	The starting index of the rows to hide.
`numRows`	`number`	`1`	The number of rows to hide.

Returns

Promise<FWorksheet>

This sheet, for chaining.

Inherited from

FWorksheet.hideRows

Defined in

sheets/src/facade/f-worksheet.ts:449

insertColumnAfter()

insertColumnAfter(afterPosition): Promise<FWorksheet>

Inserts a column after the given column position.

Parameters

Parameter	Type	Description
`afterPosition`	`number`	The column after which the new column should be added, starting at 0 for the first column.

Returns

Promise<FWorksheet>

This sheet, for chaining.

Inherited from

FWorksheet.insertColumnAfter

Defined in

sheets/src/facade/f-worksheet.ts:640

insertColumnBefore()

insertColumnBefore(beforePosition): Promise<FWorksheet>

Inserts a column before the given column position.

Parameters

Parameter	Type	Description
`beforePosition`	`number`	The column before which the new column should be added, starting at 0 for the first column.

Returns

Promise<FWorksheet>

This sheet, for chaining.

Inherited from

FWorksheet.insertColumnBefore

Defined in

sheets/src/facade/f-worksheet.ts:649

insertColumns()

insertColumns(columnIndex, numColumns): Promise<FWorksheet>

Inserts one or more consecutive blank columns in a sheet starting at the specified location.

Parameters

Parameter	Type	Default value	Description
`columnIndex`	`number`	`undefined`	The index indicating where to insert a column, starting at 0 for the first column.
`numColumns`	`number`	`1`	The number of columns to insert.

Returns

Promise<FWorksheet>

This sheet, for chaining.

Inherited from

FWorksheet.insertColumns

Defined in

sheets/src/facade/f-worksheet.ts:659

insertColumnsAfter()

insertColumnsAfter(afterPosition, howMany): Promise<FWorksheet>

Inserts a given number of columns after the given column position.

Parameters

Parameter	Type	Description
`afterPosition`	`number`	The column after which the new column should be added, starting at 0 for the first column.
`howMany`	`number`	The number of columns to insert.

Returns

Promise<FWorksheet>

This sheet, for chaining.

Inherited from

FWorksheet.insertColumnsAfter

Defined in

sheets/src/facade/f-worksheet.ts:669

insertColumnsBefore()

insertColumnsBefore(beforePosition, howMany): Promise<FWorksheet>

Inserts a number of columns before the given column position.

Parameters

Parameter	Type	Description
`beforePosition`	`number`	The column before which the new column should be added, starting at 0 for the first column.
`howMany`	`number`	The number of columns to insert.

Returns

Promise<FWorksheet>

This sheet, for chaining.

Inherited from

FWorksheet.insertColumnsBefore

Defined in

sheets/src/facade/f-worksheet.ts:704

insertRowAfter()

insertRowAfter(afterPosition): Promise<FWorksheet>

Inserts a row after the given row position.

Parameters

Parameter	Type	Description
`afterPosition`	`number`	The row after which the new row should be added, starting at 0 for the first row.

Returns

Promise<FWorksheet>

This sheet, for chaining.

Inherited from

FWorksheet.insertRowAfter

Defined in

sheets/src/facade/f-worksheet.ts:272

insertRowBefore()

insertRowBefore(beforePosition): Promise<FWorksheet>

Inserts a row before the given row position.

Parameters

Parameter	Type	Description
`beforePosition`	`number`	The row before which the new row should be added, starting at 0 for the first row.

Returns

Promise<FWorksheet>

This sheet, for chaining.

Inherited from

FWorksheet.insertRowBefore

Defined in

sheets/src/facade/f-worksheet.ts:281

insertRows()

insertRows(rowIndex, numRows): Promise<FWorksheet>

Inserts one or more consecutive blank rows in a sheet starting at the specified location.

Parameters

Parameter	Type	Default value	Description
`rowIndex`	`number`	`undefined`	The index indicating where to insert a row, starting at 0 for the first row.
`numRows`	`number`	`1`	The number of rows to insert.

Returns

Promise<FWorksheet>

This sheet, for chaining.

Inherited from

FWorksheet.insertRows

Defined in

sheets/src/facade/f-worksheet.ts:291

insertRowsAfter()

insertRowsAfter(afterPosition, howMany): Promise<FWorksheet>

Inserts a number of rows after the given row position.

Parameters

Parameter	Type	Description
`afterPosition`	`number`	The row after which the new rows should be added, starting at 0 for the first row.
`howMany`	`number`	The number of rows to insert.

Returns

Promise<FWorksheet>

This sheet, for chaining.

Inherited from

FWorksheet.insertRowsAfter

Defined in

sheets/src/facade/f-worksheet.ts:301

insertRowsBefore()

insertRowsBefore(beforePosition, howMany): Promise<FWorksheet>

Inserts a number of rows before the given row position.

Parameters

Parameter	Type	Description
`beforePosition`	`number`	The row before which the new rows should be added, starting at 0 for the first row.
`howMany`	`number`	The number of rows to insert.

Returns

Promise<FWorksheet>

This sheet, for chaining.

Inherited from

FWorksheet.insertRowsBefore

Defined in

sheets/src/facade/f-worksheet.ts:336

moveColumns()

moveColumns(columnSpec, destinationIndex): Promise<FWorksheet>

Moves the columns selected by the given range to the position indicated by the destinationIndex. The columnSpec itself does not have to exactly represent an entire column or group of columns to move—it selects all columns that the range spans.

Parameters

Parameter	Type	Description
`columnSpec`	`FRange`	A range spanning the columns that should be moved.
`destinationIndex`	`number`	The index that the columns should be moved to. Note that this index is based on the coordinates before the columns are moved. Existing data is shifted right to make room for the moved columns while the source columns are removed from the grid. Therefore, the data may end up at a different index than originally specified. Use 0-index for this method.

Returns

Promise<FWorksheet>

This sheet, for chaining.

Inherited from

FWorksheet.moveColumns

Defined in

sheets/src/facade/f-worksheet.ts:769

moveRows()

moveRows(rowSpec, destinationIndex): Promise<FWorksheet>

Moves the rows selected by the given range to the position indicated by the destinationIndex. The rowSpec itself does not have to exactly represent an entire row or group of rows to move—it selects all rows that the range spans.

Parameters

Parameter	Type	Description
`rowSpec`	`FRange`	A range spanning the rows that should be moved.
`destinationIndex`	`number`	The index that the rows should be moved to. Note that this index is based on the coordinates before the rows are moved. Existing data is shifted down to make room for the moved rows while the source rows are removed from the grid. Therefore, the data may end up at a different index than originally specified. Use 0-index for this method.

Returns

Promise<FWorksheet>

This sheet, for chaining.

Inherited from

FWorksheet.moveRows

Defined in

sheets/src/facade/f-worksheet.ts:401

onBeforeCellDataChange()

onBeforeCellDataChange(callback): IDisposable

Subscribe to the cell data change event.

Parameters

Parameter	Type	Description
`callback`	(`cellValue`) => `void`	The callback function to be executed before the cell data changes.

Returns

IDisposable

A disposable object to unsubscribe from the event.

Inherited from

FWorksheet.onBeforeCellDataChange

Defined in

sheets/src/facade/f-worksheet.ts:1137

onCellDataChange()

onCellDataChange(callback): IDisposable

Subscribe to the cell data change event.

Parameters

Parameter	Type	Description
`callback`	(`cellValue`) => `void`	The callback function to be executed when the cell data changes.

Returns

IDisposable

A disposable object to unsubscribe from the event.

Inherited from

FWorksheet.onCellDataChange

Defined in

sheets/src/facade/f-worksheet.ts:1116

setActiveRange()

setActiveRange(range): void

Sets the active selection region for this sheet.

Parameters

Parameter	Type	Description
`range`	`FRange`	The range to set as the active selection.

Returns

void

Inherited from

FWorksheet.setActiveRange

Defined in

sheets/src/facade/f-worksheet.ts:989

setColumnCustom()

setColumnCustom(custom): Promise<FWorksheet>

Set custom properties for given columns.

Parameters

Parameter	Type	Description
`custom`	`IObjectArrayPrimitiveType`<`CustomData`>	The custom properties to set.

Returns

Promise<FWorksheet>

This sheet, for chaining.

Inherited from

FWorksheet.setColumnCustom

Defined in

sheets/src/facade/f-worksheet.ts:928

setColumnDefaultStyle()

setColumnDefaultStyle(index, style): Promise<FWorksheet>

Set the default style of the worksheet row

Parameters

Parameter	Type	Description
`index`	`number`	The row index
`style`	`string` \| `Nullable`<`IStyleData`>	The style name or style data

Returns

Promise<FWorksheet>

Inherited from

FWorksheet.setColumnDefaultStyle

Defined in

sheets/src/facade/f-worksheet.ts:134

setColumnWidth()

setColumnWidth(columnPosition, width): Promise<FWorksheet>

Sets the width of the given column in pixels.

Parameters

Parameter	Type	Description
`columnPosition`	`number`	The position of the given column to set.
`width`	`number`	The width in pixels to set it to.

Returns

Promise<FWorksheet>

This sheet, for chaining.

Inherited from

FWorksheet.setColumnWidth

Defined in

sheets/src/facade/f-worksheet.ts:888

setColumnWidths()

setColumnWidths(
   startColumn, 
   numColumns, 
width): Promise<FWorksheet>

Sets the width of the given columns in pixels.

Parameters

Parameter	Type	Description
`startColumn`	`number`	The starting column position to change.
`numColumns`	`number`	The number of columns to change.
`width`	`number`	The width in pixels to set it to.

Returns

Promise<FWorksheet>

This sheet, for chaining.

Inherited from

FWorksheet.setColumnWidths

Defined in

sheets/src/facade/f-worksheet.ts:899

setDefaultStyle()

setDefaultStyle(style): Promise<FWorksheet>

Set the default style of the worksheet

Parameters

Parameter	Type	Description
`style`	`string`	default style

Returns

Promise<FWorksheet>

this worksheet

Inherited from

FWorksheet.setDefaultStyle

Defined in

sheets/src/facade/f-worksheet.ts:117

setFreeze()

setFreeze(freeze): boolean

Sets the frozen state of the current sheet.

Parameters

Parameter	Type	Description
`freeze`	`IFreeze`	The freeze object containing the parameters for freezing the sheet.

Returns

boolean

True if the command was successful, false otherwise.

Inherited from

FWorksheet.setFreeze

Defined in

sheets/src/facade/f-worksheet.ts:1010

setFrozenColumns()

setFrozenColumns(columns): void

Set the number of frozen columns.

Parameters

Parameter	Type	Description
`columns`	`number`	The number of columns to freeze. To unfreeze all columns, set this value to 0.

Returns

void

Inherited from

FWorksheet.setFrozenColumns

Defined in

sheets/src/facade/f-worksheet.ts:1043

setFrozenRows()

setFrozenRows(rows): void

Set the number of frozen rows.

Parameters

Parameter	Type	Description
`rows`	`number`	The number of rows to freeze. To unfreeze all rows, set this value to 0.

Returns

void

Inherited from

FWorksheet.setFrozenRows

Defined in

sheets/src/facade/f-worksheet.ts:1057

setHiddenGridlines()

setHiddenGridlines(hidden): Promise<boolean>

Hides or reveals the sheet gridlines.

Parameters

Parameter	Type	Description
`hidden`	`boolean`	If `true`, hide gridlines in this sheet; otherwise show the gridlines.

Returns

Promise<boolean>

Inherited from

FWorksheet.setHiddenGridlines

Defined in

sheets/src/facade/f-worksheet.ts:1103

setRowCustom()

setRowCustom(custom): Promise<FWorksheet>

Set custom properties for given rows.

Parameters

Parameter	Type	Description
`custom`	`IObjectArrayPrimitiveType`<`CustomData`>	The custom properties to set.

Returns

Promise<FWorksheet>

This sheet, for chaining.

Inherited from

FWorksheet.setRowCustom

Defined in

sheets/src/facade/f-worksheet.ts:611

setRowDefaultStyle()

setRowDefaultStyle(index, style): Promise<FWorksheet>

Set the default style of the worksheet column

Parameters

Parameter	Type	Description
`index`	`number`	The column index
`style`	`string` \| `Nullable`<`IStyleData`>	The style name or style data

Returns

Promise<FWorksheet>

Inherited from

FWorksheet.setRowDefaultStyle

Defined in

sheets/src/facade/f-worksheet.ts:157

setRowHeight()

setRowHeight(rowPosition, height): Promise<FWorksheet>

Sets the row height of the given row in pixels. By default, rows grow to fit cell contents. If you want to force rows to a specified height, use setRowHeightsForced(startRow, numRows, height).

Parameters

Parameter	Type	Description
`rowPosition`	`number`	The row position to change.
`height`	`number`	The height in pixels to set it to.

Returns

Promise<FWorksheet>

This sheet, for chaining.

Inherited from

FWorksheet.setRowHeight

Defined in

sheets/src/facade/f-worksheet.ts:519

setRowHeights()

setRowHeights(
   startRow, 
   numRows, 
height): Promise<FWorksheet>

Sets the height of the given rows in pixels. By default, rows grow to fit cell contents. If you want to force rows to a specified height, use setRowHeightsForced(startRow, numRows, height).

Parameters

Parameter	Type	Description
`startRow`	`number`	The starting row position to change.
`numRows`	`number`	The number of rows to change.
`height`	`number`	The height in pixels to set it to.

Returns

Promise<FWorksheet>

This sheet, for chaining.

Inherited from

FWorksheet.setRowHeights

Defined in

sheets/src/facade/f-worksheet.ts:530

setRowHeightsForced()

setRowHeightsForced(
   startRow, 
   numRows, 
height): Promise<FWorksheet>

Sets the height of the given rows in pixels. By default, rows grow to fit cell contents. When you use setRowHeightsForced, rows are forced to the specified height even if the cell contents are taller than the row height.

Parameters

Parameter	Type	Description
`startRow`	`number`	The starting row position to change.
`numRows`	`number`	The number of rows to change.
`height`	`number`	The height in pixels to set it to.

Returns

Promise<FWorksheet>

This sheet, for chaining.

Inherited from

FWorksheet.setRowHeightsForced

Defined in

sheets/src/facade/f-worksheet.ts:582

showColumns()

showColumns(columnIndex, numColumns): Promise<FWorksheet>

Unhides one or more consecutive columns starting at the given index. Use 0-index for this method.

Parameters

Parameter	Type	Default value	Description
`columnIndex`	`number`	`undefined`	The starting index of the columns to unhide.
`numColumns`	`number`	`1`	The number of columns to unhide.

Returns

Promise<FWorksheet>

This sheet, for chaining.

Inherited from

FWorksheet.showColumns

Defined in

sheets/src/facade/f-worksheet.ts:862

showRows()

showRows(rowIndex, numRows): Promise<FWorksheet>

Unhides one or more consecutive rows starting at the given index. Use 0-index for this method.

Parameters

Parameter	Type	Default value	Description
`rowIndex`	`number`	`undefined`	The starting index of the rows to unhide.
`numRows`	`number`	`1`	The number of rows to unhide.

Returns

Promise<FWorksheet>

This sheet, for chaining.

Inherited from

FWorksheet.showRows

Defined in

sheets/src/facade/f-worksheet.ts:493

unhideColumn()

unhideColumn(column): Promise<FWorksheet>

Unhides the column in the given range.

Parameters

Parameter	Type	Description
`column`	`FRange`	The range to unhide, if hidden.

Returns

Promise<FWorksheet>

This sheet, for chaining.

Inherited from

FWorksheet.unhideColumn

Defined in

sheets/src/facade/f-worksheet.ts:842

unhideRow()

unhideRow(row): Promise<FWorksheet>

Unhides the row in the given range.

Parameters

Parameter	Type	Description
`row`	`FRange`	The range to unhide, if hidden.

Returns

Promise<FWorksheet>

This sheet, for chaining.

Inherited from

FWorksheet.unhideRow

Defined in

sheets/src/facade/f-worksheet.ts:473

extend()

static extend(source): void

Parameters

Parameter	Type
`source`	`any`

Returns

void

Inherited from

FWorksheet.extend

Defined in

core/src/facade/f-base.ts:35

Frangefilter Ifrangefilter